Dreadful performance against NAV online

[MagnusSthlm]

Hi! 

I'm trying to query the Customer table in NAV by using the odata feed. It only has a little above 6 000 records and it seem to load it in by chunks of 2-3 mb then it stops and wait. I created a blank query and wrote a m script and selected only one column, still same poor performance. It takes about 3 minutes to load 6 000 records, any clues?

/Magnus

[MagnusSthlm]

I select one column but it seems like it load all of the columns in the background which are about 100 for the Customer table. Could be the problem with performance??

[MagnusSthlm · Accepted solution]

I solved it. It is the crazy number of columns that Power BI can't seem to handle. I went into NAV developer environment and created a query based on the Customer table and selected 2 fields. From 15 mb it came down to 224 kb and loaded in 2 seconds.