Power BI Connecting to BC tables

(6) Share

Report

Posted on by SammyG

512

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)

Sort by

Suggested answer

Mohamed Amine Mahmoudi 26,803 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

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 5,192 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

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,177 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

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 9,839 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

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... 27,052 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!

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 101,643 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

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