i have few excel sheets from which i want to make dashboard but i am facing Synthetic key error, can anyone help me to solve these 3 synthetic key?
attached is my Script:
Solved! Go to Solution.
three synthetic keys is not a big issue, More synthetic keys will not effect your data. even if we take link tables that also same, So you no need to bother about the synthetic keys in your data model.
You can continue with reports without any fear.