Power query natively selects all data from the odata feed, and allow you to filter or select columns after having retrieved the data. This takes for ages to pull data to power BI. I suggest a feature change to allow the field and filter selection to be applied in the odata feed using the "somethingSet?$select=Field1,Field2..... It dramatically reduces the load time, and its less hard on the infrastructure at Microsoft :-)
5 Comments
- The power query pulled a bit over 4 Gb on a table with 220K records of data through the Odata feed, and after applying the select criteria the query is only pulling 350 Mb datam and the query is at least 4 times faster.
- Hi miquel i agree that it is possible to build a custom rule string with filters and field selection. However the approach isn't really user friendly and the ordinary user will not be able to do this. I suggest to use The Navigator to selection fields and filter date, but build The Full URL, and thereby filter data on server site instead Of Client site
- It should indeed be more user friendly to enter oData parameters
- Our users specify the transformation in the preview of Microsoft Power BI Desktop. In that case it works fine, even with millions of financial transactions.
- Status added:Completed
