Trying to Power Query a Teams Excel file

[Blue67]

I'm trying to Power Query a Teams Excel file, with my professional account, but I keep having this error with no details : Invalid Credential. I'm admin on my Tenant, and the account and credentials are correct and working.

I already tried on multiple browsers, clearing cache, nothing is working.

Any idea?

[Blue67]

Ok so trying Sharepoint Folder connexion, I have this error :

I have the right account, I'm admin on my tenant, I've accessed to the file and the url I'm trying to access to (Sharepoint Site Shared Documents), I'm logged, I have tried multiple browsers, The authentication kind in this Sharepoint test is Organization Account (only choice available). New error in yellow.

Thanks for your help and ideas.

[Blue67 · Accepted solution]

Ok so it worked with the Sharepoint Site root folder. What a complex way to simply get a file in my own tenant.

Thanks for your help.

[Blue67]

Here is the screenshot file, I wile try now the Sharepoint connexion.

Url from teams or from Sharepoint that I tried are in the same format : https://mycompany.sharepoint.com/:x/:s/

folders/...

Same error result with both url.

[nilendraFabric]

Hello @Blue67 

When you save a file in Teams, it is actually stored in the associated SharePoint site. To connect via Power Query, you need to use the SharePoint folder connector or the file's direct URL

Use the root URL of the SharePoint site (e.g., https://yourcompany.sharepoint.com/sites/YourTeamName) and avoid specifying the full file path initially. You can filter for the specific file later in Power Query

In Excel, go to Data > Get Data > Data Source Settings >  Edit Permissions, and re-enter your credentials

If all else fails:

1. Delete the existing connection in Power Query.
2. Recreate it by following these steps:
   • Use Get Data > From SharePoint Folder.
   • Authenticate with your organizational account.
   • Filter for your specific file within Power Query.
     
     

Hope this is helpful

[v-prasare]

Hi @Blue67,

Thanks for reaching out to Microsoft Fabric community support.

Can you please share the screenshot and exact error details that your encountering to narrow down the issue caused and come up with best solution for your scenario?

Thanks,

Prashanth Are