After deploying from Dev to Test Error message on relationship which does not hold any data

[Martin_R]

Hi,

I recently added a new SQL server table Inventory via import mode to my Power BI report , which links to Store on StoreKey. I also added a new visual showing Inventory for Store Name. All tables come from the same SQL database

After promoting to Test env via deployment pipeline no errors were displayed. The connections were updated to test  but when i open the viusal I get this error message.
The expression referenced a relationship between 'Inventory'[StoreKey] and 'Store'[StoreKey], which does not hold any data because it needs to be recalculated.

I can see the data in inventory table contains values for StoreKey and Store also contains all values for columns including StoreKey

Why is this happening ? How do I fix this ?

[Anonymous · Accepted solution]

Hi @Martin_R 

You can troubleshoot the problem by following these steps:

• Check the validity of the relationship between the two tables in the test environment
• Whether there are calculated columns or measure that depend on the relationship between the two tables

The following documents may help you:

Solved: The relationship doesn't hold any data because it ... - Microsoft Fabric Community

Model relationships in Power BI Desktop - Power BI | Microsoft Learn

Best Regards,
Yulia Xu

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