Forum Discussion
Help with stored SQL procedure in Power-query
Hello, Thank you for your reply
Your response let me on the right track. Changing the type of JOIN didn't do anything, but removing the entire JOIN resulted in only 2 rows beeing returned by the query.. Meaning it was a 'simple' matter of havning duplicate data produced by the JOIN. Added DISTINCT and now it works like a charm.
Here are two links, if anyone should ever come across this thread with a simular issue:
https://stackoverflow.com/questions/3270335/sql-query-producing-duplicate-rows-and-i-cant-see-why
This does not look like a Power BI issue. The data in Power BI matches the screen shot from your stored procedure. So you need to figure out why the output of you stored proc and your query are different. It could be due to the FULL JOIN. I don't think this looks right. I would guess that maybe this should be an inner or left join, but I don't know anything about your data so I could be mistaken.
Hello, Thank you for your reply
Your response let me on the right track. Changing the type of JOIN didn't do anything, but removing the entire JOIN resulted in only 2 rows beeing returned by the query.. Meaning it was a 'simple' matter of havning duplicate data produced by the JOIN. Added DISTINCT and now it works like a charm.
Here are two links, if anyone should ever come across this thread with a simular issue:
https://stackoverflow.com/questions/3270335/sql-query-producing-duplicate-rows-and-i-cant-see-why