Blog

Embed PowerBI in PowerApps-Part 2

dynamics 365 customer engagement

Embed PowerBI with PowerApps in a model driven app

This solution is a little tricky compared to the canvas solution, but I am sure glad it is available now.

1)      Before we start embedding Power BI with PowerApps reports in model driven applications, we must first make sure to enable Power BI Visualizations in the organization

Step by step instructions to enable provided here

power bi with powerapps

2)      Next, we need to export the solution where we intend to embed PowerBI

Step by step instructions to export provided here

3)      Once you have exported the solution, open the customizations.xml file that is available in the zipped solution, either in an XML editor or a text editor

power bi with powerapps

4)      Find the block of the form XML you are looking to embed, and add the below section (credit: Microsoft)

<section id="{d411658c-7450-e1e3-bc80-07021a04bcc2}" locklevel="0" showlabel="true" IsUserDefined="0" name="tab_4_section_1" labelwidth="115" columns="1" layout="varwidth" showbar="false">
	<labels>
		<label languagecode="1033" description="My unfiltered Power BI embedding demo"/>
	</labels>
	<rows>
		<row>
			<cell id="{7d18b61c-c588-136c-aee7-03e5e74a09a1}" showlabel="true" rowspan="20" colspan="1" auto="false">
				<labels>
					<label languagecode="1033" description="My Report"/>
				</labels>
				<control id="unfilteredreport" classid="{8C54228C-1B25-4909-A12A-F2B968BB0D62}">
					<parameters>
						<PowerBIGroupId>00000000-0000-0000-0000-000000000000</PowerBIGroupId>
						<PowerBIReportId>544c4162-6773-4944-900c-abfd075f6081</PowerBIReportId>
						<TileUrl>https://xyz.powerbi.com/reportEmbed?reportId=544c4162-6773-4944-900c-abfd075f6081</TileUrl>
					</parameters>
				</control>
			</cell>
		</row>
		<row/>
	</rows>
</section>

5)      In the above section, feel free to change the labels as you feel appropriate.

6)      You should also change PowerBIGroupID, PowerBIReportID and TitleURL values to the PowerBI report you want to embed.

7)      You can get the details from clicking on File/Embed menu item in PowerBI.com and copying the link from PowerBI.com

power bi with powerapps

8)      Make sure to copy the exact ID’s needed from the link, it contains GroupID and ReportID along with a few additional pieces of information. The titleurl element should only contain the reportID part as shown in the sample code snippet in step 4

9)      Now save the customizations.xml file and it is ready to be imported back into PowerApps

10)      Step by Step instructions on update and import of a solutions detailed here

11)      Now you can browse to your app and see that the report is embedded in whichever section you inserted the piece of code, in my sample I inserted into the main section of the Information Form, see below.

power bi with powerapps

12)      Once the report shows up, you can edit the model driven app, edit the form in the model driven form editor and change the PowerBI properties as per your need. As you can see, once PowerBI is embedded manually, it is easier to pull it up and change it as needed through the form editor

13)      You can take this further by adding contextual filters to the current model driven form.

14)      Since this is a feature still being matured, there a few known issues and limitations, details here.

15)      Along with the listed in the link above, if you run into issues also check the below

a.       Make sure the model driven app solution and the enabling of PowerBI visualizations in the organization are on the same environment in the same tenant, it is key

b.       Make sure you have access to the environment

c.       If you are new to XML editing, make sure to verify if the customizations.xml is well formatted by opening in a browser, if it opens as below you are in good shape, if not, do not import the solution to PowerApps until it is fixed

Related Posts


dynamics 365 customer engagement

September 24, 2019

Embed PowerApps in PowerBI-Part 3

In this series, so far, we have embedded a Power BI report/tile in canvas app and then in model driven apps. Now we will do the reverse, where we will embed PowerApps in Power BI. When there is more focus on action based on analytics, it makes more sense to embed a business app in

dynamics 365 customer engagement

September 11, 2019

Embed PowerBI in PowerApps – Part 1

Embed Power BI in Canvas app This Power BI integration PowerApps feature has been there for a while, but it gets a bit tricky with parameter settings and performance. Let us go through step by step on how to go about creating a simple app. 1)      Create a canvas app using the canvas app from blank