Forum Discussion
Power BI Service not refreshing data - Unexpected error occurred 'xlscaop_unary.cpp'
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.
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?
Thanks GilbertQ,
We already raised a ticket to Microsoft but for now they are asking only basic stuff... credentials, publish again... etc.But I still have this issue.
Hi Anonymous
I know it takes some time, but often you have to go through the intial steps.
Maybe the Feb release of PBI desktop will be a quicker resolution.