Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / D365 F&O to Azure ...
Finance | Project Operations, Human Resources, ...
Answered

D365 F&O to Azure Data Lake to Power BI

(0) ShareShare
ReportReport
Posted on by VickyD

We recently configured the D365 F&O to Azure Data Lake Sync and are able to sync and see the relevant files in the Azure Data Lake (Storage). 

Most videos or articles like this one seem to drive towards using Azure Synapse and then Power BI. Is there any particular reason we can't just use Power BI to pull directly from the Data Lake? 

I am aware of the following advantages in Azure Synapse

1. Ability to use T-SQL to explore data, create views etc

2. Ability to potentially build and manage a SQL Datawarehouse

3. Integrate with other applications that can use SQL Datawarehouse

and perhaps other benefits. 

However, if our requirements are fairly simple is there any reason why we can't just import straight from Azure Data Lake into Power BI?

  • VickyD Profile Picture
    VickyD on at
    RE: D365 F&O to Azure Data Lake to Power BI

    Thanks for the details.

    I see that Power BI does have the CDM Folder view option that seems to be interpreting the csv and json files correctly. With this now an option would you still say Azure Synapse is a must? 

    pastedimage1676823796300v1.png

    I personally do like the idea of having the Azure Synapse layer primarily as it provides a SQL end point but want to be clear whether it's an absolute necessity or more of a recommended/good to have option. 

  • Verified answer
    Ian Waring Profile Picture
    Ian Waring 436 on at
    RE: D365 F&O to Azure Data Lake to Power BI

    Largely because the default is to create JSON attributes with CSV files in the lake. Power BI can’t make much sense of it in that form.

    We have Synapse running and CDMutil firing up whenever there’s a change to the table list added by a suitably privileged user on D365FO.

    An absolute, totally reliable delight to use, not least as the raw data tables expose useful fields that the standard entities omit (like the link field between sales invoice lines and the sales order line that gives rise to it).

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans