Getting ready for the Data Insights Summit and want to walk people through embedding a PowerApp into a Power BI Dashboard.
While there seems to be a lot of steps…many of them are in the application creation and none of them are difficult.
Step 1. Create a new application in PowerApps.
While the experience would be fewer steps if you used the PowerApps web client (https://powerapps.microsoft.com/en-us/) the experience is so much better in PowerApps Studio found in the store and the one i recommend using.
Step 2. Add the Data Source Connection.
In this example i am using the App in a Day dataset found here
Step 3. Add the tables from the Data Source Connection
Step 4. Add the Vertical Gallery for the Application
Step 5. Add the Horizontal l Gallery for the Application
Step 6. Set up the data source and format the Vertical gallery
Step 7. Set up the data source and format the horizontal gallery
Step 7. Set up a filter to show only the computers from the Oems in the Vertical Gallery.
( you should really rename your controls including Galleries to something that you can recognize!)
Step 8. Get the URL for the PowerApp.
Note to do this you must use the PowerApps Web client
Step 9. Get the URL for the PowerApp.
Note to do this you must use the PowerApps Web client by navigating to the “Apps” menu on the left hand rail.
Step 10. Retrieve the formatted URL by running the URI retrieved above in any browser.
Step 11. Create a new dashboard to host our PowerApp!
Step 12 In the Power BI Dashboard add a new tile of type “Web Content”
Step 13 Insert Embed Code.
Using the URL from step 10 insert into the following iframe markup.
< iframe width=”98%” height=”98%” src=”YourURL&hideNavBar=true“/>
Note this should render even before you hit inter.