OData.Feed should push predicates on navigation properties to URL
Currently when you specify filters (Table.SelectRows) on navigation property the predicate does not get pushed to the URL. PowerBI Desktop downloads all the data locally and then does filtering client-side. This is very inefficient. It would be great if OData.Feed was smart enough to push predica...
OData.Feed should translate Text.StartsWith (M) into startswith (OData)
Right now whenever you use Text.StartsWIth function inside Table.SelectRows PowerBI will fetch all the data and do filtering client-side. It would be much better if it translated Text.StartsWith into native OData funtion startswith. That would push the filtering to the server and it would be much...
Specify default aggregation for a column in Power Query table type metadata
I'm working on the custom extension. In our dataset there are columns for which "average" is the only aggregation that makes sense. However in Power BI Desktop all numeric columns get "sum" as a default aggregation. Can this be overridden from Power Query (e.g. type metadata)? https://stackove...