cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Slowpoke
Resolver II
Resolver II

Running a query against a Power BI dataset

Hi everyone,

I'm trying to run a query against a power bi dataset, but i have issues with it.

The purpose of the query is to get a measure in power bi that tells me which filter are selected in the report.

I'm trying to use this query :

Slowpoke_0-1659535709339.png


This var works without issues in a measure in Power BI: 

Slowpoke_1-1659535771982.png


But, I don't understand why it's not working in power automate, where i get this error:

"  {"error":{"code":"DatasetExecuteQueriesError","pbi.error":{"code":"DatasetExecuteQueriesError","parameters":{},"details":[{"code":"DetailsMessage","detail":{"type":1,"value":"Query (1, 5) The syntax for '_Selects' is incorrect. (var _Selects = IF(\n ISFILTERED(Etat_Consigne_Approb[Perimetres]),\n CONCATENATEX(\n ALLSELECTED(Etat_Consigne_Approb[Perimetres]),\n CONCATENATE(\"'\" & Etat_Consigne_Approb[Perimetres] & \"'\",\n \", \"\n ),\n \"\"\n))\n_Selects)."}},{"code":"AnalysisServicesErrorCode","detail":{"type":1,"value":"3238920194"}}]}}}  "

I can provide any other information on this flow if needed.

And if you have any other idea to bypass this issue, it would also be greatly appreciated.

Thank you by advance.

0 REPLIES 0

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (1,941)