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,
Who can please explain to me why Left Join is the simplest, where SQL executed in a second Power BI refused to execute ??
Hi @Galat198 ,
Was it working in the query preview but not when it was being applied?
Please check whether the associated columns between the two tables are all set to allow nulls. If column contains blank values or duplicate values and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table.
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Galat198 , Have you used any SQL in Advance editor of connection, if yes, please share that
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |