Showing results for 
Search instead for 
Did you mean: 
kfarynowski Frequent Visitor
Frequent Visitor

Is SharePoint 2013 required to be able to do scheduled data refreshes?

Having difficulty scheduling data refreshes, understanding what tools needed.  Attempted to install Personal gateway as another means but seems like something missing in our architecture as it never gets past the install to be able to configure. I have a SQL query in powever pivot, or could put the results in excel, but want to have the other users access the refreshed data without having to do a "refresh". 

Super User
Super User

Re: Is SharePoint 2013 required to be able to do scheduled data refreshes?

No, that is not a requirement, more likely it is this:


Personal Gateway fails to install - Personal Gateway fails to install if the user is in the Administrator group, but group policy does not allow that user to log on as a service.  At the moment, ensure the group policy allows a user to log on as a service. We’re working on a fix for this issue. 



I have book! Learn Power BI from Packt

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

Proud to be a Datanaut!


Re: Is SharePoint 2013 required to be able to do scheduled data refreshes?

You don't need SharePoint for scheduled refreshes. 


You need to install Gateway on a computer on your corporate network that has access to the internet (or your corporate laptop) in order to provide connectivity between your data set in the cloud and your corporate data.


Once that is set up, you can cick on three dots that show up next to the data set name when you mouse over it, then you can click on Schedule refresh and have your data set updated at the desired schedule.

Helpful resources

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: 63 members 2,476 guests
Please welcome our newest community members: