Power BI BC Consolidated View Credential Issue

[zivi]

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? 

[v-jianpeng-msft · Accepted solution]

Hi, @zivi 

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:

Using Power Platform Dataflows to extract and process data from Business Central - Post 1 - Microsof...

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.