Forum Discussion
PowerBI on Dynamics 365 - GL/Main Tables
Anonymous, if you're a system admin you can do the following:
1. Open the form you want to get in Dynamics 365.2. Right click on the form.
3. Hover over form information
4. Click on Form name: XXXXXX
5. Click Administration
6. Scroll down to find the query statement.
This will give you the query used to generate that form. You can try to copy it to Power BI.
Hi Xiaoxin Sheng,
Thanks for your response.
The problem that I am facing is, I am unable to find the correct table & column names which I have to use to build PowerBI reports for Credit vs Debit and Budget vs Actual expenditure for GL Main accounts.
Any information on this would be of greatl help.
Thanks,
Ajay
Resolver IIAnonymous, if you're a system admin you can do the following:
1. Open the form you want to get in Dynamics 365.
2. Right click on the form.
3. Hover over form information
4. Click on Form name: XXXXXX
5. Click Administration
6. Scroll down to find the query statement.
This will give you the query used to generate that form. You can try to copy it to Power BI.