Datasets - Execute Queries with filtering on a string

[Tobias2019]

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!

[Tobias2019]

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

[KentKMishra · Accepted solution]

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\"