Refreshing dataset without loading new data

[tamnm1601]

Dears,

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?

[v-jingzhang]

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. https://powerbi.microsoft.com/blog/sending-refresh-notifications-to-others/ 

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

[tamnm1601]

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?

[mahenkj2]

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

[SergioSilvaPT]

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!