Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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?
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?
Turning date off, shall disable the scheduled refresh functionality. Then the report shall be just static.
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!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
80 | |
64 | |
52 | |
49 |
User | Count |
---|---|
211 | |
87 | |
80 | |
69 | |
60 |