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.
Hello rjhale
It looks like the issue with DAX Info functions failing to execute against published datasets is caused by a bug introduced in the November 2024 update (version 2.138.782.0) of Power BI Desktop. This bug specifically affects the execution of DAX Info functions like CALENDARAUTO when opening certain files.
https://www.reddit.com/r/PowerBI/comments/1gqtl7m/nov_update_20241111_throws_unable_to_execute_dax/
To resolve this issue:
1. Revert to the October 2024 build (2.137.1102.0) of Power BI Desktop, which opens affected files without complications.
2. Wait for the January 2025 update of Power BI Desktop (Version: 2.139.1678.0), which has fixed this issue.
3. If using the latest version, modify your DAX code to avoid using CALENDARAUTO and instead use alternative methods for creating date tables.
hopefully this resolves your query.
Please accept this solution and give kudos, if you find this helpful
I don't think this is the same issue as outlined in that Reddit thread. The issue I described went from successfullly executing on 50+ datasets to failing on those same datasets sometime between last Friday and Monday morning. These would have been datasets published with older version of Power BI desktop and possibly a few since the November release.
Just to be sure though, I did update to the January release, republished one of the datasets, and retried the DAX query: EVALUATE SELECTCOLUMNS(INFO.PARTITIONS(), [QueryDefinition]). It still fails with the same error message.
My suspicion is that something changed with the analysis service engine or maybe a new security policy.