Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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 thr...
Dataflow
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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.

EHA_SD's avatar
EHA_SD
Advocate IV
1 year ago

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.

  • christian_cw_wo's avatar
    christian_cw_wo
    Frequent Visitor
    1 year ago

    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.