Answered

Linking Model-Driven App with Power BI

(0) Share

Report

Posted on by NaCarns

Hi.

I want to link my model-driven application (Dynamics 365) to Power BI. From what I researched, you need a web API URL (from the Developer section) to link them, and you can choose your entities. When I did that, and chose the custom entity/table I created, what I got is a table with what looks like metadata, columns with tables in them, and empty columns. What am I missing? Also, is there a way to link your MDA with Power BI and ONLY have to choose and display the custom entities you created; without the system generated ones?

Thank you.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

ChrisPiasecki 6,422 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!

Hi @NaCarns,

You can embed a Power BI Dashboard or Tile on a Model-Driven Dashboard in direct query mode (real-time data). You need to enable this setting in your environment, then you can download a Power BI file with the Dataverse connection embedded.

Steps on how to do this are documented below.

https://docs.microsoft.com/en-us/powerapps/maker/data-platform/view-entity-data-power-bi

https://docs.microsoft.com/en-us/powerapps/maker/model-driven-apps/create-edit-powerbi-embedded-page

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

Was this reply helpful? Yes No
NaCarns 36 on at

Like (0)

Report
Copy link

Link copied!

So I followed the steps but I couldn't find the Power BI report I've published to my workspace when creating a new Power BI dashboard (through the model-driven app). Can they only work with dashboards? Is there a way to make them work with reports?

EDIT: after several minutes, the Power BI report showed in the system dashboards. Not sure why it took this much time.

A user from another BU tried accessing the report, and it prompted him to sign in but failed to authenticate. Is there an option I need to enable in the security roles for them to be able to view the Power Bi report without any authentication or whatnot? @ChrisPiasecki

Or is it a matter of giving them access to my Power BI workspace?

Was this reply helpful? Yes No
askondo Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@ChrisPiasecki Thanks for always keeping the forum active.

Was this reply helpful? Yes No
ChrisPiasecki 6,422 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @NaCarns,

Users will need to have a Power BI license, and you'll need to share the report/workspace with them. And of course when it comes to the data, the Users will need to have the correct security roles in Dataverse to the Data since direct query is accessing the data directly with the users credentials.

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

Was this reply helpful? Yes No