Forum Discussion
Helper IDifferent values from PBI Desktop to Web Version
Yes,
Just recently I found out that I've merged two queries and as a result the lines were doubled. As this specific query was used over and over again, I took me a lot of time to find out what was going on.
So, check it out if you have merging queries that are doubling any lines. This might be what you are looking for.
Community ChampionWould have to see what the formuals were for the columns you are showing.
Helper I
@smoupre wrote:Would have to see what the formuals were for the columns you are showing.
This column actually has no formula. It is as downloaded from my sql database. In the query editor the values are correct, just like in the web version.
- Greg_Deckler
Sooo...you are saying that when you import the data from your database that the values shown are in your actual data in Desktop. You aren't doing any aggregation of the column in the visual. But, when you publish that to the Service that your values actually change to different values? I'm rather confused.
- mr_guedes
@smoupre wrote:Sooo...you are saying that when you import the data from your database that the values shown are in your actual data in Desktop. You aren't doing any aggregation of the column in the visual. But, when you publish that to the Service that your values actually change to different values? I'm rather confused.
Not actually. What happens is:
- Download data from SQL in Query Editor: data correct
- Create a report in PBI Desktop: numbers change (usually it doubles)
- Upload to the service: data is correct again
As an example, you can check the screen below. It refers to the first line of the report I published before. I highlighted the columns that I used as reference to the report (both on the left side)
Query Editor
The column "A Receber" shows the same value as the view from the web service and it comes from sql just like that. I have formulas in other columns, mostly related with the due date of the receipt. But there aren't two rows with the same value to the column "Nº CR" ( second highlighted).
I'm a bit out of shape with my english, so I'm sorry if I'm giving you a hard time to understand this.
- Greg_Deckler
That is so bizarre. I can't fathom a cause for that off the top of my head and I realize that you can't share your PBIX file because you have sensitive information in it. If there is any possibility that you can remove or obfuscate the sensitive information and share the file that's the only way that I can think of to troubleshoot what is going on.