Power Platform Community Forum Thread Details

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 :

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

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.

Quick Links