Huge table

[rmcgrath]

Can anyone give me some advice / tips / code to help pull in the G/L Entries from Business Central?  I have tried every way I can think of and nothing works very well!  I have heard there are coders who can create some "custom code" in order to get it pulled in successfully / optimize it?  This particular table has over 10,000,000 rows!

[Idrissshatila · Accepted solution]

Hello @rmcgrath ,

but power bi can handle 10 million rows and more, so what's the thing with your report.

and do you need this level of details ? maybe you could aggregate the data and remove unnecessary columns.

also, you can connect to the source as direct query, this way you don't need to import all these records.

https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery

[rmcgrath]

Thank you...I'll try the Direct Query!