Forum Discussion

RichardHart's avatar
RichardHart
Regular Visitor
3 years ago
Solved

Power BI Service visuals different than Power BI Desktop after a browser refresh

I have report pages in Power BI Desktop that when published show exactly what is shown in Power BI Service until a browser refresh is performed.

 

This visual has drill throughs from Day to Hour to Date/Time and other fields.

 

Here is the Hour visual in Power BI Desktop when published:

Here is the visual after publishing but before the data refresh is complete.

Once I refresh in the browser, this is the result:

From that point on, nothing I do other than publish again will get it back to the original rendering. I can leave this visual in the browser and publish, hit browser refresh and it is back to being correctly rendered. I can refresh as many times as I like until the data refresh is complete. Once the data refresh is complete, a browser refresh results in the visual being incorrectly being rendered. It looks as if the time has shifted by +15 hours in PBI Service. In PBI Desktop, the deep dips shown in the lines occur at around 02:00 but PBI Service shows them occurring at around 17:00 and the entire graph is shifted by +15 hours.

 

Beyond that, while the hour visual is correctly rendered in PBI Service, drilling down to the Date/Time level shows the deep dips in the lines occurrs at 17:00, not the expected 02:00 which is shown correctly in PBI Desktop. When I drill back up to the Hour visual, it still shows the deep dips at around 02:00. This is until I do a browser refresh. Then everything, including the Hour visual shifts to +15 hours from which I cannot recover without publishing again.

 

PBI Service rendering on drilldown to Date/Time visual:

 

PBI Desktop rendering on drilldown to Date/Time visual:

 

All datetime stamps in the data are UTC. My system and browser are all set to the correct time zone (UTC+1). PBI Desktop shows all dips occurring at 02:00 on all drilldowns.

 

I have tried clearing cache, cookies and downloads in Safari, Edge and Chrome. All result in the +15 hour shift in time.

 

How can I make sure that reports are rendered on PBI Service exactly like they appear in PBI Desktop?

  • I solved my own problem.

    The root of the issue was that we use a self hosted Gateway through which the refresh is scheduled. Thus PBI Service uses the Gateway to refresh the dataset when a report is published. The Gateway server had its region set to Pacific Standard Time while the report was created on a system with the region set to Central European Time. Setting the Gateway server region to Central European Time fixed the issue.

1 Reply

  • RichardHart's avatar
    RichardHart
    Regular Visitor

    I solved my own problem.

    The root of the issue was that we use a self hosted Gateway through which the refresh is scheduled. Thus PBI Service uses the Gateway to refresh the dataset when a report is published. The Gateway server had its region set to Pacific Standard Time while the report was created on a system with the region set to Central European Time. Setting the Gateway server region to Central European Time fixed the issue.