Forum Discussion

powerbi-dev's avatar
powerbi-dev
Advocate I
4 years ago
Solved

Looking up invalid data on a dense spool

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. Datasource is a published Po...
Dataflow
Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    Hi powerbi-dev pkeefer Anonymous ,

    This issue has been submitted internally(ICM: 305645248). Please be patient to wait for fixing. If there is any news, I will update it here.

    Best Regards,
    Community Support Team _ kalyj

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
4 years ago

Hi powerbi-dev pkeefer Anonymous ,

This issue has been submitted internally(ICM: 305645248). Please be patient to wait for fixing. If there is any news, I will update it here.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

synru's avatar
synru
Frequent Visitor
10 months ago

I got this "bug" still in 2025. Finally found the root from a syntax involving concatenation of a hardcode string with switch statement will cause the issue. The switch statement consist of possible return with string and number. 

"" + switch(true, a,b)

 In such case type of a and b cannot be determined until run time and therefore I guess it's leading to the bug where it didn't handle correctly for numeric and string type. It doesn't have issue in desktop but in Power BI service. It's triggered when filter applied on certain records that hit the bug. I workaround it by following and no more issue.

switch(true(), ""+a, ""+b)