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

Question

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 databaseAfter promoting to Test env via deployment pipeline no errors were displayed. The connections were updated to test&nbsp; 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 StoreKeyWhy is this happening ? How do I fix this ?

anonymous · Accepted Answer

Hi&nbsp;Martin_R&nbsp;
&nbsp;
You can troubleshoot the problem by following these steps:
&nbsp;

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
&nbsp;
Best Regards,Yulia Xu
&nbsp;
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

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

1 Reply

Related content

Relationship

error message

Relationships

Relationship Issue

Anyone else unable to deploy a data warehouse with relationships?