Solved: Dataflows - SharePoint Online

Anonymous · ‎12-03-2020

Hi All,

My organization has lots of data in SharePoint Online excel spreadsheets so I am looking at creating Data flows for each one rather than having to continuously download them after users update them. My question is do I need a Gateway for SharePoint online data sources or can i just connect using a admin account and I can setup a schduled refresh without a gateway?

Thanks

V-lianl-msft · ‎12-06-2020

Hi @Anonymous ,

Based on your description, you are using SharePoint Online as the data source.

If you are getting data from an online data source, you won’t need a gateway. However, if you are getting data from an on-premises data source, then you would need to have gateway setup.

To keep the data up to date, you need to set a refresh schedule by clicking the schedule refresh icon under actions for the dataflow in question. From here, you schedule data refresh in the same manner as you would with ta Power BI Report.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

V-lianl-msft · ‎12-06-2020

Hi @Anonymous ,

Based on your description, you are using SharePoint Online as the data source.

If you are getting data from an online data source, you won’t need a gateway. However, if you are getting data from an on-premises data source, then you would need to have gateway setup.

To keep the data up to date, you need to set a refresh schedule by clicking the schedule refresh icon under actions for the dataflow in question. From here, you schedule data refresh in the same manner as you would with ta Power BI Report.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.