cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

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 endpoints, I get the following error.

 

pbi1_edited.pngpbi3.JPGpbi2_edited.png

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

3 REPLIES 3
Regular Visitor

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

 

thanks,

Community Support
Community Support

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

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.

Helpful resources

Announcements
secondImage

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

secondImage

Power BI Women

Join our monthly meetings and learning sessions.

secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors