Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Anonymous
Not applicable

Avoid pulling large OData feed in PBI desktop, and pull only in Cloud

I want to build a PBI report that uses data from an OData feed.

The problem is that the OData feed can return lots of GB of data, which takes a lot of time and memory on my desktop. I want to do the following but not sure how this could be done:

1. When using PBI desktop, I want to pull the data with parameter $top=1000, and this way avoid pulling all the data.

2. After I build my report, I want to publish it so it will run daily in the cloud, but instead of pulling only first 1000 records, I want that in the cloud it will pull all the records.

The problem is that if I use $top locally, and then publish, I don't see an option to remove this $top in the cloud.  Can what I wanted be done in any way?

1 ACCEPTED SOLUTION
MattAllington
Community Champion
Community Champion

It is possible to change a parameter after publishing your report to the service. I guess you could use that to do what you want. If you have premium, I think you can set the parameter once as part of the deployment settings. 



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
I will not give you bad advice, even if you unknowingly ask for it.

View solution in original post

1 REPLY 1
MattAllington
Community Champion
Community Champion

It is possible to change a parameter after publishing your report to the service. I guess you could use that to do what you want. If you have premium, I think you can set the parameter once as part of the deployment settings. 



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
I will not give you bad advice, even if you unknowingly ask for it.

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.