Solved: Internal error: looking up invalid data on a dense...

JR19 · ‎11-12-2025

Does anyone have a clue what this error message relates to? Only seems to appear on the service, not in desktop.

Internal error: looking up invalid data on a dense spool.

DataVitalizer · ‎11-12-2025

Hi @JR19

This error shows up only in the Power BI Service when certain measures (like SUMX with CALCULATE) run, even though they work fine in Desktop, I think the fix is to simplify or rebuild the measure, republish the dataset, or try a new workspace and if it still fails, it’s a backend issue.

Did it work? 👍 A kudos would be appreciated
🟨 Mark it as a solution to help spread knowledge 💡

🟩 Follow me on LinkedIn

View solution in original post

DataVitalizer · ‎11-12-2025

Hi @JR19

This error shows up only in the Power BI Service when certain measures (like SUMX with CALCULATE) run, even though they work fine in Desktop, I think the fix is to simplify or rebuild the measure, republish the dataset, or try a new workspace and if it still fails, it’s a backend issue.

Did it work? 👍 A kudos would be appreciated
🟨 Mark it as a solution to help spread knowledge 💡

🟩 Follow me on LinkedIn

JR19 · ‎11-12-2025

Thanks @DataVitalizer I rebuilt a couple of the measures being used in the visual and this seems to have fixed the issue. Thanks for your quick response!