web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Using Power BI With Bu...

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

Suggested Answer

Using Power BI With Business Central

(1) Share

Report

Report

Posted on by miker042

25

I am using Power BI and I am connected to our production system. I am having problems finding certain tables. As an example I cannot find "CustLedger_Entry". I also have trouble opening the Sales Invoice Line. An error message opens stating I must supply a Document No. to open this table.

I have written many reports using AL so I know my way around the BC tables.

Regards,

Michael

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Suggested answer

Teagen Boll 3,258 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi Michael,

Are you using web services in Business Central for some of these things? Some web services require you to filter for a specific record. What you can do in Power BI when getting data sources is use the BC connector and look at the Web Services (legacy) drop down to see any web services you created:

If that web service requires a filter for a specific document then you may need to select a different web service that points to a different object.

Best,

Teagen Boll

Work: Catapult ERP

Social: LinkedIn

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 23,020 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Please check this:https://community.dynamics.com/forums/thread/details/?threadid=3100c032-1101-483e-b766-5c59e25ddf2c

https://community.dynamics.com/forums/thread/details/?threadid=7d7b033f-7713-44f2-929d-66231b57f018

https://community.dynamics.com/forums/thread/details/?threadid=d44b1958-eb4c-f011-877a-7c1e52165747

https://community.fabric.microsoft.com/t5/Desktop/Business-Central-and-Power-BI-additional-table-access/td-p/4652423

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

🚀 Season of Sharing Community Challenge Launch!

Ask A Community Pro

Introducing our New Video Series: Community Spotlight

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 1,687 Super User 2026 Season 1

#2

YUN ZHU 1,041 Super User 2026 Season 1

#3

Grigorios Mavrogeorgis 974 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans