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!

  • Aidel Ibrahim Profile Picture
    50 on at
    RE: Cannot find Detailed Customer Ledger Entries table to connect to Power BI

    It works. Thanks for your help!

  • Suggested answer
    MahGah Profile Picture
    15,437 on at
    RE: Cannot find Detailed Customer Ledger Entries table to connect to Power BI

    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

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,312 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 233,025 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans