How soon the data refreshes from Spreadsheet in Share point to Power BI service ?

[Anonymous]

Hi Team,

I have developed a report in Power BI desktop for which the data source is a Spreadsheet from Share point folder . 

So I have Clicked on Get Data ---> Selected "Share Point Folder" and located the spreadsheet I have used to build report. I have several Questions and have pointed them below. 

    - Firstly, Every day at 11 AM EST , user of this report update the spreadsheet thats in Share point . I would like this data to be updated automatically in Power BI service(Workspace) without even refreshing the report in PBI Desktop ? How I have to get this done ? 

 - Secondly , If we can get a way to get this refresh done automatically in Power BI Service , How much time does it take to refresh in Power BI report from the time the data gets updated in spreadsheet ( share point) ? 

Kindly provide me steps to complete this request. 

Thanks

G Venkatesh

[jthomson · Accepted solution]

Just turn on a scheduled refresh in the service? I don't think you need any sort of gateway if the data's in Sharepoint, it should only take a few minutes once it's started

[Anonymous]

Hi Thomson,

Thanks . It worked fine with the suggested below method. Never noticed that the gateway is not required for share point as a source . We just need to set a schedule refresh and then it works fine. 

G Venkatesh