Forum Discussion
Tobias2019
3 years agoRegular Visitor
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...
- 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\"
Tobias2019
3 years agoRegular Visitor
You are right! That worked. Thanks for the solution!