Forum Discussion

Regular Visitor

3 years ago

Solved

Datasets - Execute Queries with filtering on a string

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] = FIRSTNONBL...

KentKMishra
3 years ago
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\"

Helper I

3 years ago

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