Unable to load small OData field in Power BI

[Anonymous]

I have published a Dynamics NAV 2016 table as an Odata link.

When I try to access it from the browser (selecting around 5 columns, data for 2 years i.e. around 800,000 records), the file size is coming to around 2MB.

But when I attempt to load it to Power BI, it's taking forever (not able to successfully load), and it's showing that data size is over 50mb (and still loading...)

What could be the reason for this? 

[v-janeyg-msft]

Hi, @Anonymous 

It’s my pleasure to answer for you.

According to your description,I think you should check whether the Odata link you connect is all data or part of the data you want to load first,then check the real size of the source file.

Can you provide more connection information shown above?

If it doesn’t solve your problem, please feel free to ask me.

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.