Changing data sources from a Drive Teams (SharePoint)

[MathisD]

Hello PowerBi users,
I come to you today because I can't modify the sources of my data from a SharePoint Drive (used by my company so that everyone can modify the file.).

No possibility to choose a file from a drive.

Moreover, when I try to import data from a drive (in the case of a folder) PowerBi sends me an error message:

Link entered using the SharePoint copying tool:

How to do it,
Thanks for your help.

PS: The source change concerns .XSML files and folders containing .xls files.

[freginier · Accepted solution]

Hi, 

Try to use web connector to get data from your Excel 

 About SharePoint issue, your link is wrong try to remove all element after website name, like this : https://xxxx.sharepoint.com/sites/MySite

[MathisD]

Hello  freginier,
Thank you for your help but your technic doesnt work for folders

[freginier]

That work for me ! 

Maybe can you share your screen when you try to connect to the SharePoint Folder ?