The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hello,
I am trying to merge two tables to get 3 columns from the other table and it is creating 4 additional duplicate rows (in the actual report, which has led to more than 2 million rows). I have created a sample here and it even did the same thing to that. I was wondering if somebody could help me out here. I am doing a left outer join and have made sure that the tables do not have duplicates beforehand.
I am attaching screenshots of my sample file here,
Attendance Table:Classes Table:
Merge Tables
Hi @syasmin25 ,
Are you merging them with unique id's per row ?
If not they are gonna replicate the rows from the outer table.
In the original file, I have created a ID.Bellperiod index column in both the tables and I am trying to merge based on that.
Can you share a sample of it on a PBIX ?
So we can take a look.
I do not have the option to do that here.
You can use GoogleDrive/OneDrive/DropBox.
I figured it out. It was an issue within the database.
Hi, can you tell me what happened exactly with your database? looks like I have similar issue with you.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
37 | |
23 | |
23 | |
18 | |
16 |