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