Edit

Share via

Add reporting features to your model-driven app

  • Article

Power Apps apps can include paginated style reports that provide useful business information to the user. These reports are based on SQL Server Reporting Services and provide the same set of features that are available for typical SQL Server Reporting Services reports.

Progress against goals standard report

System reports are available to all users. Individuals who create or otherwise own reports can share them with specific colleagues or teams, or can make the reports available to the organization, so that all users can run them. These reports use FetchXML queries that are proprietary to Microsoft Dataverse and retrieve data to build the report. Reports that you create in a Power Apps app are Fetch-based reports.

Note

Report features don't work with canvas apps or model-driven apps running on mobile devices, such as tablets and phones.

Add reporting to a model-drive app

You can add fetch-based reporting functionality to your app so that users can run, share, create, and edit reports. To do this, you add the report table to your app.

  1. Sign in to Power Apps select Solutions, open the solution you want, and then open the model-driven app where you want to add reporting for editing.
  2. In the app designer, select New > Dataverse table.
  3. In the Select a table list, select the Report table, and then select Add.
  4. Select Save, and then select Publish.

Now the app displays a Reports page where users can view, run, assign, share, and edit the reports they have permission to as well as create new reports using the report wizard.

Model-driven app with reporting added

Options for creating new reports

You can create a new report in one of two ways:

  • Use the Report Wizard. Open a model-driven app that is enabled for reporting, select the Reports page, and then select New to open the Report Wizard to create a new report. The Report Wizard can create table and chart reports, including drill-through reports and top N reports. More information: Create a report using the Report Wizard
  • Use the Report Authoring Extension. You can write new or customize existing fetch-based Reporting Services reports with Visual Studio, SQL Server Data Tools, and the Report Authoring Extension. More information: Create a new report using SQL Server Data Tools

Report visibility

Standard table reports, such as the Accounts Summary report for the account table, are available to all app users. Users who own reports can share them with specific colleagues or teams. System administrators and system customizers can make reports available with organization-wide visibility, so that all users can use them. For information about how to share a report, see Share a report with other users and teams.

Reports in solutions

Reports are solution aware. Adding a report as a component to a solution makes it become a single unit of software that extends Power Apps functionality and the user interface. Only reports that are visible to the organization can be added to solutions.

To find if a report is viewable to the organization: In the list of reports, open a model-driven app, select a report, and then select Edit. On the Administration tab, determine whether Viewable By is set to Organization.

Organization level report visibility.

You can add, import, or export snapshots of reports as part of a solution. In model-driven apps, reports, sub reports, report category, report display area, and report-related row type are considered as components of a report set. When you import a solution update in non-overwrite mode, any updates by the solution to a report will be ignored if any component of the report set has been customized.

Work with reports
Create a report using the Report Wizard
Add a report from outside Power Apps
Edit the default filter of a report