Finance | Project Operations, Human Resources, ...

Pull Accounting Source Explorer Data to Power BI

(0) Share

Report

Posted on by Ajay Koppisetty

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

I have the same question (0)

All responses (6)

Answers (0)

André Arnaud de Cal... 301,035 Super User 2025 Season 2 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Ajay Koppisetty 5 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
André Arnaud de Cal... 301,035 Super User 2025 Season 2 on at

Like (0)

Report

Hi Ajay,

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.

Was this reply helpful? Yes No
Ajay Koppisetty 5 on at

Like (0)

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.

Was this reply helpful? Yes No
Suggested answer

Sukrut Parab 71,710 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Ajay Koppisetty 5 on at

Like (0)

Report

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.

Was this reply helpful? Yes No