Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Issues pulling General...
Small and medium business | Business Central, N...
Suggested answer

Issues pulling General Ledger Entries table into PowerBI (BC online)

(0) ShareShare
ReportReport
Posted on by Sjhand 5

Hi there,

I have been having issues pulling the General Ledger Entries table into PowerBI.

If I go into the 'General Ledger Entries' section within Business Central and extract the data through "Edit in Excel", the file that is saved has a live connection into the same table and the data pull is instantaneous. My understanding is that this created an Odata connection through a Dynamics Excel add-in app. It pull all the life-to-date data.

But in Power BI, regardless of whether I am using Odata (Webservices) or API 2.0 to pull the same table, the pull takes forever. It sometimes pulls 100s of megabytes of data , which seems unnecessary. Sometimes at the end of the query I just get a blank screen as if no data has been retrieved. I am adding as many filters (year, account #) as I can to limit the query.

All other tables work just fine.

My issue seems similar to  https://community.dynamics.com/business/f/dynamics-365-business-central-forum/428452/odata-connection---general-ledger-entry, which went unanswered.

How can I resolve this? I just want to be able to get the data to create some custom reports.

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 82,673 Super User 2025 Season 1 on at
    RE: Issues pulling General Ledger Entries table into PowerBI (BC online)

    Hi, I think you could try creating a new API page for General Ledger Entry. It contains only the fields you need. If a standard page is used, it may have some code and fields that are not needed.
    And the performance of the API is much higher than Odata.

    Hope this can give you some hints.

    Thanks.

    ZHU

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,443 on at
    RE: Issues pulling General Ledger Entries table into PowerBI (BC online)

    Hi

    I had the same issue before (in my previous job) we realized that even when Edit in Excel shows G/L it does not pull all the data and it only shows selected data for selected G/L. But in general G/L has lots of data that could cause issue with Excel or ODATA (to try this go to Configuration Package then try to take the G/L Entry table to Excel and open). I believe what we did is we created  data lake that had less limitation than ODATA and we used that.

    If you are on BC SaaS look into the followings to create data lake and try

    github.com/.../bc2adls

    lyftron.com/.../

    appsource.microsoft.com/.../PUBID.efoqus-5058796|AID.replicator|PAPPID.18a4d438-88d1-44ee-a38d-3c0ea0d77338

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 Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

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

#1
YUN ZHU Profile Picture

YUN ZHU 374 Super User 2025 Season 1

#2
Mansi Soni Profile Picture

Mansi Soni 247

#3
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 231 Most Valuable Professional

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans