Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
kostask
Helper II
Helper II

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

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

4444.PNG

Thank you

Kostas

1 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.

View solution in original post

4 REPLIES 4
dcrosseto
Resolver II
Resolver II

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.

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

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.

Ηι @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

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.