Forum Discussion
How do connections to source data on SharePoint work after publishing from Desktop to Service?
Jacobe7 ,
Power bi has specific connector for sharepoint online list. Yes, the files which are saved in sharepoint online will be automatically refreshed per hour and you do not need to configure schedule refresh or refresh in desktop and then publish to service.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for your help.
If the file is saved as an Excel document with tables in a SharePoint document library, but not as a SharePoint list, will it still refresh? And, if the file was accessed originally in Desktop to create measures and calculated columns, then published to Service, does the published report on Service still access the Excel file and will it refresh? Or, do I need to re-establish the connection to the Excel file after it's published to service?