Looking up invalid data on a dense spool

[powerbi-dev]

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.

[Garamos]

I'm experiencing the same problem, all attempts have failed

[rimgri]

Hi everyone, we are facing same issue.

[Anonymous]

Same problem here! 

When we select a specific time range, some graphics jsut disappear and the error message happens.

We spoke to Microsoft yesterday and we keep waiting for some solution.

This directly impacts our customers, as we use Power BI Embedded.

[Anonymous]

Hi,

We are experiencing the same issues and it's directly impacting our customers as well.

Please inform if there is a solution in place.

Thank you!

[ChingChing]

Hi,

I have the same issue.

I have few visualization get error with below comment. but in my power bi desktop do not show any error.

It only happen when it pusblish to premium workspace.

Activity ID: 4559117c-e10c-439a-a173-1dee25dfae1c
Request ID: 491bfbb6-814c-42cb-a3e8-f1ef00f52dbd
Correlation ID: 041facff-b43d-a02d-2f50-fceba4fea452
Time: Tue May 10 2022 14:36:20 GMT+0800 (Singapore Standard Time)
Service version: 13.0.18173.56
Client version: 2204.4.11089-train
Cluster URI: https://wabi-us-north-central-e-primary-redirect.analysis.windows.net/

Thank you

[Dimmkins]

Hello, 

We're faced the same problem during last two weeks. Strange thing is that PBI Desktop version measure seems good. But after publish it on, visual gets error Dense pool. 

Tried create a new workspace and etc. Nothing.  

Many users have encountered this, judging by the comments.

😯😣

Thank you. 

[PowerBernhard]

I have this issue too. Report worked fine till May 6th. Tried different/ new workspaces, changed the measure slightly etc but with no success. Hope you update us once you have a solution!

[Kaii]

Same here

[RAGIL]

Work around that worked / works for me and @Anonymous  

We have the same issue but with the DAX function AVERAGEX.
In the measure we have several variable declarations for the calculation of Average duration in days.

All these variable declarations have been taken out of the main measure and put in simple (sub)measures.

These (sub)measures are then called / referenced to in the main measure and this change seems to have solved the [our] issue.

So, previously we had 1 measure that did the average calculation.
Now we have more or less 5 (depends on the number of variable declaration in your DAX code) extra measures for the average calculation.

Hope this work around is helpful for others.

Regards,

Renato

[Dimmkins]

@RAGIL Thanks. 

Yes, Agree to You.

I tried make sub_measure as well. But doesn't work in one report layout. 

I also spend last two days to work around with my reports. Changed several measurements to calculated columns, and some of them change in transform mode. 

At least reports had started working. But this situation worries me. :(( How much time to reserve for rebuilding at well worked dashboards?

Great weekends. Thanks to community!