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.

  • pmay's avatar
    pmay
    Resolver I
    10 months ago

    It's been 3 years and you've not posted an update about the fix.  We're getting this bug - should I assume you're still working on it?

    • user_name_101's avatar
      user_name_101
      New Member
      10 months ago

      Hi - I also just got this bug this morning. Everything was working fine yesterday. Did you figure out a way to solve this?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    HI Kalyj, do you have any news on this topic? we have an aoutage in prod, impacting our user community.

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

      Hi Anonymous ,

      Sorry for the inconvenience, the engineers are rushing to fix this known bug, the fix will come soon, thank you for your patience. If there is any news, I will update it here.

      Best Regards,
      Community Support Team _ kalyj

  • bogoLAC's avatar
    bogoLAC
    Frequent Visitor
    4 years ago

    let us know when the problem is going to be resolved, i still see the problem

  • bogoLAC's avatar
    bogoLAC
    Frequent Visitor
    4 years ago

    any update on the resolution?

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

      Hi bogoLAC ,

      Sorry the issue is still not be fixed, Please be patient to wait for fixing. If there is any news, I will update it here.

      Best Regards,
      Community Support Team _ kalyj

      • cdenniston's avatar
        cdenniston
        Regular Visitor
        4 years ago

        Any update on this issue, I have noticed that when our report is republished to a My workspace we are not receiving the Looking up invalid data on a dense spool. Any thought that it has to do with the premium service? Is that why it is working in both the PowerBi desktop and a users My workspace? 

  • 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)