How to clear Report cache in Power BI Service?

[Anonymous]

Hi,

I have a problem when I want to deploy an update report. So this report has already been used for a year and we doing an update, adding new data sets in the report. We test it in another workspace it works and we can set the scheduled refresh for it.

But the problem when we want to replace the report in the other workspace (which a lot of users using this report) we can't set a gateway, we can choose the data but can't apply the gateway, like the screenshot below.

But if I deploy as a new report in the same workspace, I can select the gateway and can do the refresh.

Seems there's a cache in that report so we can't assign the gateway.

Any help will be appreciated.

Thank you!

[Anonymous · Accepted solution]

Hi all, Just want to let you know that we fixed it.

What we do

1. We delete cache in Power BI Desktop

2. Adding new data source in Power BI Desktop

3. Deploy it to Power BI Service as this will clear cache of data source in Power BI Services.

4. And we can assign the gateway to the report.

[Anonymous]

Hi @Anonymous ，

It's glad to hear that your problem has been resolved. And thanks for sharing your solution with us, it will also help others who face the similar issue with you in the community. Thank you.

Best Regards

Rena

[Anonymous]

Hi @Anonymous，

Whether your problem still persist? As checked the following thread, others face the similar problem with you and it seems working now. Could you please help validate it in your side? Thank you.

PBI Desktop publish not working / PBI Service .pbix upload removes backgrounds

Best Regards
Rena
Community Support Team _ Rena Ruan
If this post helps, then please consider Accept it as the solution to help the other members find it more.

[collinq]

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!

[Anonymous]

Yes @collinq , if I re-deploy in the same workspace it works, but if I replace the old report the problem is occur.

And I'm using import mode not Live connection/Direct Query.

And we are trying to open the report in other laptop also, it still encounter the same we can't apply the gateway even though the gateway color is green as shown.

Really appreciate the answer.

Thanks