Stanislaw Swierc on 25 Oct 2016 07:02:37
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 more efficient.
Example of query that filters data client-side
let
Source = OData.Feed("https://account.analytics.visualstudio.com/_odata"),
Areas = Source{[Name="Areas",Signature="table"]}[Data],
Filtered = Table.SelectRows(Areas, each Text.StartsWith([AreaPath], "Agile\Shared"))
in
Filtered