Forum Discussion
Internal error: looking up invalid data on a dense spool.
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 💡
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 💡
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!
Happy it’s working smoothly again.
Did it work? 👍 A kudos would be appreciated
🟨 Mark it as a solution to help spread knowledge 💡