how to create analytical dashboard based from powerapps data

MEHUL DADIA 0 Reputation points
2026-08-13T12:35:47.88+00:00

how to create analytical dashboard based from powerapps data

SQL Server Analysis Services
SQL Server Analysis Services

A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.

0 comments

2 answers

Sort by: Oldest
Most helpful Newest Oldest

  1. AI answer

    2026-08-13T12:36:02.6266667+00:00

    To create an analytical dashboard from Power Apps data in a model-driven app, create a dashboard and add charts or lists as components.

    A dashboard can display data from Microsoft Dataverse tables and can include up to six components such as charts, grids, IFrames, or web resources.

    For a standard dashboard:

    1. Sign in to Power Apps.
    2. Select Solutions in the left navigation pane, then open an unmanaged solution or create a new one.
    3. On the toolbar, select New > Dashboard.
    4. Choose a layout such as 2-column, 3-column, 4-column, or Power BI embedded.
    5. Enter a name for the dashboard.
    6. In a component area, select the chart or list icon.
    7. In Add Component, select values for Record Type, View, and Chart, then select Add.
    8. Repeat for other components. Up to six components can be added.
    9. Select Save and Close.
    10. On the solution toolbar, select Publish.

    If creating a personal dashboard from the app UI:

    1. Go to Dashboards.
    2. Select New > Dynamics 365 Dashboard.
    3. Choose a layout and select Create.
    4. Name the dashboard.
    5. Add components such as charts.
    6. In Add Component, choose Row Type, View, and Chart.
    7. Select Add for each component.
    8. Save the dashboard.

    Dashboard types:

    • My Dashboards: personal dashboards visible to the creator, and shareable if the security role allows sharing.
    • System Dashboards: created by an administrator or customizer and visible to users after publishing.

    If interactive analysis is needed, interactive dashboards are also available in model-driven apps. These support acting on rows directly from the dashboard and can be configured with streams, views, queues, and visual filters.

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

  2. Erland Sommarskog 137.9K Reputation points MVP Volunteer Moderator
    2026-08-13T12:52:18.5+00:00

    You may get better answers in the Power Platform Community. Or do you explicitly want to create the report in Analysis Services? (I can see that the tag was chose by the AI, so I don't know if it was a conscious choice of yours.)

    I would also recommend that you include some context when you ask questions, so that people can give your more precise answers that meet your needs.

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.