Showing results for 
Search instead for 
Did you mean: 
Advocate I
Advocate I

Refreshing dataset without loading new data



I have a report published on PBI Service. I set the automatic refresh TWICE a week.

o The 1st time: I want it to refresh the dataset without importing new data from the source (to check if the gateway connection is errored or something happened in the source)

o The 2nd time: refresh and import new data


How can I do that in the 1st time of refreshing?

Community Support
Community Support

Hi @tamnm1601 


I assume that in the first time of refreshing you just want to check the connection of the dataset to data sources to ensure refreshing is able to be processed, right? I'm afraid it doesn't support to only check the connection status. When a refresh starts, if it fails to connect to the data sources because of some reasons, it will stop the refreshing progress and return refresh failure message with error messages. No data is imported. If the connection is successful, it will start to import data from data sources. We cannot stop the progress before importing. 


You can set it up to send refresh failure notifications to the dataset owner or other people to receive email notifications when scheduled refresh fails. 


Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

Thank you @v-jingzhang for your explanation.


How about turning off "Keep you data up to date" in Schedule Refresh? Does it mean what I'm looking for?



Turning date off, shall disable the scheduled refresh functionality. Then the report shall be just static.


Super User
Super User

Hi @tamnm1601 ,


In the Power BI Service you can only schedule an refresh that will push all the new data from the sources if there is any.


Probably you can only do that with a script or an Power Automate like the example belllow:


055 - On Premises Data Gateway Monitoring Status - Part 1 (Power Automate Desktop) - YouTube


I hope i helped you!

Sérgio Silva

If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

Check out my blog for tips and tricks about Power BI:

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors