Showing results for 
Search instead for 
Did you mean: 
Helper II
Helper II

Autorefresh for select queries skipping another

I have a report that has roughly 8 queries in it, i then combine the data into an extremely useful report.  However, i would like to use the scheduled refresh on the report server to keep all but one query up to date.  However, i cannot as my IT department won't install the connector for one server, so I am unable to save the credentials.  


Which in turn, does not allow me to schedule a refresh.   Does anyone have an idea for a workaround, and or a fix to skip one query in the refresh on the report server refresh?  


Otherwise, my way of refresh is to edit the file on the power BI server, click refresh, wait for all the data to load, save the file.  It is not hard however, i would like to see more up to date information.

Super User IV
Super User IV

Right-click the query and do not include it in refresh.


@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

yes this works for the desktop, however once on the report server, it gets ran.  Maybe in a future Report Server update.  😞

Helpful resources

November Update

Check it Out!

Click here to read more about the November 2020 Updates!

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!


Power Platform October Community Highlights

Check out the top community contributors across all of the communities


Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors