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...
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.
