Schedule Refresh Breaks the Report

[WishAskedSooner]

We have our data in Azure SQL Server. We have configured a Gateway. I have published a Report and Semantic Model to the PowerBI Service. Everything is fine and working.

Now, we want to enable Scheduled Refreshes. The refresh works, at least, it says completed with no errors. However, when we click on the Report, there are slicers that are now blank (not all of them) and various visuals are blank as well.

Our IT group has spent several hours testing various settings e.g. query caching. However, we can't figure why the refresh is breaking the report.

Any help would be greatly appreciated.

[WishAskedSooner]

I apologize for not responding. Our IT group has not had any time to test @Greg_Deckler suggestions. However, I have bookmarked his reply and will test once we revisit this problem.

[v-sgandrathi]

Hi @WishAskedSooner,

Thanks @Greg_Deckler for taking the time to respond to this concern.

I wanted to check if you had the opportunity to review the information provided by the community member. Please feel free to contact us if you have any further questions. If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you for using Microsoft Community Forum.

[v-sgandrathi]

Hi @WishAskedSooner,

As we did not get a response, may I know if the above reply could clarify your issue, or could you please help confirm if we may help you with anything else?

And if the provided information meets your requirements, you can Accept the solution and also give Kudos on that reply. It helps other users who are searching for this same information and find the information.

Your understanding and patience will be appreciated.

Thank You.

[v-sgandrathi]

HI @WishAskedSooner,

As we have not received a response from you yet, I would like to confirm whether you have successfully resolved the issue or if you require further assistance.

If the issue has been resolved, please mark the helpful reply as a "solution" to indicate that the question has been answered and to assist others in the community.

Thank you for your cooperation. Have a great day.

[Greg_Deckler · Accepted solution]

@WishAskedSooner So, I would save your original report (back it up) and then after the refresh download the PBIX from the Service and compare it to the original. It's really difficult to know what might be going on without more information. Are there query parameters that are being used and changed between environments. Is the Azure SQL Server the original source of the data?