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 thi...
I've had a call with support and they are aware of the issue and have provided an ETA of a fix of 5th June. Until then I've temporarily removed the measures from our reports. See below response from support:
As per verbatim we have understood that your are facing issue while refreshing the visuals in the report and you are facing the error as OLE DB or ODBC error: Internal error: looking up invalid data on a dense spool..
Currently few of our other users are facing the similar issue. An unexpected defect may have surfaced on our end, which caused issue, and our Product Group team confirmed that it is a known issue and they were actively working on this issue.
The team is already looking into the issue on higher priority. We will keep you posted with all the latest updates from them, we regret the inconvenience caused to you by this issue.
Please check the ETA for this issue.
ETA: 05/06/2022