Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Sharepoint and Schedule refresh

Greeting ,    i have a little question here : im kinda new to Power BI , i have Excel files on Sharepoint , im gonna connect to them using PowerBI desktop and by using the Editor query im gonna hav...
Tips and Tricks
  • v-xicai's avatar
    v-xicai
    6 years ago

    Hi Anonymous ,

     

    If your dataset only contains the excel file which is saved in SharePoint online in Office 365, then it needn't to use gateway.

     

    If your dataset not only contains cloud data source but also the on premise data source, then it needs to use the gateway and configure schedule refresh, see more: :On-premises data gateway , Configure scheduled refresh . Note that you also need to select Allow user's cloud data sources to refresh through this gateway cluster option Under Gateway Cluster Settings. See: Merge or append on-premises and cloud data sources.

     

    For your question2, all the modifications for the SharePoint files in Query Editor will be updated when you publish the pbix file to Power BI Service.

     

    Best Regards,

    Amy

     

    Community Support Team _ Amy

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

v-xicai's avatar
v-xicai
Community Support
6 years ago

Hi Anonymous ,

 

If your dataset only contains the excel file which is saved in SharePoint online in Office 365, then it needn't to use gateway.

 

If your dataset not only contains cloud data source but also the on premise data source, then it needs to use the gateway and configure schedule refresh, see more: :On-premises data gateway , Configure scheduled refresh . Note that you also need to select Allow user's cloud data sources to refresh through this gateway cluster option Under Gateway Cluster Settings. See: Merge or append on-premises and cloud data sources.

 

For your question2, all the modifications for the SharePoint files in Query Editor will be updated when you publish the pbix file to Power BI Service.

 

Best Regards,

Amy

 

Community Support Team _ Amy

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