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.
