Power BI Connecting to BC tables

(6) Share

Report

Posted on by SammyG

450

HI all,

we usually use Jet reporting to connect to Business Central, but we are exploring Power BI due to its dashboarding and ability to link to other systems however why do we need to create links in BC (through web services, API’s etc) and not able to link directly to the tables as we can with Jet?
Thanks

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (2)

Suggested answer

Mohamed Amine Mahmoudi 26,431 Super User 2025 Season 2 on at

Like (2)

Report

Hi @SammyG,

The difference in how Jet Reports and Power BI interact with Business Central largely comes down to the architecture, data access models, and security considerations behind each tool.

Best regards,

Mohamed Amine MAHMOUDI

Was this reply helpful? Yes No
Suggested answer

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

Like (3)

Report

Hello,

The answer would be by architecture and design, this is done to protect data, ensure performance and maintain Microsoft's update model.

I hope I can help.

Regards,

Andres

Was this reply helpful? Yes No
Suggested answer

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

Like (3)

Report

Hope this might be helpful:

Power BI cannot directly link to Business Central tables due to Microsoft's cloud architecture and design. This approach protects data, ensures performance, and facilitates seamless updates by requiring data access through controlled API endpoints rather than direct database connections.

✅ Mark this answer as verified if it helps you.

Was this reply helpful? Yes No
Suggested answer

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

Like (3)

Report

Hello,
Power BI requires data access through web services or APIs due to its cloud-based architecture. This architecture prioritizes security, scalability, and integration across multiple systems. You can publish pages or queries as web services in Business Central and connect Power BI to those endpoints for reporting and dashboards.

Hope this answer will help you!

Regards,
Mansi Soni

Was this reply helpful? Yes No
Verified answer

Gerardo Rentería Ga... 25,234 Most Valuable Professional on at

Like (2)

Report

Hi

If we talk about the cloud, you don't have direct access to the tables.

Losing Direct Access to SQL Server from Business Central SaaS

Best

GR

Was this reply helpful? Yes No
Verified answer

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

Like (1)

Report

Hi, Microsoft designed it this way, there's nothing you can do about it...

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/powerplatform/powerplatform-integration-overview?wt.mc_id=DX-MVP-5004336

Thanks

ZHU

Was this reply helpful? Yes No