Forum Discussion

Mchege's avatar
Mchege
New Member
7 years ago
Solved

Using a file in Microsoft teams as a data source

I am colaborating with collegues in Microsoft teams using and excel file that we all access and edit. I want to create a power BI report from this spreadsheet but cant find a way to select this file ...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Mchege,

 

While in Teams, hit button "Open in Sharepoint" marked in yellow. (Sorry for my locale language)

 

You will need your copy your link to your sharepoint folder, in my case: 

 

https://company.sharepoint.com/sites/NVGCMPowerBIReporting

 

 

Then follow below instruction.

https://community.powerbi.com/t5/Integrations-with-Files-and/Can-t-connect-to-Sharepoint-subsites-using-PowerBI/m-p/626893/highlight/true#M21930

 

Let me know, if it works.

Mchege's avatar
Mchege
New Member
7 years ago

Hi Rasty,

I tried this and it worked. Looks like it was the way I entered the sharepoint link. I also got assistance from my collegue on the next steps after that and it worked. Thanks you for your help