Unable to See New Business Central Table in Power BI

(3) Share

Report

Posted on by CU15030958-0

I recently created a new table in Business Central and would like to integrate its data into my Power BI report. However, I'm unable to see the new table when trying to connect Business Central to Power BI.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (7)

Answers (1)

Suggested answer

Ashwin Nimbulkar 164 on at

Like (1)

Report

You need to create an API page for your table and publish it in Business Central as a web service.

Hope this helps: Developing a custom API - Business Central | Microsoft Learn

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

Like (2)

Report

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

Enabling Power BI integration with Business Central - Business Central | Microsoft Learn

Create Stunning Power BI Reports Using the Standard BC API’s – think about IT

Best Regards
Gerardo

Was this reply helpful? Yes No
Verified answer

Steven Renders 5,672 Moderator on at

Like (1)

Report

Tables are not exposed outside BC.

You need to create API Query objects to expose data to Power BI:

https://plataan.tv/en/plataan/training-course/business-central/core-power-bi-specialist-with-business-central

https://plataan.tv/en/plataan/training-course/business-central/advanced-power-bi-specialist-in-business-central

https://learn.microsoft.com/en-us/training/paths/use-power-bi/

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,643 Super User 2025 Season 2 on at

Like (2)

Report

Hope this helps as wellhttps://www.youtube.com/watch?v=WyVfR3yIvsM

Was this reply helpful? Yes No
Suggested answer

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

Like (2)

Report

May this can help :https://community.fabric.microsoft.com/t5/Desktop/Business-Central-Dynamics-365-Power-BI-tables-not-getting/td-p/2397188

https://community.fabric.microsoft.com/t5/Service/D365-Business-Central-Power-BI-Tile-cannot-connect/m-p/4371562

Was this reply helpful? Yes No
Vahid Ghafarpour 12,183 Super User 2025 Season 2 on at

Like (1)

Report

If any of the responses helped resolve your issue, please take a moment to mark the best answer. This helps others in the community quickly find solutions to similar problems.

To do this, simply click the "Does this answer your question?" button on the most helpful response and like the helpful posts. If your issue is still unresolved, feel free to provide more details so the community can assist further!

Thanks for being an active part of the Dynamics 365 Community!

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 31,485 Super User 2025 Season 2 on at

Like (2)

Report

Steven is correct, tables are not exposed outside of BC so you will need to expose it using an API page, query, or even web service (not recommended)

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No