Forum Discussion
Problem when merging SQL queries from two Sage 100c databases in POWER BI.
Hello everyone, I have an SQL query that comes from two databases in Sage 100c, and I want to merge them. However, when I try to add the "AR_Ref" column, I receive an error message, and I'm not sure...
Exactly as it says - you have specified a key column in a dimension table but that column does have duplicates and/or nulls