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


vnb-blog-emergency-response-powerapps

May 18, 2020

Hospital Emergency Response Solution: Unboxing the Microsoft Power Platform Template App

A situation like COVID-19 where the hospitals are challenged to manage supplies and make decisions as they meet an increase in number of patients, Microsoft Power Platform template for Emergency Response Solution became a very efficient help. VNB Power Platform team has been an early adopter of this solution and have implemented it for many

vnb-blog-free-powerapps

May 18, 2020

Get 6 free months of select Microsoft Power Platform solutions to support COVID-19 responses

Microsoft is offering free subscription to its Power Platform for 6 months. Respond quickly to changing organizational needs due to COVID-19 by quickly building business apps using PowerApps, Power Automate and CDS. Available to healthcare, governments, nonprofits, and educators free of charge for six months.* Power Apps Quickly build and share custom, low-code applications. Includes: