Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
tamnm1601
Advocate I
Advocate I

Refreshing dataset without loading new data

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?

4 REPLIES 4
v-jingzhang
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. 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.

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?

tamnm1601_0-1652840752960.png

 

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

 

SergioSilvaPT
Resolver V
Resolver V

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!

Regards,
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: https://pbibits.wordpress.com/

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.