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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
gfdytr4
Helper I
Helper I

Disable refresh on specific data source to enable scheduled refresh

I have disabled "Include in report refesh" in power query for two tables from different different sources that i dont have gateways for. But these sources are still included when the the report is published and therefor enabling scheduled refresh is not supported. 

 

This video from 2018 describes the same issue: https://www.youtube.com/watch?v=uxsQUArF2Ts

 

Is there a fix for this?  

1 ACCEPTED SOLUTION

Hi @gfdytr4 

If you disable refresh or static data, still data connection are there and you need to provide credential in Gateway setup. 
All data source mentioned in your data source settings, you need to setup gateway connection.

PijushRoy_0-1697534457330.png

 

If solve your question, please mark as SOLUTION




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!





View solution in original post

3 REPLIES 3
PijushRoy
Super User
Super User

Hi @gfdytr4 

Yes if you connected from data source, you should setup gateway for the datasource.
If these are static file and small file like Lookup table, please use ENTER DATA.
So that way you no need to provide gateway connection.

Thanks




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!





Thanks but this is not possible. Preferably its possible to disable refresh on the individual data sources so scheduled refresh works and I can intermitently do a manual refresh to up date all data sources.   

Hi @gfdytr4 

If you disable refresh or static data, still data connection are there and you need to provide credential in Gateway setup. 
All data source mentioned in your data source settings, you need to setup gateway connection.

PijushRoy_0-1697534457330.png

 

If solve your question, please mark as SOLUTION




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!





Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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