connect to teams file in Power BI sharepoint option no longer available

[Anonymous]

Hi

i am trying to connect excel files that are stored on Teams to my pb desktop. Teams used to allow us to select the sharepoint link in order to create a connection to the file however this option is no longer available. when I open the teams folder in sharepoint and copy the link only one of the two files in the folder is available in power bi. can someone please assist

how can I connect to the folder and bring in both files data in power bi ?

[danextian · Accepted solution]

Hi @Anonymous ,

To bring both files in SharePoint into Power BI, you can either connect to each file separately and  append  on to the other or use the SharePoint Folder connnector.

To get the url of the file:

Open the file in desktop app >> go to File tab >> Info >> Copy path

The path would look something like this:

https://mycompany.sharepoint.com/sites/MySite/Subfolder%20Name/AnotherSubfolder/Monthly%20Revenue%20analysis.xlsb?web=1  

Connnect to the file using the path above but remove ?web=1

To connect to the SharePoint Site, use this path:

https://mycompany.sharepoint.com/sites/MySite/ 

From there, navigate to the folder that contains the file filtering the rows. This exposes all files that you have access to in that  site so looking for the right subfolder might take some time.

[Anonymous]

hi , when I connect to the sharepoint folder I can only see one file instead of two. both files were uploaded by me on the sharepoint site

[danextian]

Have you tried refreshing the preview? Does your query have any other filters that exclude the other file?