Forum Discussion

thilokg's avatar
thilokg
Frequent Visitor
8 years ago

Power BI Desktop Odata data limit

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 endpo...
v-yuta-msft's avatar
v-yuta-msft
Community Support
8 years ago

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-Feed/td-p/122508.

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's avatar
    thilokg
    Frequent Visitor
    8 years ago

    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.