Forum Discussion
WillDrotar
Advocate I
Advocate IPower BI pulling in incorrect number somehow?
I can't figure this one out... please let me know what you think. We have a report that's connected via Direct Query to our database. For every number it's adding 2 to the correct number. I even...
Hi WillDrotar ,
According to your description, you have not set the conditional format or parameters. Then since you are using a direct query, the problem may be in the query itself. You might want to check to see if there are any functions or operations in the query that might inadvertently add 2 to the number.
Best regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
WillDrotarAdvocate I
Advocate IHi Albert,
it's a simple SELECT, the two fields that are selected are shown above.
It also pulls correctly in SQL Server and the preview in Direct Query, so I don't think it's the query itself.