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, ... / Datalake table model?
Finance | Project Operations, Human Resources, ...
Unanswered

Datalake table model?

(0) ShareShare
ReportReport
Posted on by SaxMan 15

Has anyone modeled these tables? 

Or maybe a Sql library of scripts to join them?   

Just trying to know what tables to export and then how to join them in say PowerBI or via sql queries. 

All I find are piecemeal queries people have done in old on-prem AX databases.  Datalake documentation just tells you how to set it up and working, not how to actually use it....which is kind of important right?  Now I have all these files/tables in datalake.  Now what?  We had powerbi trainer try to use them and they were just guessing (wrongly) how to join them.  It was little awkward to watch.   

I have the same question (0)
  • Charlotte X Profile Picture
    Charlotte X on at

    Hi SaxMan,

    Please wait for someone more experienced in this area to answer this question.

  • Martin Dráb Profile Picture
    Martin Dráb 237,807 Most Valuable Professional on at

    It's not clear to me what your main problem is.

    1) If users don't know what data they need from F&O, it's not really specific to Azure Data Lake, is it?

    2) If you know how to achieve your goal with F&O entities but not with raw tables, use CDMUtil to generate views corresponding to data entities.

    3) Azure Data Lake and Synapse are generic tools and their documentation can tell you how you can connect, transform data and so on, but it can't tell you how you want to use your data.

  • SaxMan Profile Picture
    SaxMan 15 on at

    It's the same problem anyone would face when trying to consume an application data for BI org-wide integration purposes or simply trying to utilize datalake tables by PowerBI.  

    First let me state I've solved this issue by finding this series of blogs www.instructorbrandon.com/.../    This is amazing documentation and training by this person.

    To answer your questions:

    1) Business people know their data not the backend tables, my business customers aren't IT experts.  That's my job.  They were handed bunch of datalake files/tables and powerbi and trying to make sense of it...which of course isn't realistic.  

    2) that's an option I'm considering if nothing else just so we can use SSMS to query the data but it's not setup yet plus again that's still physical and if they don't know backend design it won't help them understand how to get data out

    3) not looking for how to use it specifically to us - this isn't unique to us.  Anytime you are looking to utilize an application's data externally  you have to know how to get data out of 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

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 664 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

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

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 303 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans