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

[JR19]

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 · Accepted solution]

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]

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!

[DataVitalizer]

Happy it’s working smoothly again.

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

🟩 Follow me on LinkedIn