Different results vs desktop when report is uploaded and refreshed through gateway

[kostask]

Hi guys.

I came up with something pretty weird and really frustrating.

I created a typical sales report using a couple of tables from my server and a calendar table. Everything works fine when in PBI Desktop.

As long I publish the report at Service and configure the refresh setup, when it is refreshed the results are not the same as the desktop.

Specifically, the sales amount when I use my date filters and also the last sales date, that I use to show the last day transactions occurred.

Tried a couple of things, like changing the regional settings and enabling/disabling auto date/time at the current file.

Does anyone face the same issues or have any idea what is going on? Below you can see two screenshots of the very same file with the same filters at Desktop and Service

Thank you

Kostas

[dcrosseto]

Hi,

Did you try to check if this problems occur specifically when related to your Calendar table? Example, did you compare the amount of rows Desktop vs. Service? Can you reach the same number using just the tables from the server without the calendar?

My point is, try to confirm that this difference comes specifically when you include your Calendar table. If you manage to reach same numbers then I would try something like Locale.

Hope it was helpful.

Regards,

Douglas.

[kostask]

Hi @dcrosseto 

I did some checks.

1. I uploaded the report as it is and compared the total lines of the main table vs the total lines at the desktop. Initially the results are the same, but when i applied date filters through the calendar table the results don' t match (less lines at Service than desktop with the same filter applied)

2. I deleted the calendar table and uploaded the report. The lines uploaded are also the same as at desktop. I applied date filters, using the date column that exists in the main table and did again the comparison. The results are not the same again ( less lines at service). It seems that the calendar table is not the problem.

It seems that someting is wrong with the dates generally. Pretty weird and frustrating!

Thank you

Kostas

[dcrosseto · Accepted solution]

That's quite weird indeed... Looks like something related to locale on your machine vs. service

The existing date column, when you upload your data, come as string or date format? You could also try to "force" locale before uploading, using this https://prnt.sc/wpTwBC_w9o8e

For testing purpose, I would also replicates the date column as text, without converting to date, publish and compares text vs. date columns.

There is also something called "culture", check this blog post

Regards,

Douglas.

[kostask]

Ηι @dcrosseto 

You are right. I did not check the date column format (it looks so stupid after so many checks). It was string and in desktop, it works properly. After publishing at service all the mess started.

Thank you for your time

Kostas