Small and medium business | Business Central, N...

Built in Power BI Apps in BC

(6) Share

Report

Posted on by Tris15

400

Hi Experts

We are currently playing around with the Built in BI Reports for Business Central, I have a few questions regarding the setup:

I have linked the Sales App to our Production Environment to Company A

If I now have more companies what are the next steps?

Do I create a workspace per company and install the apps on there? or is it at all possible to have one workspace with the app automatically linking to different companies?

Regards,

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Mohana Yadav 60,993 Super User 2025 Season 2 on at

Like (2)

Report

We have to install the same app with different name and link it to different company.

Was this reply helpful? Yes No
Suggested answer

Andrés Arias 4,188 Super User 2025 Season 2 on at

Like (3)

Report

Hello,

The following information may help you:

https://learn.microsoft.com/es-es/dynamics365/business-central/admin-powerbi

https://learn.microsoft.com/es-es/dynamics365/business-central/admin-powerbi-setup

https://yzhums.com/57847/

I hope I can help.

Regards,

Andres

Was this reply helpful? Yes No
Suggested answer

Mansi Soni 8,907 Super User 2025 Season 2 on at

Like (3)

Report

Hello,

https://learn.microsoft.com/en-us/dynamics365/business-central/across-powerbi-install-business-central-apps

Hope this will help you as well!

Regards,
Mansi Soni

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,157 Most Valuable Professional on at

Like (3)

Report

Hi, good day
I hope this can help you, and give you some hints.

Get the Power BI apps for Multiple Companies in Dynamics 365 Business Central

Best Regards
Gerardo

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 15,631 Super User 2025 Season 2 on at

Like (1)

Report

Hello,

You can either create separate Power BI workspaces for each company and install the Sales App individually, ensuring clear separation and control, or use a single workspace with a centralized setup that connects to multiple companies via dataflows or parameters, allowing consolidated reporting and cross-company analysis—your choice depends on whether you prioritize company-specific access or unified reporting.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,329 Super User 2025 Season 2 on at

Like (0)

Report

As other experts have mentioned, switching to another company can solve this problem.
But if you want to view records from multiple companies at the same time, the standard Power BI app cannot do it, and you need to create a new Power BI report yourself. Then display the report in BC.

For example,

Business Central 2022 wave 2 (BC21): Allow multiple Power BI charts (Multiple “Power BI Embedded Report Part” on the page)

https://yzhums.com/31142/

Creating Power BI Reports for Displaying List Data in Dynamics 365 Business Central (Filter the Power BI report based on the selected record)

https://yzhums.com/32471/

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Sohail Ahmed 11,136 Super User 2025 Season 2 on at

Like (0)

Report

Hi Tris,

If you're working with multiple companies in Business Central, the recommended approach is to:

➡️ Create a separate Power BI workspace for each company

➡️ Install the app separately and configure it to connect to the specific company via the “Switch company” option in the Power BI Business Central connector

Unfortunately, the built-in apps don’t support automatic switching between companies in a single workspace/report — each app instance is tied to one company at a time.

✅ Mark this as the verified answer if it helps.

Was this reply helpful? Yes No