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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Different data between Power BI Desktop and Power BI Service after the upload

Hello,

 

I´ve got a problem with my uploaded data. When I actualize the data in Power BI Desktop and look later on the data in Power BI Service, I have a different number of the available hours for e.g. one person.

 

So I actualized my data manually on 7:26am (A scheduled refresh before is active as well by the way) in Desktop. I saved my file and uploaded the data to Service and everything went fine (Status is completed and the end time was 7:27am). Then I opened Power BI Service later on (11:52am) and what I saw is, that the available hours were different to them which I uploaded a few hours ago. Between these times there weren´t any other scheduled refreshes.

 

The available hours were calculated, so they are not from a server directly, but I think that should not be a criterion in this case.

 

Do you know what can I do?

 

 

Available hours in Power BI DesktopAvailable hours in Power BI DesktopAvailable hours in Power BI Service after uploadAvailable hours in Power BI Service after uploadFile in folder, saved and uploadedFile in folder, saved and uploadedRefresh history, uploaded 1 minute late and status is completedRefresh history, uploaded 1 minute late and status is completed

23 REPLIES 23
slavkoanakievsk
New Member

Hello,

I have the same issue. Any updates?

Anonymous
Not applicable

I had exactly the same problem. Since I did not find an approved solution, here how I was able to fix the issue.

 

The change is due to the regional settings which are different for your Power BI Desktop and Power BI Service respectively. Not all regional settings are available in PBI Service. Therefore - lets say you have a regional setting on Switzerland in PBI Desktop -  same query manipulations could potentially result in different results in PBI service due to different regional data formatting. For more information check: https://docs.microsoft.com/en-us/power-bi/fundamentals/supported-languages-countries-regions .

 

A way to resolve this issue is to change your regional settings in PBI Desktop to regional settings which are supported in PBI service. As done in undermentioned illustration.

 

KD_PP_0-1638180151417.png

 

eric98
Helper II
Helper II

Hello @Anonymous 

I also have the same issue. 

Did you figure out what was causing the difference? 

lbr_finvision
Frequent Visitor

was this issue ever solved? i have identical issues. No changes of filters between desktop & services and still i am missing part of my results after refresh.

 

Anonymous
Not applicable

I am having the exact same problem as @nwrong , @ttvd  and possibly @Anonymous . A short summary:

- When refreshing data in PBI Desktop I get expected results

- When I publish the report to PBI Service with no refresh, the results are also as expected

- When refreshing the data in PBI service (manually/scheduled), a large portion of the data from the DWH table is missing

 

Some details about my data: I have two data sources in my report that are merged in PowerQuery, a DWH table and a csv file stored on a shared disk location. The DWH table is updated every night and the csv file is static.

 

The issue is not that the data source is updated as I do these checks during daytime, and there is no issue related to time zones. The worrying fact is that no error message arises, so the issue could potentially go under someone's radar.

 

At the moment I have disabled scheduled refresh, do manual refresh PBI Desktop daily and republish to PBI Service every morning. Has anyone opened a ticket to Microsoft regarding this behavior?

Hello @Anonymous,

 

One quick question, the data refresh on the pbi service is using the same credentials you use to refresh the data in pbi desktop?

 

I once had this issue, and the cause was that the credentials used in pbi service didnt have access to the same information my credentials had.

 

Regards,

Salva.

Anonymous
Not applicable

I am also experiencing this issue where once a refresh has taken place on Power BI service, the values of a calculated column change to the values on Power BI Desktop even though the data set has not changed. Has anyone managed to find any causes of this issue?

Anonymous
Not applicable

Hi there,

i have the same problem.

After digging a little deeper into the subject matter, it seems to me to be an issue with time zones. My desktop has the timezone UTC+2, the dataset for example 07.07.2020 22:00. On the desktop the date is correctly interpreted as 08.08.2020. On the server as 07.07.2020, because the server runs on UTC.

Now I have to think about how to handle daylight saving time also, because I can't just add +2 hours.

 

Maybe I helped you, to have a clue, what might be going on. Sincerely

v-yuezhe-msft
Employee
Employee

@Anonymous,

Have you checked that if you apply other filters such as visual level filter, report level filter or page filter on the report in Power BI Service? And what is the result for the avaliable hours if you click refresh in Power BI Desktop?

Regards,

Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Hello @v-yuezhe-msft,

 

thanks for your answer, but the filter in Power BI Service are the same. So I clicked on refresh in Power BI Desktop and uploaded it to Service. The data is equal after that, compared to the data from Desktop. Then I figured out, that the data differ when there comes the scheduled refresh after the manual refresh from Power BI Desktop. 

 

That is really strange, because the available hours are calculated and the data gateway to the SQL server is online anyway...

 

Greetings

Chris

@Anonymous,

After you upload the PBIX file the first time, do you click "Refresh Now" in Power BI Service?

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Hello @v-yuezhe-msft,

 

I don´t know if I did that a few months ago. But when I click on "Refresh now" in Power BI Service after the manual refresh and upload from Power BI Desktop, I get the different values...

@Anonymous,

You don't refresh the data in Power BI Service and Power BI Desktop, there is a possibility that you get different values as you may have different data in the data source at different time.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

@v-yuezhe-msft

 

ok so you think that the different data comes from the different time I actualize in PowerBI Service and PowerBI Desktop, right?

 

The data I get from the server will get updated only one time a day in the night. So when I actualize the data  with the scheduled refresh in the early afternoon and a manual refresh in Desktop a few minutes later, I should get the same data I think.

 

As I mentioned that the available hours were calculated by measures and excel sheets, so they don´t come from the SQL server. That´s what I´m worried about why this is different. 

 

What I found out is that there are only a few technicians in a few months were the data is different between PowerBI Service and Desktop. 

 

Furthermore I found out that the scheduled refresh works fine, so the status is completed. Whe I want to update the data in Service with Refresh now, the refresh failed.

 

Refresh historyRefresh history

I am experiencing the exact same problem.

 

After I publish my pbix to PBI Service, the data matches what is in PBI Desktop. Shortly after, a scheduled refresh runs and the data displayed in Service is different.

 

The source data is not changing between the time I publish the pbix and the time when the schedule refresh runs.

 

 

Anonymous
Not applicable

Hi @nwrong,

 

and what are you doing to get the correct data now? Do you make a manual refresh in Dektop once a day?

 

I don´t know what to do and the refresh every day is really annoying. Is the false data you get from a created measure or the data from an Excel file / SQL server?

i'm unable to get the pbi service to display the correct data. 

 

I guess i could disable the scheduled refresh and manual refresh and republish from PBI desktop each day....

Anonymous
Not applicable

Maybe one solution is to write a ticket to Microsoft to solve this problem...I don´t know what to do and don´t want to refresh it every day by my own.

@Anonymous I'm experiencing the exact the same problem. Did you figure out what was causing the difference? 

 

Thanks,

Tim

Anonymous
Not applicable

Hi @TT,

 

no I don´t know why we have that problem when we have the sheduled refresh...

It works when you do it manually, but not with the scheduled refresh?

 

Br,

Christopher

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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