Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowGet inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.
I have a problem with a published dataset, with the error message "Looking up invalid data on a dense spool". It happens with a single measure and only in PBI Service.
The dataset was fine and this suddenly started to happen. When I'm using PBI Desktop, there are no errors, but I soon as I publish the data and connect my report via Live Connection, any visual with the measure returns the error. The measure is quite simple, just a SUMX with a simple CALCULATE filter, and it's used in many other measures of the report which do not return any error message.
I have already tried:
- Recreating the measure;
- Republishing the dataset;
- Deleting and republishing the dataset;
- Creating a new file with PBIT template and connecting/
None worked.
If anyone has had this problem in the past, I'd appreciate some advice, thank you.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.