Skip to main content

Power BI

New

OData.Feed should translate Text.StartsWith (M) into startswith (OData)

Vote (5) Share
Stanislaw Swierc's profile image

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