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.
-
DNMAF
on:
Adding a measure or column as a tooltip to an Azur...
-
parry2k
on:
A Typo about Refence Line in the Format (Korean)
- ricardo_ona on: UDFs annotations Issue with Invoke-ProcessASDataba...
- DeeBaxo on: Export to PowerBI directly from Sharepoint List
-
mattlee
on:
Automatically expand table columns to fill availab...
- Ghoom on: Azure Maps Controls -> Selection Greyed out
-
awright19
on:
Open old report, PowerBi hangs
-
mattlee
on:
Error：Visuals display blank when export report to ...
-
mattlee
on:
New Button Slicer: Issue with the Grid type of Arr...
-
mattlee
on:
List Slicer Button Dimensions Ignored in Service