Unable to Execute DAX - The current operation was cancelled because another operation failed

[S_Kjeldsen]

We are suddenly getting this error on a specific PC when opening our dataset, please can someone tell us how to fix it

[v-echaithra · Accepted solution]

Hi @S_Kjeldsen ,

Start by verifying that Power BI Desktop is updated to the latest version and matches the version used on machines where the dataset works correctly.
Then, clear the cache by going to File > Options and Settings > Options > Data Load > Clear Cache. If the problem continues, try resetting the user profile by deleting the cache folder at:
%LOCALAPPDATA%\Microsoft\Power BI Desktop Store App\Cache.
Also, review your DAX calculations for any potential issues that could be causing the failure.
On Surface devices, installing the wrong architecture can cause silent failures.
Try opening a blank report, connecting to the same dataset, and running a simple DAX query. If that fails, the issue is user's local machine only and not dataset-related.
Right-click Power BI Desktop and choose Run as administrator to test.
Also clear any Analysis Services temp workspace.

Thanks and Regards,
Chaithra.

[v-echaithra]

Hi @S_Kjeldsen ,

We wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,
Chaithra.

[v-echaithra]

Hi @S_Kjeldsen ,

May I ask if you have gotten this issue resolved?

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Regards,
Chaithra.

[v-echaithra]

Hi @S_Kjeldsen ,

We wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,
Chaithra.

[v-echaithra · Accepted solution]

Hi @S_Kjeldsen ,

Start by verifying that Power BI Desktop is updated to the latest version and matches the version used on machines where the dataset works correctly.
Then, clear the cache by going to File > Options and Settings > Options > Data Load > Clear Cache. If the problem continues, try resetting the user profile by deleting the cache folder at:
%LOCALAPPDATA%\Microsoft\Power BI Desktop Store App\Cache.
Also, review your DAX calculations for any potential issues that could be causing the failure.
On Surface devices, installing the wrong architecture can cause silent failures.
Try opening a blank report, connecting to the same dataset, and running a simple DAX query. If that fails, the issue is user's local machine only and not dataset-related.
Right-click Power BI Desktop and choose Run as administrator to test.
Also clear any Analysis Services temp workspace.

Thanks and Regards,
Chaithra.

[S_Kjeldsen · Accepted solution]

Hi, This did not solve the issue i'm afraid but we found the exlanation now on another post:

https://community.fabric.microsoft.com/t5/Issues/Power-BI-Desktop-issues-starting-March-2025-release...

[S_Kjeldsen]

Thanks Chaithra! We will try all of these things you mention 🙂

[Deku]

Would need to see the measure 

[S_Kjeldsen]

Hi Deku, there is no function referenced in the error, and the file works fine for all other users. 

[Deku]

Do you have RLS?

[S_Kjeldsen]

Hi Deko, no RLS and the user is a BI administrator, but the error does not come when she uses another machine. She is using a quite new Surface machine and the error just suddenly came.