web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Cannot find Detailed Customer Ledger Entries table to connect to Power BI

(0) ShareShare
ReportReport
Posted on by 50

Hi all,

I am building a dashboard in Power BI and connected to BC. But right now I'm having a hard time to find Detailed Customer Ledger Entries table in Power BI. I able to find Customer LEdger Entries table only. I need the Detailed one because I want to map Document No. and Collection No.

Thank you!

I have the same question (0)
  • Suggested answer
    MahGah Profile Picture
    15,529 on at

    Hi

    I am also learning Power BI as well. I checked and I did not see the Table 379 (Detailed Cust. Ledg. Entry). Then in BC I went to Web Service, created new one, set it to Page and then selected Page 573 (Detailed Cust. Ledg. Entries) and publish it. Then went back to Power BI and saw the page and table. Please note you need to select "Service Name" and does not accept space (you should use _ instead of space)

    pastedimage1618930294062v1.png

    pastedimage1618930303279v2.png

  • Aidel Ibrahim Profile Picture
    50 on at

    It works. Thanks for your help!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,606

#2
YUN ZHU Profile Picture

YUN ZHU 931 Super User 2025 Season 2

#3
Jainam M. Kothari Profile Picture

Jainam M. Kothari 773 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans