Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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 Service after uploadFile in folder, saved and uploadedRefresh history, uploaded 1 minute late and status is completed

Need Help

23 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    8 years ago

    It's tough to tell from the pictures. With so much being redacted, can't tell if there are other selections or cross-filtering going on that would impact the numbers. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hello Anonymous,

       

      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's avatar
        Anonymous
        Not applicable
        8 years ago

        Anonymous,

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

        Regards,
        Lydia

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago

      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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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?

    • Salvador's avatar
      Salvador
      Icon for Responsive Resident rankResponsive Resident
      5 years ago

      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.

  • lbr_finvision's avatar
    lbr_finvision
    Frequent Visitor
    5 years ago

    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.

     

  • eric98's avatar
    eric98
    Icon for Helper II rankHelper II
    5 years ago

    Hello Anonymous 

    I also have the same issue. 

    Did you figure out what was causing the difference? 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.