Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hey guys,
Something strange is going on for a while and as I thought this would be fixed with the updates I never care to point it out. But, since this october update didn't make it, here it goes:
I have this cashflow panel that tells me the amount of payables and receivables on a daily basis, but the sum changes wheter I'm using the desktop or the web version of the app.
The tables below show my receivables during a specific amount of time.
This is the info I get when I'm using the desktop version:
And this is the info I get when checking the web version:
Notice the I only covered my personal data, the rest is exactly the same. I know for sure that the web version is showing the right data, but why on heaven do I get doubled values when I use the desktop version? The column "A Receber" shows the amount of money. The report was developed on the desktop version and then uploaded to the web.
Thank you for your attention.
Solved! Go to Solution.
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.
Hi @mr_guedes,
What is your desktop version? Currently, the latest release is 2.51.4885.701 64-bit (October 2017), could you have a try?
Regards,
Yuliana Gu
@v-yulgu-msft wrote:Hi @mr_guedes,
What is your desktop version? Currently, the latest release is 2.51.4885.701 64-bit (October 2017), could you have a try?
Regards,
Yuliana Gu
I'm updated to the last version (2.51.4885.701 64-bit )
Would have to see what the formuals were for the columns you are showing.
@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.
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.
@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)
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.
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.
@smoupre wrote: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.
Here! Link
Thank you for your time
@smoupre wrote: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.
Ok, I'll do that! How can I share the file? Can't find a way to attach it (I'm new to this forum).
Hi @mr_guedes,
You could upload the .pbix file on OneDrive and attach the shared link here.
Regards,
Yuliana Gu
@v-yulgu-msft wrote:Hi @mr_guedes,
You could upload the .pbix file on OneDrive and attach the shared link here.
Regards,
Yuliana Gu
Yuliana, here it is: https://1drv.ms/u/s!Ap4ZqNuvEs43nh8oc2zSurHCn928
Hi @mr_guedes,
I encounter the same problem as yours if I directly publish the .pbix file you provided. By checking the report, I noticed that the start date and end date in slicer are changed after publishing to service. That is why the total value is different in desktop and service.
Desktop
Service
However, if I create below two measures and republish report to service, the date is correct.
Today = TODAY() Today90 = TODAY()+90
Besides, if I don't create above two measures, just delete the calendar table and re-create it using the same formula, then, re-publish report to service, the date slicer displays the same as desktop also.
Best regards,
Yuliana Gu
@v-yulgu-msft wrote:Hi @mr_guedes,
I encounter the same problem as yours if I directly publish the .pbix file you provided. By checking the report, I noticed that the start date and end date in slicer are changed after publishing to service. That is why the total value is different in desktop and service.
Desktop
Service
However, if I create below two measures and republish report to service, the date is correct.
Today = TODAY() Today90 = TODAY()+90Besides, if I don't create above two measures, just delete the calendar table and re-create it using the same formula, then, re-publish report to service, the date slicer displays the same as desktop also.
Best regards,
Yuliana Gu
@v-yulgu-msft, thank you for your attention.
I took a step back and removed from the file every calculated column and also the calendar table. But sadly nothing changes. See how I selected just one row (filtered by the column NFS.Nº) in the query editor, and how it doubles the info in the report view.
I'm attaching this new file here
Hi @mr_guedes,
I don't know why the filtered row will duplicate in report view. This is very odd. Have you tried to re-load your dataset to check if it helps?
Regards,
Yuliana Gu
Any update on this issue?
Experiencing similar problems...
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.
Had the same problem and strangely enough this also was the cause for me.
A query was merged which had nothing to do with the calculation that doubled most lines, but removing it solved the issue for me.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |