Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 as a data source. Any ideas?
Solved! Go to Solution.
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.
Let me know, if it works.
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.
Let me know, if it works.
Thanks @Anonymous Worked for me.
Hello,
I also would like to use a spreadsheet in Teams as a data source for Power BI.
However, when I follow your directions, I get an error when I copy the link.
The steps I followed were:
1) Navigate in teams to the desired spreadsheet
2) Open in Sharepoint
3) Copy Link
4) remove all after "XXX.sharepoint.com/sites/folder"
5) I then get the error message:
"Unable to Connect
"we encountered an error while trying to connect"
"Details: "access to the resource is forbidden"
I don't understand why I get a message saying my access to the resource is forbidden when I DO have access to not only the sharepoint site, its folders but also the actual file I am attempting to connect to.
Please help. I am not an "IT guy" and have just been thrown into this role.
Thanks
RBALT
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
53 | |
21 | |
12 | |
12 |