Forum Discussion
Disabling Dublicate notification
Hello all, I have prepared the powerbi file where I get data from SharePoint and SQL server. Tables have been merged based on 3 different columns. I use this powerbi file on different projects. (...
Deduplicate the SQL source in Power Query before you merge the sources. Better yet, don't merge them in Power Query. Let the data model do the work for you.
Thanks for the Advice!
Even when I merge data in powerquery I see that in data model relationship is different(done on its own).
For now, I have filtered SQL table, so do not get duplicates so far. For future cases, look forward to find more optimal solution to deal with them.