Help with stored SQL procedure in Power-query

[NickolajJessen]

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

[d_gosbell]

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. 

[NickolajJessen · Accepted solution]

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

https://teamsql.io/blog/?p=2140