Power Dynamics
  • Power Dynamics
  • 🍕My name
  • D365 CE
    • Copilot
      • 🥐Add Copilot into Rich Text Control
    • Sales
      • Copilot in D365 Sales
      • Export record to PDF
    • Customer Experience
      • Contact Center (Omnichannel)
        • 🐚Internal Live Chat in MDA
        • 📢Add Chat Widget to Power Pages - Proactive Chat
      • Attachment Control
      • Case Routing: Basic Routing rule set
      • Custom SLA for any Entity
      • Customer Insight
        • Journey - Custom Trigger - Call Power Automate
    • Field Service
  • Power Platform
    • Analytics
    • Dataverse
      • Use case for the feature of Record ownership across Business Unit
      • 💡Workaround: Change the OOB "Exchange Rate" of a record
      • Using a Virtual Entity to store historical log (sample)
      • Disable Empty Address record
      • Using Adaptive card
      • Block Unmanaged Customizations
      • 🪃Recycle Bin on Dataverse (Preview)
    • Model Driven App
      • 💡Run SSRS report on MDA mobile
      • 💡Tip: Create a Security Role with "App Opener" minimum privileges
      • Tag @person to notify in MDA
      • Auto search on the Lookup field
      • Activities with multiple related records
      • Embedded Power BI - Dashboard
      • Embedded Power BI - Form
      • "Custom Help" - Is it help?
      • New modern Command Bar
      • Tip: Hide the button "Add Existing Record" on subgrid
      • Custom Page - Why not?
      • Hiding sensitive column data
    • Canvas App
    • Fabric & Power BI
      • New Text slicer
      • Dataverse link to Microsoft Fabric
      • 💡Leveraging Interactive Warehouse Floor Maps in Power BI
      • Calculation Group for Time Intelligence
    • Power Automate
      • ✅Sequential Approval
      • 📤Create an Appointment by Outlook Graph API
      • Dowload SSRS Report and Send email
      • Power Automate: Add a table in Email
      • 💡Tips: Get "DisplayName" of the Lookup field on Power Automate
      • E-sign: Power Automate & DocuSign
  • D365 Finance & Operation
    • General
      • 🇻🇳D365 FnO - Virtual entities: Use case
    • Finance
      • Consolidating Customer & Vendor Balances
    • Supply Chain
      • Landed Cost Series
        • Landed Cost- Essential Configuration
        • Landed Cost Scenarios 1
Powered by GitBook
On this page
  • Use Case
  • Embedded Power BI report on Form
  • 1.1 Add filtering for the Power BI report
  • 1.2 Using XrmToolbox to embed the Power BI report
  • Checking now...

Was this helpful?

  1. Power Platform
  2. Model Driven App

Embedded Power BI - Form

#ModelDrivenApp, #PowerBI, #MDA, #PowerPlatform

PreviousEmbedded Power BI - DashboardNext"Custom Help" - Is it help?

Last updated 1 year ago

Was this helpful?

Use Case

Hi, How are you?

Thank you for your reading. Yesterday, I got a reporting requirement from the client.

I was thrilled when they wanted to know how we could make the 360 Customer view more insightful. And I told them we could make the Power BI tool with more data visualization, more analytics to create a comprehensive and engaging report that would reveal the customer's 360 view.

So, I designed a sample Power BI report that displays the customer's demographics, loan and contract details, and customer care data. Then, I embedded this Power BI in the main form of the table. The Power BI report will be set as the filter by the current customer. Creating and displaying a visualization in the Main form using OOB components in Dataverse is very challenging. That's why I opted for the Embedded Power BI solution.

Embedded Power BI report on Form

Microsoft reference link:

My steps below and I used the app in XrmToolbox to embed the Power BI report in the Main form.

For instance, I have a report called "FE_Poc" - that displays the customer's demographics, loan and contract details, and customer care data. I will embed this report in the Main form of the Contact table. The report will be filtered by CustomerID (a field on the Contact table).

1.1 Add filtering for the Power BI report

In the report, expand the Filter >> then add the field CustomerID under the section "Filter on all pages" >> then Save and Public report to Power BI Service.

With this filtering, all pages of this report will be filtered by CustomerID.

The next step, I opened my Solution >> opened main form Contact:

  • I added a new tab called Power BI

  • Then, I added a new section FE_Poc in this tab.

I will embed the Power BI report into the section FE_Poc under the Power BI tab.

1.2 Using XrmToolbox to embed the Power BI report

Firstly, I need to find the Group ID and Report ID of the Power BI report "FE_Poc" for the configuration in the XrmToolBox

Configuration on the app Power BI Embedder:

  1. Target section:

    • Entity: choose entity Contact

    • Form: choose the main form needed to embed the Power BI report

    • Tab: choose the tab on the main form

    • Section: chose section on the main form

  2. Power BI Config section:

    • Method: set default value - Manual

    • Group ID: input the Group ID value of the Power BI report (above) My sample: 52b0871f-948e-41d8-97cb-0375566b7dd5

    • Report ID: input the Group ID value of the Power BI report (about) My sample: 6781e570-7f4d-400a-8231-c5ab898621a7

    • Tick the field Filter -> to enable pre-filtering for the Power BI report. The filtering configuration is below:

      • PBI Table: select Power BI Dataset which contains the field "Customer ID" (used for pre-filtering).

      • PBI Column: select a column in the Power BI Dataset used for filtering (in Filter Pane).

      • CDS Field: select a column of the table Contact in Dataverse. This column will be used to filter the Power BI report.

Checking now...

Open a Contact - A Nguyễn Văn (CustomerID = C000001) -> The Customer ID auto filterred.

... and I check for another contact...

Yeah... with XrmToolbox, embedded the Power BI report so easily. Thank XrmToolbox, thanks Ivan Ficko author of Power BI Embedder app.

Now, open the >> then use the app .

Page: input the value [[ReportID]] Sample: My Report ID = 6781e570-7f4d-400a-8231-c5ab898621a7 -> Page: 6781e570-7f4d-400a-8231-c5ab898621a7

URL: input the value ---

Finally, just click Publish Report to finish and wait....

Thank you and hoping well... [NTD]yns.asia

🎉
🎉
XrmToolbox
Power BI Embedder
https://app.powerbi.com/reportEmbed?reportId=
https://app.powerbi.com/reportEmbed?reportId=
https://app.powerbi.com
☺️
Embed a Power BI report in a model-driven app main form
Power BI Embedder
Involved Steps
Add filtering for PwBI report
Tab & Section for embedded Power BI
How to find Group ID and Report ID
Configuration - Power BI Embedder - Publish
Check first contact
Live check
Page cover image