web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Embedding Power BI in ...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Embedding Power BI in D365, What Should the Data Source Type be for The Power BI Report?

(0) ShareShare
ReportReport
Posted on by Momochi 1,036

Greetings dears,

I want to create a Power BI report that will be embedded in D365.

I need the report to be embedded in a Deployable package, so once the Ax model is deployed, the Power BI report should be available in D365.

But I'm confused on how to build the Power BI report data sources..

I usually develop Power BI reports using OData and I set the refresh schedule on PowerBI.com .

But if I want the report to be embedded in D365, what should the data sources type be? How it will get refreshed?

My question is regarding how to get the data from D365 into Power BI if I want to embed the report and it will get refreshed?

Any advice is appreciated !

Thanks in advance !

I have the same question (0)
  • Suggested answer
    saurabh bharti Profile Picture
    saurabh bharti 15,039 Moderator on at

    hi,

    I think you would need DW cube to be developed and publish as entity store Sys admin > setup > entity store

  • Momochi Profile Picture
    Momochi 1,036 on at

    Hi Sauabh,

    Thanks for the reply.

    Oh, but I'm sorry I have no background on cubes...can you provide me with some links?

  • Suggested answer
    Komi Siabi Profile Picture
    Komi Siabi 13,107 Most Valuable Professional on at

    Hello Momochi,

    Please, find the Microsoft documentation.

    learn.microsoft.com/.../add-analytics-tab-workspaces

  • Momochi Profile Picture
    Momochi 1,036 on at

    Hi Komi,

    Thanks for your reply and the link.

    The link mentions that I have to create a power bi report that is sourced from Entity store.

    I'm confused how to connect to Entity store from power bi? is it ok through Odata or it should be through SQL server?

  • Momochi Profile Picture
    Momochi 1,036 on at

    Hi  Komi,

    In the link you posted it says that one of the pre-requisites is:

    "An analytical report (.pbix file) that was created by using Microsoft Power BI Desktop, and that has a data model that is sourced from the Entity store database."

    So the source is data store...

    I'm actually not familiar with data store and after reading a little bit, it turns out that it's the AxDW in SQL Server... which is updated using batch jobs in D365.

    So in AxDW, there are only cubes I see?

    Then as per saurabh bharti  said that I need to develop a DW Cube?

    I'm not seeing any useful tables in  AxDW.

    When I develop Power BI using OData Feed, there are lots of useful out of the box data entities which makes creating reports easier and faster.

    But here it seems I have to create a cube for anything I need to display in the report?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 544 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 450 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 250 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans