Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / General ledger to Proj...
Finance forum
Unanswered

General ledger to Projects sub-ledger- Power BI report building, what relationship to use?

Posted on by 2
Hi there, folks,
 
Within PowerBI, we have a data hub drawn from D365 F&O. We are looking to build reports based on the project's sub-ledger but related to the general ledger, such as a more detailed or versatile WIP report. What should or could we use as the relational connection between the two ledgers to draw from them both when creating reports?
 
Our PowerBI developers are struggling to find a link or relationship they could use to connect the two perspectives/tables/sets, yet D365 can do it. So, what do you think we are not understanding?
 
Is voucher transaction the only connection?
 
Here's hoping someone can help or point me in the right/better direction.
 
Thank you.
 
Gabriel
 
 

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,353 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,251 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans