Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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.
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.
@Anonymous
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.