Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to 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\"
You are right! That worked. Thanks for the 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\"