Forum Discussion
Power BI Service not refreshing data - Unexpected error occurred 'xlscaop_unary.cpp'
Hello community!
I've been struggling for a week now to find the root cause of this issue.
Basically from one day to the other our service is not working for this specific report and keep throwing the following error:
"Processing error: An unexpected error occurred (file 'xlscaop_unary.cpp', line 1078, function 'XLScalarCast::MakeScaLogOp'). The current operation was cancelled because another operation in the transaction failed."
We've raised a ticket to Ms but nothing so far.
I am breaking down the report and seems like the model is corrupted or the relationship is not working properly.
We have three different data sources - Pbi data flow, direct sql connection and sharepoint.
Have anyone seen this error message before? I tried google it but nothing related to pbi.
Thanks in advance!
For future reference to the others, I found the issue.
After an extensive investigation I found that one customized column with tons of calculations and measures was triggering this bug.
That column was being used as legend at the Map visualization and I think that's how the bug started.
Removing it solved my issue, however, I need now to figure out how to add that missing information again.
8 Replies
For me, the issue was that I had tried a few of the new table functions:
INFO.VIEW.COLUMNS()
INFO.VIEW.TABLES()
INFO.VIEW.MEASURES()
INFO.VIEW.RELATIONSHIPS()
Once I had deleted those tables from my model the refresh resumed working again.I can confirm! But it only depends on INFO.VIEW.COLUMNS(). If I just remove that table and keep the other INFO.VIEW tables the refresh is working fine agina.
Hi Anonymous
have you made sure you are using the latest version of Power BI Desktop?
Also does this only happen on this PBIX file or all other files?
If this file what happens if you had to rebuild the file?
Hi !
Yes, I have the latest version of PBI installed and I made sure I have the latest version of Gateway too.
I tested some other reports and they work fine, the problem is just with one report.
Actually rebuilding this report is not on my plans right now because it is really complex... but during my tests I removed a few queries and left some others but I got inconclusive answers.
If I remove query A, then it works fine but if I recreate it, at some point the refresh stops working for no reason...I didn't figure out what is breaking the query. That's why I feel that the model got corrupted.
Hi Anonymous
It could well be that query, but it does not make sense it would be causing the issue
If it still happens I would log a support ticket?
For future reference to the others, I found the issue.
After an extensive investigation I found that one customized column with tons of calculations and measures was triggering this bug.
That column was being used as legend at the Map visualization and I think that's how the bug started.
Removing it solved my issue, however, I need now to figure out how to add that missing information again.
