Forum Discussion
Report problems in Service for specific users (errors in visuals, incoherent data in charts, ecc)
Hi everyone,
I am having some problems with one of my reports in the service. There are some specific users that have problems like incoherent data (for example, the same measure shown in an histogram gets refreshed while in a card it doesn't) or visual that give them an error
These are two screenshots taken from the same report at about the same time. As you can see the first one (my users) is showing an error, mine isn't. (the problem is not related to the specific selection, so it doesn't matter if the two selections are different. All rows of the table were showing an error to him).
I guess this is a problem related to cache and scheduled refreshes or deploys (I had released a new model few minutes before, it might be that my user didn't refresh his browser), however since I've had a lot of these problems recently I am trying to find precisely what might be the real cause of these kind of problems
Question: is there a setting or anything that will automatically refresh both the cache and the report in the service when there are scheduled updates or deploys? So that if my user keeps his browser open all the time he won't have to close and reopen when a refresh or deploy happens but it will be done automatically
I know I wasn't very clear in my question (I'm a developer who usually works on the model and not administering the service), therefore if there is no specific answer to my problem it would be sufficient enough if you could point me to some resources (blogs, books) where I could find answers to problems similar as mine
Thanks
if you go to this that holds the white papers, you will find a document called https://docs.microsoft.com/en-us/power-bi/guidance/whitepapers
Planning a Power BI Enterprise Deployment
it gives some details on the different refresh aspects, you might want to download the whole doc
Package Refresh (File Level) Description
A package refresh synchronizes a .pbix or .xlsx file in the Power BI service from OneDrive or SharePoint Online. It does not run a data refresh from the underlying source data—it only copies the dataset out of the file and into the Power BI service. It also reflects any changes made to the reports in the .pbix file. How Refresh Is Handled
File-level refreshes are handled automatically by the Power BI service, approximately every 1 hour.
Cached Tile Refresh Description
Dashboard tiles display cached data, to ensure performance is optimal. The cached tile refresh updates the cached data displayed by dashboard tiles. This is useful after a data refresh has occurred to bring the dashboard tiles up to date. How Refresh Is Handled
There are several options for refreshing cached tiles.
Automatically by the Power BI service:
• After data refresh for imported datasets
• Approximately every 1 hour (or as specified in the dataset properties) for DirectQuery and live connections datasets
Manually:
• Refresh option from the menu
Cached Visual Container Refresh Description
The visual container refresh updates the charts, graphs, and tables which have been cached in reports for performance reasons. This is useful after a data refresh has occurred to bring the visuals up to date. How Refresh Is Handled
There are a couple of options for refreshing cached tiles.
Automatically by the Power BI service:
• The visual containers are usually refreshed automatically once a data refresh operation completes
Manually:
• The Refresh menu item at the top of a repo
1 Reply
if you go to this that holds the white papers, you will find a document called https://docs.microsoft.com/en-us/power-bi/guidance/whitepapers
Planning a Power BI Enterprise Deployment
it gives some details on the different refresh aspects, you might want to download the whole doc
Package Refresh (File Level) Description
A package refresh synchronizes a .pbix or .xlsx file in the Power BI service from OneDrive or SharePoint Online. It does not run a data refresh from the underlying source data—it only copies the dataset out of the file and into the Power BI service. It also reflects any changes made to the reports in the .pbix file. How Refresh Is Handled
File-level refreshes are handled automatically by the Power BI service, approximately every 1 hour.
Cached Tile Refresh Description
Dashboard tiles display cached data, to ensure performance is optimal. The cached tile refresh updates the cached data displayed by dashboard tiles. This is useful after a data refresh has occurred to bring the dashboard tiles up to date. How Refresh Is Handled
There are several options for refreshing cached tiles.
Automatically by the Power BI service:
• After data refresh for imported datasets
• Approximately every 1 hour (or as specified in the dataset properties) for DirectQuery and live connections datasets
Manually:
• Refresh option from the menu
Cached Visual Container Refresh Description
The visual container refresh updates the charts, graphs, and tables which have been cached in reports for performance reasons. This is useful after a data refresh has occurred to bring the visuals up to date. How Refresh Is Handled
There are a couple of options for refreshing cached tiles.
Automatically by the Power BI service:
• The visual containers are usually refreshed automatically once a data refresh operation completes
Manually:
• The Refresh menu item at the top of a repo