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

[Anonymous]

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?

[MattAllington · Accepted solution]

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.