Blogs

Embedding PowerBI Tile in PowerApps

Inkey, August 8, 2020 5143 Views

In our previous blog we have learnt embedding of PowerApps in Power BI report. Now, in this blog we’ll learn to embed PowerBI tiles in PowerApps.

Let’s look at the steps required to add Power BI tiles in Power Apps.

• In PowerApps click on Insert tab. Click on Charts and then select Power BI tile from the list.

• A Power BI tile will get inserted (refer below image).

• In Data popup, select the Workspace from the dropdown in which the required dashboard is present. Then select desired Dashboard and then select the Tile of the dashboard which we want to display on our PowerApps (refer below imge).

• Adjust the size and position of visual as per your requirement. Similarly, we can add multiple Power BI dashboard’s tiles on a PowerApps.

• Save and Publish the PowerApps.

Some points to be noted

• With the app, you also need to share the dashboard to make the tile visible. Otherwise the user will see an error.

• Don’t put more than three tiles in the app. This can effect the performance of the system.
• You can pass parameters from the app to the tile using its TileURL property to filter results.

To pass parameters you will have to modify the TileURL property which will have below URL.

“https://app.powerbi.com/embed?dashboardId=<DashboardID>&tileId=<TileID>&config=<SomeHash>”

To

“https://app.powerbi.com/embed?dashboardId=<DashboardID>&tileId=<TileID>&config=<SomeHash>&$filter=<TableName>/<ColumnName> eq ‘<Value>’”

As you can see, we’ve added the $filter parameter into the URL to filter the data.

However, there are some limitations for filters.

• Only one filter can be applied at a time
• Only “eq” operator can be used
• Field type has to be string

I hope this will help you!!

---

ATM Inspection PowerApp to ease ATM inspection and report generation process.
https://powerapps.microsoft.com/en-us/partner-showcase/inkey-solutions-atm-inspection/

Insert data into Many-to-Many relationship in Dynamics CRM very easily & quickly, using the Drag and drop listbox.
http://www.inkeysolutions.com/what-we-do/dynamicscrmaddons/drag-and-drop-listbox

Comply your Lead, Contact, and User entities of D365 CRM with GDPR compliance using the GDPR add-on.
https://www.inkeysolutions.com/microsoft-dynamics-365/dynamicscrmaddons/gdpr

Create a personal / system view in Dynamics CRM with all the fields on the form/s which you select for a particular entity using the View Creator.
http://www.inkeysolutions.com/what-we-do/dynamicscrmaddons/view-creator