Announcements
No record found.
I'm looking for options pull the dataset to Power BI. I explored the GeneralLedgerAccountEntries entity but I'm missing ProjectId and ActivityNumber in it.
Can someone please guide me in achieving the same dataset as shown in the AccountSourceExplorer?
Thanks in advance
Hi Ajay,
The accounting source explorer is compiled by x++ logic which fills a temporary table. You can export the details from all relevant tables to e.g. Data Lake and use Synapse or other tools to create the view you need or prepare the data in a particular way and then export it to be directly consumed by Power BI.
Thank you @André for responding. When you say all relevant tables, is there any way I can get the details of all entities that AccountSourceExplorer is using? Because I'm able find all the details except the ProjectID and ActivityNumber for individual transactions only.
If you can guide me in that specific direction or direct me to identify all the entities involved in it, that would be really helpful at this point.
I don't know which exact tables are used in the background by head. It is possible to reverse engineer the data provider classes to check how the information is being compiled together for the report.
Okay @André. Since I'm new to this Dynamic 365 ecosystem, is there any blog or a tutorial that will help me doing the reverse engineering the data provider?
Also to do that don't we need to have the account source explorer schema exposed in the data provider? Because I don't see that in the data provider. I only see plain data entities in the data provider.
Hi Ajay ,
You should be able to look at class AccountingSourceExplorerProcessor and identify tables used for populating this form.
For your project specific question, all projects are stored in Projtable and posted transaction's against those projects in ProjTransPosting table which might be joined to subledger using SubledgerVoucher field from GeneralJournalEntry table.
Thank you Sukrut Parab for responding!
Where can I find class (AccountingSourceExplorerProcessor) through reverse engineering on visualstudio or anywhere else?
And unfortunately I didn't the tables (Projtable, ProjTransPosting and the Subledger) you have mentioned. Attached screenshots for the same. But we do have the GeneralJournalEntry table.
Please let me know if I'm missing anything.
Thanks in advance.
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.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 590 Super User 2026 Season 1
Giorgio Bonacorsi 349
Diego Mancassola 263
