Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

Tables required for Power BI reporting in D365 Finance

Posted on by 277
Dears,
I'm looking for the Tables required for Power BI reporting, to build 
Income Statement
Sales Dashboard
Project Management Dashboard
  • Suggested answer
    salman ahmad Profile Picture
    salman ahmad 97 on at
    Tables required for Power BI reporting in D365 Finance
    Hi Muhammad, The best way is to find the it from aggregate measures available in the system by default.
    Please note tha If you will use the AXDB these reports will not be deployed into F&O but you can use using the online services.
    For sale go to inquires and reports in sales & marketing and last report is for sales dashboard same for the project.
    for income statement use the Ledger transactions entity.
     
    Please mark answer verified. :)
  • Suggested answer
    Waed Ayyad Profile Picture
    Waed Ayyad 6,332 Super User 2024 Season 2 on at
    Tables required for Power BI reporting in D365 Finance
     
    You should check the available data entities as power BI use data entities as a DataSource.
     
     
    Thanks,
    Waed Ayyad
    Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future
     

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans