Forum Discussion

Blue67's avatar
Blue67
New Member
1 year ago
Solved

Trying to Power Query a Teams Excel file

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 ...
data warehouse
  • Blue67's avatar
    Blue67
    1 year ago

    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.

nilendraFabric's avatar
nilendraFabric
Icon for Super User rankSuper User
1 year ago

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