Skip to main content

Microsoft

10 Steps to Integrate Power Apps on Power BI Dashboard

Incorta Analytics

Microsoft Power Apps is an excellent example of a Platform as a Service (PaaS). It allows you to create mobile or tablet apps for internal business users that can run on Android, IOS, and Windows. We can now integrate Power Apps into our Power BI reports using the Power Apps visualization in the Power BI Marketplace. Integrating Power Apps on Power BI Dashboard gives you more analytical and visualization power.

Why do you need Power Apps on the Power BI dashboard?

The best option for users who need to write back in Power BI is to integrate Power Apps and use it as a writeback option.

What are the best ways to Integrate Power Apps on Power BI report?

  • Use URL redirect feature
  • Use Power Apps visual on the report directly
    1. Use the existing canvas app
    2. Create a new canvas app

How to integrate Power Apps on Power BI Dashboard?

  1. Open Power BI Desktop and choose Data Source you want. Here I am selecting Dataverse as it is the ideal data source for Power Apps and supports direct query. Picture3
  2. Select the table and click Load. If the data is formatted, click Transform Data if you want to Perform Transformation on the columns. I am directly loading the data and using Direct Query to reduce the data load time.                                 Picture4Picture7
  3. Create Visuals In the Power BI report.Picture8
  4. Insert Power Apps visual in Power BI report. Picture9
  5. Add parameters to the visual and follow the steps outlined in the Power Apps visual.Picture10
  6. Choose the environment and then create new or choose existing canvas apps.Picture12
  7. It will open the Power Apps editor window in the browser, and the fields you passed in the visual are added as a data source in the canvas app.     Picture13
  8. You can use those fields in the app using PowerBIIntegration.Data.
  9. After creating the app, Click save and publish the canvas app.Picture15
  10. Publish the report, and now you can use Power Apps on the dashboard.Picture16 Picture17

Read More :

This blog is the first part of the integration of Power Apps on Power BI dashboard series. In this part, we saw how to integrate Power Apps on Power BI dashboard. In the next part, we will see how to write back in Power BI using the same canvas app.

Thoughts on “10 Steps to Integrate Power Apps on Power BI Dashboard”

  1. Vishwas Kshirsagar

    Step by step explanation is really helpful for understanding and implementation. Well explained Ankit!!.

  2. Hi Ankit,

    I have one query: we are developing Power BI reports whose data is PostgreSQL, and Power BI is connected to Postgres DB using ODBC driver.
    We have 3 different DBs for Dev, test and Prod. In development phase the reports are built using Dev db. Now we are trying to deploy the reports using deployment pipelines from Dev to Test workspace to reduce the rework, but the datasets should change to Test DB as per the environment. We tried doing this using deployment rules, but since we are using ODBC the deployment rules are not enabled.
    What can be the best way to deploy the reports from dev to higher workspaces?

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Ankit Jangle

Ankit Jangle is an associate technical consultant at Perficient. He has a good knowledge of Power Apps, Power BI, Power Automate, and Power Query. Ankit is a Certified Microsoft Power Platform Apps Maker who is passionate about learning new things.

More from this Author

Follow Us