Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
I originally posted the below into an older thread - https://community.powerbi.com/t5/Desktop/Forced-to-use-many-to-many-relationship/m-p/789053#M379986 so apologies if posting this again upsets anyone.
The issue - I cannot create a one-to-many relationship between my Product table (which has a Primary Key field - SKU) and my Sales Transaction Table.
No doubt I'm going something wrong as today is the first day that I'm really working with Power Query.
It's my first day getting really into Power, and I'm ssooo close yet sooo far!
Solved! Go to Solution.
Hello all,
This particular query was difficult to resolve but got there in the end. Duplicates were not easy to find because they had a return carriage in them.
One SKU in a DB of 94,000 records.
Regards,
Hello all,
This particular query was difficult to resolve but got there in the end. Duplicates were not easy to find because they had a return carriage in them.
One SKU in a DB of 94,000 records.
Regards,
Hi
Hi @mattmalone
What is the error message when creating relationships unsuccessfully?
Besides the method you have tried, you could use "Edit queries"->Transform->Format->trim, clean.
You could use "Merge queries" to check if the [StockCode] in Product table match code column in Sales Transaction Table.
https://docs.microsoft.com/en-us/power-bi/desktop-shape-and-combine-data#combine-data
Here is a guide how to create relationship
https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |