cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
MrNoob Regular Visitor
Regular Visitor

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.

2 REPLIES 2
Super User
Super User

Re: Autorefresh for select queries skipping another

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


I have book! Learn Power BI from Packt


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

Proud to be a Datanaut!

MrNoob Regular Visitor
Regular Visitor

Re: Autorefresh for select queries skipping another

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

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 69 members 1,260 guests
Please welcome our newest community members: