Forum Discussion
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
- RichardHartRegular 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.