Reply
Regular Visitor
Posts: 28
Registered: ‎10-02-2018

The relationship doesn't hold any data because it needs to be recalculated

Hi,

I've made some changes in the cube connections both in the test and in production.

The test report does work, but production give me an error:

"The expression referenced a relationship between 'Sales'[EntryDateKey] and 'Calendar Entry Date'[DateKey],
which does not hold any data because it needs to be recalculated."

I have the same reports for both environments. I have no idea, what can be the reasone and how to resolve it?

 

Thanks

Highlighted
Community Support Team
Posts: 3,839
Registered: ‎07-09-2016

Re: The relationship doesn't hold any data because it needs to be recalculated

@Irwest,

 

You might need to check the relationship between the two tables.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.