How to clear Report cache in Power BI Service?

Hi Anonymous ,

Since you asked about the cache in regards to the SERVICE, I am going to assume that you are not using Premium.  Premium has some of its own caching capabilities.  If you are using SSAS with a Live Connection, then the behavior might use a cache of the data.  If you are on live or DirectQuery, then the datasets are refreshed hourly and you can adjust the refresh frequency in the Schedule Cache Refresh option in the Service.  You specifically asked about Gateway though.  If you have the direct connection, you can use the Scheduled cache refresh option and change the refresh frequency.

Here is a good article about the cache:

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data#data-refresh

Also, in reading your question again a few times, I am wondering if your issue is not a cache or a refresh issue.  Your gateway, in the image, appears to be "green" and that all is well.  And, you state that you can publish it in another workspace.  That may indicate that the problem is at report level itself.

If it is the report itself, then go to File-Options and Settings - Options , Under Global, select Data Load and select "clear cache" under "Data Cache Management Options" and select "clear cache" under "Q&A Cache Options" and select "clear cache" under "FOlded Artifacts Cache Options".  

Then ,save and re-publish.

If that does not resolve the issue, then clear the browser's cache.  Also, try in another browser.  (Yes, the browser, not something in the Service or seemingly related to Power BI.)

Let us know if you do all that and how it works out.

I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!