News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Tables required for Po...

Finance | Project Operations, Human Resources, ...

Suggested answer

Tables required for Power BI reporting in D365 Finance

(1) Share

Report

Report

Posted on by mahmoud_algindy

277

Dears,
I'm looking for the Tables required for Power BI reporting, to build
Income Statement
Sales Dashboard

Project Management Dashboard

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

salman ahmad 97 on at

Like (0)

Report

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 6,332 Super User 2024 Season 2 on at

Like (0)

Report

Tables required for Power BI reporting in D365 Finance

Hi mahmoud_algindy,

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

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,214 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans