topic Datasets - Execute Queries with filtering on a string in Developer

Datasets - Execute Queries with filtering on a string

Tobias2019 — Mon, 24 Jul 2023 08:32:45 GMT

Dear all,

how do I filter a DAX statement with Power BI REST API (Execute Queries), when the filter is a string value?

Something like this works

FILTER ('table', 'table'[column] = FIRSTNONBLANK('table'[column], 'table'[column]))

Something like this does not (and this is what I want to make work).

I guess, it is only about formating, since the " related to the filter value are understood as end of the JSON value from the PowerBI REST API

FILTER ('table', 'table'[columnArea] = "value")

Thanks for any support!

Re: Datasets - Execute Queries with filtering on a string

KentKMishra — Mon, 24 Jul 2023 20:17:41 GMT

We had to use a delimator to escape the quotes. Ours is slightly different because we used to ExecuteQuery function in the request and did not have to use the single quotes for the table/columns, but for the = "value" portion ours looked something like:

= \"value\"

Re: Datasets - Execute Queries with filtering on a string

Tobias2019 — Tue, 25 Jul 2023 11:29:26 GMT

You are right! That worked. Thanks for the solution!