My rolling calendar won't refresh. I have this error with both my main data source and calendar..

[Ellis_Woods]

Hi all,

I have been getting this error with my data sheet and rolling calendar. I am unable to refresh my rolling calendar because of it, meaning my sales data is massively understated.

The errors:

Any ideas on how to fix? I have downloaded the updated version of PowerBI, checked for filters in power query etc.

Really stumped...

- Ellis.

[v-nuoc-msft]

Hi @Ellis_Woods 

Thank you very much Thejeswar for your prompt reply.

Sheet1 Error:

The error message indicates that the column reference to 'DocumentDate' in 'Sheet1' cannot be used with a variation 'Year' because it lacks the necessary data.

The issue with the 'Line Value' column suggests that the measure formula is not aggregating the data correctly. This can happen if the formula is trying to use a column with multiple values without specifying an aggregation function like SUM, MIN, MAX, or COUNT.

Rolling Calendar Error:

The OLE DB or ODBC error suggests a connection issue or a problem with the data source.

Please consider the method provided by Thejeswar to solve the problem.

Regards,

Nono Chen

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

[Thejeswar]

hi @Ellis_Woods ,

From the year what I understand is you are using DocumentDate to get Year information like shown below

[DocumentDate].[Year]

The Error says this variation is not available. This could be because your DocumentDate column has a data type other than Date. Do check that.

The Second part of the error is very straight forward. You need to use Aggregation with a column that you use in a Measure

Regards,