cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rfrikha Helper I
Helper I

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 have some modifications on them ! 

So , once i upload my work to my service account , do  i need a gateway to be able to use the Schedule refresh ? 

and my second question is once i update my file on sharepoint all the modifition in the query will be considered ? 

 

Thanks in advance and sorry for the newbie questions 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

Re: Sharepoint and Schedule refresh

Hi @rfrikha ,

 

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.

View solution in original post

2 REPLIES 2
Highlighted
venal Memorable Member
Memorable Member

Re: Sharepoint and Schedule refresh

@rfrikha 

Please refer the link.

https://docs.microsoft.com/en-us/power-bi/refresh-desktop-file-onedrive

If you have any queries, please let us know.

 

If this post helps, then please consider Accept it as the solution to help the other members find it more
If this post was helpful may I ask you to mark it as solution and click on thumb symbol?

Community Support
Community Support

Re: Sharepoint and Schedule refresh

Hi @rfrikha ,

 

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.

View solution in original post

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.