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.