Power BI Desktop Odata data limit

[thilokg]

I am trying to get data to PowerBI Desktop via an OData endpoint. We have eight OData endpoints with authentication and this works fine.

But when the returned data volume is high from OData endpoints, I get the following error.

Notice the size of data retrieved from OData endpoints. For TransactionFacts, it's around 150MB and for AccountFacts it's around 177MB. 

After some time, I get the error in Image 3.

I tried all the endpoints with Fiddler and all works fine (With Fildder, retrieved data size from AccountFacts was 185MB). These works with PowerBI too, if the data volume was a little less than this.

So my question is, is there a limitation of data volume which can be retrieved to PowerBI Desktop via OData endpoints? If so, what is the limit and what can I do to fix this problem.

Thank you.

Thilok

[jasonrutherford]

Hi, did this ever get resolved? I'm running into the same issue.

thanks,

[v-yuta-msft]

Hi thilokg,

How long is your string length? Server side may set limitation of your string length. Please refer to the similar case: https://community.powerbi.com/t5/Desktop/increase-number-of-columns-that-can-be-imported-using-OData....

In addtion, you can refer to this blog for other limitations of Odata.Feed in power bi: https://whitepages.unlimitedviz.com/2014/12/limitations-for-power-query-odata-feeds-in-power-bi/.

Regards,

Jimmy Tao

[thilokg]

I checked the string length and it seems its not the problem. As I said, it was little bit less data volume (lets say 170MB), then it works with the same set of columns.