cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Amruthavarshini
Helper III
Helper III

How to create power bi dashboard for custom app?

Hi all, 

 

I have a custom model driven app with custom entities in customer service module in dynamics 365. I want to create a power bi dashboard using the data of the custom entity. How can I achieve this?  I am new to dynamics and i am not aware much about power bi. 

 

Thank you.. 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
ChrisPiasecki
Super User
Super User

Hi @Amruthavarshini,

 

Have a look at the 2 articles below, this should help you add a Power BI dashboard into model driven app using Dataverse data such as your custom entity. 

 

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

https://docs.microsoft.com/en-us/powerapps/maker/data-platform/data-platform-powerbi-connector

 

---
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.

View solution in original post

6 REPLIES 6
ChrisPiasecki
Super User
Super User

Hi @Amruthavarshini,

 

Have a look at the 2 articles below, this should help you add a Power BI dashboard into model driven app using Dataverse data such as your custom entity. 

 

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

https://docs.microsoft.com/en-us/powerapps/maker/data-platform/data-platform-powerbi-connector

 

---
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.

View solution in original post

Amruthavarshini
Helper III
Helper III

Hi @ChrisPiasecki

Thanks for reply..

 

I followed the 1st link.. But i didnt get what i have to select in power bi workspaces while creating a dashboard. In power bi, I installed customer service analytics application and its the only option available while selecting workspace. If i select customer service analytics, the dashboard will contains details on Case entity but I am not  getting how to select the custom entity.

 

Thank you.. 

dpoggemann
Super User
Super User

Hi @Amruthavarshini ,

 

Did you follow @ChrisPiasecki second link where you can download Power BI Desktop and connect to your environment to author the report?  You can connect to the Dataverse with the steps identified and once you do this you can select your tables and build the report.  After building the visuals desired for your report off the custom entities you can publish to the appropriate workspace (even your own for testing / verification).

 

Hopefully this helps.

 

Thanks,

 

Drew

Hope this helps. Please accept if answers your question or Like if helps in any way.
Thanks,
Drew
Amruthavarshini
Helper III
Helper III

Thank you @ChrisPiasecki@dpoggemann.

 

I  created a dashboard using Power BI Desktop. 

 

 

Amruthavarshini
Helper III
Helper III

Hello,

I just wanted to know whether it is possible or not to create a dashboard for custom entity in powerbi online i.e. Using Power BI services without using power bi desktop?

 

Thank you... 

dpoggemann
Super User
Super User

Hi @Amruthavarshini ,


You need to author new reports with the Power BI Desktop.

 

Thanks!


Drew

Hope this helps. Please accept if answers your question or Like if helps in any way.
Thanks,
Drew

Helpful resources

Announcements
User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Power Apps Community Call Jan. 2022 768x460.png

Power Apps Community Call

Please join us on Wednesday, January 19th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Users online (1,527)