Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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?
Solved! Go to 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.
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.
User | Count |
---|---|
84 | |
79 | |
71 | |
47 | |
42 |
User | Count |
---|---|
109 | |
54 | |
50 | |
40 | |
40 |