Forum Discussion
Help with stored SQL procedure in Power-query
Problem: An Amount is changing from "+" to "-" during my SQL-procedure.
I'm not sure if the problem is with BI or my SQL-query (probably the latter)
This only happens to this single record. All other records are fine.
NB.
Ordrenummer = Order number
Finanskonto = Financial Account
Beløb = Amount
Dato = Date
It's perfectly fine when looking it up in the database with a simple query.
But when loading it into BI, it changes....
This is the SQL procedure i use
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
2 Replies
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
