Forum Discussion
Power BI BC Consolidated View Credential Issue
Hello,
Using the standard built-in APIs to connect from Power BI to Business Central, I'm looking to build a cross-environment, cross-company report.
I'd like the option to import each table (across environments and companies) into one table. For example, the "GL entries" table should have "environment" and "company" columns along with all the other "GL entries" columns
How do I go about doing this, please?
Hi, Anonymous
Exporting data via API or OData web services is available in Business Central.
Enabling Power BI integration with Business Central - Business Central | Microsoft Learn
You can use API calls to return the data you need, but you need to know about the APIs related to Business Central
API (v2.0) for Dynamics 365 Business Central - Business Central | Microsoft Learn
You can learn about connecting to Business Central in Power BI from the following article. After that, you can select the columns you want to keep in Power Query in Power BI and delete the other columns you don't need.
Connect to Power BI from Business Central on-premises - Business Central | Microsoft Learn
In addition, you can also consider using dataflows, you can refer to the following articles:
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi, Anonymous
Exporting data via API or OData web services is available in Business Central.
Enabling Power BI integration with Business Central - Business Central | Microsoft Learn
You can use API calls to return the data you need, but you need to know about the APIs related to Business Central
API (v2.0) for Dynamics 365 Business Central - Business Central | Microsoft Learn
You can learn about connecting to Business Central in Power BI from the following article. After that, you can select the columns you want to keep in Power Query in Power BI and delete the other columns you don't need.
Connect to Power BI from Business Central on-premises - Business Central | Microsoft Learn
In addition, you can also consider using dataflows, you can refer to the following articles:
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.