question

DinorahMayo-2298 avatar image
0 Votes"
DinorahMayo-2298 asked SharonZhao-MSFT commented

Connect files from Teams to Power BI

Hello,

How can I connect different Excel files, stored into Teams, with Power BI?

What I did was:
1.- Access to my Teams group
1. Go to files
2. Click on "Open in SharePoint"
3. Once in the SharePoint, open the Excel file on Excel app
4. On Excel file, click on "Info" & copy the path
5. Go to Power BI > Get Data > From Web > Basic
6. Paste the link from Excel file
7. Remove the "?web=1" from the link
8. Click on "OK"

But I got the following message:

Unable to connect
We encountered an error while trying to connect.
Details: "Access to the resource is forbidden."


This does NOT happen when I connect files stored in a SharePoint (without Teams involved).



Thanks in advance for your kindly support!






office-teams-windows-itpro
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

SharonZhao-MSFT avatar image
0 Votes"
SharonZhao-MSFT answered SharonZhao-MSFT commented

@DinorahMayo-2298,

The root cause for this problem is that Microsoft Teams is not a default connector from Power BI desktop. As you know, the workaround is to use SharePoint. SharePoint connectors are available in Power BI desktop.

Many people discuss about this question in Power BI community. You could know more information from this link.

Aa we are mainly responsible for general problem of Microsoft Teams, your question is more related to Power BI. For the related questions about Power BI, you can ask in here. Thanks for your understanding.


If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@DinorahMayo-2298,
Do you have any further question on this topic now?
If the suggestion helps, please be free to mark it as an answer for helping more people.

0 Votes 0 ·

@DinorahMayo-2298,
Haven't received your update for a long time, any update now?
If the above suggestion helps, please be free to mark it as answer for helping more people.

0 Votes 0 ·