Finance | Project Operations, Human Resources, ...

power BI and Embedded Power BI using Azure data lake

(0) Share

Report

Posted on by SayanikaSM

Hi,

I have few query regarding power BI report in Finance and Ops. Can you please help me to clarify the following queries

For Embedded Power BI, Operation entity store database (AXDW) is used but if we use Azure Data Lake then AXDW won’t be used anymore. I heard that, it is available for public preview PU25 onwards but is it GA?
For Power BI reports that will be used outside D365F&O, earlier BYOD was used and this is available at present as well. BYOD allows us to replicate the entities to Azure SQL. But if we use Azure Data Lake then entity store is only allowed there and entities cannot be published into the lake as of now. Is there any roadmap on this or already available now?
Power BI reports that are embedded into D365F&O, what is the datasource of these reports while opening the same report from powerbi.com? Does it access AXDW DB or Azure SQL DB?

Regards

I have the same question (0)

All responses (13)

Answers (0)

André Arnaud de Cal... 301,020 Super User 2025 Season 2 on at

Like (1)

Report

Hi Sayanika,

The documentation is a bit confusing. According to the April 2019 release notes, the entity store in a data lake is already available: docs.microsoft.com/.../planned-features

There is a difference between embedded Power BI and add reports from Power BI in analytical workspaces. The last mentioned option is in preview: docs.microsoft.com/.../entity-store-data-lake

Was this reply helpful? Yes No
Sukrut Parab 71,710 Moderator on at

Like (1)

Report

Hi Sayanika,

1. Entity store in Data lake is available

2. You can only export entity store to data lake , thats means all your aggregate measures you can push not the regular data entities . You still have to use BYOD for that.

3. Aggregate measurements pushed in your entity store acts a a datasource to Embedded reports , flow of data to powerBI.com its not available yet.

Was this reply helpful? Yes No
SayanikaSM on at

Like (0)

Report

Thanks for the details

Was this reply helpful? Yes No
Suggested answer

Rahul Mohta 21,032 on at

Like (0)

Report

should be able to use with Pu30

see my blog helps

community.dynamics.com/.../adl-for-entity-store-in-customer-owned-adl-with-microsoft-dynamics-365-finance-and-operations-one-version

Was this reply helpful? Yes No
Terry Choo 130 on at

Like (0)

Report

Hi, now that we can integrate ADLS with D365FO entity store and then use Power BI Dataflows to connect to it via CDM, you can create Power BI reports based on it on powerbi.com.

But how will data lake integration affect existing embedded reports in Analytical Workspaces? Do they still point to AXDW database or the integrated data lake?

Will they still work with data lake integration?

Was this reply helpful? Yes No
SayanikaSM on at

Like (1)

Report

They should automatically start pointing to data lake. Though Microsoft will provide a transition window for all existing cstomers. But for new customers they will by default start pointing to lake (if you enable the integration)

Was this reply helpful? Yes No
Terry Choo 130 on at

Like (0)

Report

Thanks Sayanika,

So as of now, if I setup data lake integration, do you think the embedded power bi content would stop working then, until MS sort out the automatic re-pointing?

Was this reply helpful? Yes No
SayanikaSM on at

Like (0)

Report

No it will still work and continue to point to AxDW.

Was this reply helpful? Yes No
Terry Choo 130 on at

Like (0)

Report

However the entity store is now automatically refreshing the data lake rather than AxDW. That means the embedded power bi reports will have data that is not being refreshed?

Was this reply helpful? Yes No
Suggested answer

Rahul Mohta 21,032 on at

Like (1)

Report

any PowerBi report need data source to be predetermined , if new datasource ADL is being used it won't automatically change

expect MS to share new embed templates with ADL or could create your own

Was this reply helpful? Yes No