Forum Discussion
DAX Info Functions Against Published Datasets
I've had an open support request with MS since this started happening back in January. I recently started up the conversation again, and I just heard from their engineers this morning that they fixed the issue. I checked our Power Automate Flow has been failing on that step since January, and it did successfully run this morning. It seems that the issue should be resolved now.
Thanks Nicke.
What was the workaround suggested by the product team?
Here is the previous answer, not a viable option for us unfortunately.
We got an update from our product team that a recent update to the Execute Queries REST API has caused DAX queries using the INFO family of functions to return HTTP 400 or similar errors. We recognize how disruptive this can be to your workflow and sincerely apologize for inconvenience this may have caused.
The INFO functions depend on DMVs, which the Execute Queries REST API has not supported. However, we acknowledge that customers were able to use these functions prior to the recent update.
It's clear from Datasets - Execute Queries - REST API (Power BI Power BI REST APIs) | Microsoft Learn that "Only DAX queries are supported at this time. MDX and DMV queries are not supported." so this is a restriction that was not previously implemented.
As a workaround, if your model is in premium, you might be able to switch your solutions to XMLA Endpoint-based connections and query semantic models using the AS client libraries (ADOMD.NET).
We appreciate your patience and understanding as we work through this issue. If you need further assistance or have any questions, please do not hesitate to reach out. We are here to help.
That's interesting. So if I'm understanding this correctly, they plan to simply drop support for something they advertised as a new feature in the Power BI service only 6 or 7 months ago? This is incredibly frustrating if that's the case.
Did they provide any guidance on how to query semantic models using the AS client libraries? It would be helpful if there was some way to do this through Power Automate as our previous solution was executing those Info queries from a scheduled Flow.