Changing excel file data source/location

Hi bpontius,

>>Will this enable users who have access to the Sharepoint to refresh the data in PowerBI?

I'm not so clear for your description, but if you direct connect to sharepoint team site files, it will use sharepoint to manage the refresh without gateway. (For this mode, you cannot use this file as the source of tiles.)

For #2, if you want to import sharepoint site files to power bi, you can refer to below steps:

1. Navigate and open the excel file.

2. Click the 'Edit Workbook' -> 'Edit in Excel'.

3. Copy the path to clipboard.

File - > Info

4. Open the import dialog and paste the url, then remove "?web=1" and select the 'copy data' mode to finish the operation.('Import' - > 'workbook')

After you finish and publish to service, this dataset will use connect to sharepoint with 'connect direct' mode.

Regards,

Xiaoxin Sheng