Relationships between tables from different databases not working

Hi Anonymous,

When you create a relationship, it will prompt both columns don't have distinct values. 

You can create a table visual to show count of the activitydate column from Query1, count value 2 means there are duplicate values. Regarding the Calendar$ table, you can see there are more than one blank rows, also are duplicate rows. So it's expected that we can't create a relationship. You can see attached pbix file. 

In your scenario, you can go to query editor, use Remove Blank Rows to remove blank rows in Calendar$ table. After apply change, you should be able to create the relationship between activitydate and Date. 

Best Regards,
Qiuyun Yu