How to integrate a Power BI drillthrough report in a Power App?

[speedramps]

Do you integrate Power BI reports in Power Apps?

If Yes then please can you help me  …

I want to include a Power BI report with a drill through in a Power App.

However, the Power BI drill through button is not working in Power Apps.

This is how to replicate the problem ….

Create a Power BI Desktop report with 2 pages.
Add a table visual and a drill through button on page1.
So when the user clicks on a row the button turns from grey to active.
Then when they click on the button it drills through to page2.

Publish the report to the Power Bi Service.
Create a new dashboard and pin the report to the dashboards.
Test that the dashboard drill through button works ok  😀😀😀

Now go into Power Apps, create a blank canvas, add Power BI control pointing to the Power BI dashboard. Publish the Power App and press play.

The Power App shows page 1 of the integrated Power BI report.

However, when you click on a row the button remains grey and wont drill through. 🙁🙁🙁

Is this normal and is there a solution?

I want to include a Power BI report with a drill through page in a Power App  report.

Thnak you !

[lbendlin · Accepted solution]

Power BI Dashboards are not interactive. When you click a dashboard tile it will take you back to the report visual or page that the tile was generated from.  If you want to emulate drillthrough you need to code that in PowerApps, with PowerApps buttons and different URL pointing to different tiles etc.

[speedramps]

Thank you Ibendlin !