Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

PowerBI Service showing different values to Desktop

I'm experiencing an odd issue in powerBI Service where published reports are showing different values to PowerBI Desktop.   I have a Project table that has a number of key milestone dates in it (Pr...
Need Help
mahenkj2's avatar
mahenkj2
Icon for Solution Sage rankSolution Sage
3 years ago

Hi Anonymous 

 

As you may also agree, such things usually not possible, if it is happening, most likely it is due to changes in underlying dataset view, either due to some filter working or real change in dataset etc

 

It's kind of troubleshooting and bit difficult to suggest until we see it. So suggest you to dig the difference yourself else post a sample file for us to check. Pls remove any sensitive data.

 

Hope it helps.

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    I'm working with my IT team at the moment as I think I narrowed down the issue. The date fields, when extracted, are timestamped as 12AM even though they are date only in powerBI.

     

    The PowerBI Service Server location is 1.5 hours behind my local time and I believe when i'm publishing to server and it refreshes the server is taking values from the 1st day of the month and grouping them into the month before (happening for all months).

     

    I will provide an update once my IT team comes back to me to confirm if this is the issue.