Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
PowerApps is the perfect compliment to Power BI in that it makes it very easy to update or add data to the underlying datasets that Power BI is Visualizing.
This walk through is using the Dashboard in a day sample data that can be found here: https://aka.ms/DIAD To make it easier i am starting with the finished version of the report
In PowerBi.com login and select Get Data > Files and navigate to where you downloaded and extracted the Dashboard in a Day samples. In this example i am using a workspace called “Difinity”; as the intent is to share this PowerApps application, you would not want do this from “My Workspace”
As the PowerApps Power BI control only supports visuals in Dashboards, we need to pin one of the visuals to a dashboard, in this case I am creating a new one called “PATutorial”.
Step 3. Create a Canvas based PowerApp
From the insert ribbon choose controls and scroll to the Power BI Tile
On the Insert ribbon select controls and add a couple (~three) buttons. Change their Text to that of the manufacturers in the Dash board in a day sample i.e. VanArsdel, Natura and Prium.
In the OnSelect of each button set a variable to the manufacture name. In this example we are hard coding the values rather than using the Button1.Text property to make it easier to include the needed single quotes around the manufacturer name.
Select the Power BI control and scroll to the TileURL property then add the section in purple below. If your buttons don’t work there is a good chance you have added an extra space in the URL and the filter is being ignored.
Congrats you have now created a PowerApp that is hosting a Power BI Tile!
Some notes with this example:
If you are looking at the Power BI documentation note there are differences!
https://docs.microsoft.com/en-us/power-bi/service-url-filters
The Tile URL may look something like the following:
and your Button OnSelect would have something like the following:
Set(myvar, "&$filter=Store/Territory eq 'NC'")
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.