Forum Discussion
Power BI REST API executeQuery failing when passing INFO DAX function
When executing Power BI REST API executeQuery with INFO function in the DAX query is failing with the below error message. This used to work fine previously.
{
"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"
}
}
]
}
}
}
Any lead on this?
16 Replies
I have the same problem, I can see there is a same question here: https://community.fabric.microsoft.com/t5/Service/DAX-Info-Functions-Against-Published-Datasets/m-p/4375239
Do you have any success to find out what's going on?
Well, it's no me that will fix the problem, it's Microsoft... I have no clue how it's going, I've only been told they are going to fix it today and if not I'll have a meeting with them on Wednesday , sorry.
Sorry for the previous misdirected reply; I've corrected the @ tag.
We've been waiting ages for this! Having to manually download PBIX files and then execute the INFO DAX function locally—because executeQuery and INFO DAX have issues—is a real pain. Any news from Microsoft on Today would be great!
I sent a message to Microsoft today and this is the answer I got.
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.
Hi avg12345 ,
Based on your description, it appears that the REST API
Datasets - Execute Queriesis no longer functioning as expected, despite previously working correctly. However, I tested it yesterday and it was operational. I recommend raising a support ticket to obtain professional assistance from the relevant team to resolve this issue.How to create a support ticket in Power BI - Microsoft Fabric Community
Best Regards
Is there an expected date for the services to be back?
Hi marcio_fornari ,
The related team is working on temporary solution for selected tenants/capacities, I will update you once the relevant testing and validation is done.
Best Regards
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.
Do we have any updates on this? Could you please update it here when it's working?
I have updated latest info in this thread
