DAX Info Functions Against Published Datasets

[rjhale]

Hello,

As part of a Power Automate Flow that we setup months ago, we were using the new DAX Info functions to pull metadata regarding partitions and expressions.  These queries have been working without issue until this past weekend.  Here is an example of a simple DAX query that would return information about the queries loaded to the data model:

For the last couple of days, these have failed to execute with a generic error stating "Failed to execute the DAX query" and an Analysis Services Error Code of 3239575574.  We have a lot of other Flows that run DAX queries against a dataset in this manner, and those have had no issues.  

Any ideas what may be preventing these queries from executing properly? 

[mariussve1]

Hi,

Im still having the same issue, should this been resolved by now?

[Nicke]

Got an answer today:

I hope you're doing well. I apologize for the delay in getting back to you. I wanted to inform you that I checked internally and received an update that the feature code has been successfully deployed into production, and our team is currently conducting thorough testing. Once the testing is completed, they will proceed to enable the feature switch.

I truly appreciate your patience and understanding on this matter. I will keep you informed and provide an ETA as soon as possible after receiving the update from the team. Thank you very much for your cooperation.

[rjhale]

@Nicke I don't suppose you've received any updates from Microsoft on this issue?  MS closed my incident well over a month ago and committed to having a fix by the start of April.  If you haven't heard anything yet, I can follw up on that thread as a fix is way overdue.  

[Nicke]

Hi, I will send them a mail today.

[mariussve1]

Hi,

Did you get an answer?

[Nicke]

Nope, they usually answers the same day, I've sent a reminder today.

[Nicke]

Hi, got this today,

"We sincerely apologize for the inconvenience caused by this issue. Our product team informed that Feature is already in production but they identified a few gaps that may impact some users, and they have pinpointed the necessary fixes to make the feature compatible. Consequently, our new estimated ETA for the deployment will be mid-June for public fix."

[marcio_fornari]

Any updates?? I tested it today and the problem still persists. The documentation still has this limitation

[mariussve1]

Hi community,

I’ve tested again today, and I’m still experiencing the same issue. It’s not possible to run DAX,INFO() from the executeQueries API.

Same error message today as in the past few weeks:
AnalysisServicesErrorCode: 3239575574
400 Bad Request

Any updates from Microsoft on this? Hopefully it’ll be fixed soon, as we rely heavily on this in our production environment.

[Nicke]

I sent a message to Microsoft today and this is the answer I got. In my opinion, it's BS, proably are they waiting for the FabCon in Las Vegas to end before they dare to push a new version (which was yesterday I think).

Hello Niclas,

Greetings for the day!

I sincerely apologize for the inconvenience you've been experiencing. After consulting with our internal team, I got to know that the deployment failed due to an unexpected outage. We deeply regret any disruption this has caused you.

The good news is that our team is actively working on resolving the issue, and we anticipate that the fix will be implemented by the end of this week. I kindly ask you to check the behavior once the fix is deployed, and let us know if the issue persists.

Thank you for your understanding and patience.

[khoa-tran-hds]

We've been waiting ages for this fix, and still nothing's happened. Come on Microsoft 😾

[DavidKuhry]

Are you aware of any place this issue is documented and tracked? Something we can follow. I've been looking, but no joy. 

Reddit link: An MS employee responded to me here that as of today April 2nd it has NOT yet been resolved. 

Query Info.Measures() Issues. Resolved yet? : r/PowerBI

[marcio_fornari]

Any updates? Come on Microsoft.. 🙏

[marcio_fornari]

Any Updates?

[savignien_heid]

Any updates ?

@Nicke where did you find the info ?

[Nicke]

Had a short meeting today, new ETA 2025-03-31....

[mariussve1]

Hi again @Nicke,

Still get this error message:

{

    "error": {

        "code": "DatasetExecuteQueriesError",

        "pbi.error": {

            "code": "DatasetExecuteQueriesError",

            "parameters": {},

            "details": [

                {

                    "code": "DetailsMessage",

                    "detail": {

                        "type": 1,

                        "value": "Failed to execute the DAX query."

                    }

                },

                {

                    "code": "AnalysisServicesErrorCode",

                    "detail": {

                        "type": 1,

                        "value": "3239575574"

                    }

                }

            ]

        }

    }

}

Do you or anyone else have any updates?

[Nicke]

The issue will be resolved 3/24/2025.

[Noorfar]

Hi,

I checked today but it still not working, did it work for anyone?

[mariussve1]

Hi,

I have also checked today, but still not working. We are using this to autodocument all our models across tentant. Really important to get this up and working again!

Any news from Microsoft?