Share via

Cannot Connect Power Query to Sharepoint Folder

Anonymous
2024-06-11T02:20:27+00:00

Here is my Microsoft Version. I have An Enterprise 365 account

Microsoft® Excel® for Microsoft 365 MSO (Version 2405 Build 16.0.17628.20006) 64-bit

If i go to Excel Desktop App>Data>Get Data>From File>"Sharepoint Folder" Does not appear

If I go to Excel Desktop App>Data>Get Data>From Web>and Enter the Sharepoint Root URL, I still cannot connect and get errors no matter what i do.

This seems to be a common problem but many of the threads i found did not have good answers.

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

Answer accepted by question author

Anonymous
2024-06-11T14:07:20+00:00

Switch subscription need reinstall office since they are different product.

Was this answer helpful?

1 person found this answer helpful.
0 comments No comments

2 additional answers

Sort by: Most helpful
  1. Anonymous
    2024-06-11T13:59:56+00:00

    So I had our admin upgrade me and a few other team members to Enterprise yesterday. In my online MS365 portal it shows Apps for Enterprise under "Subscriptions" - IMAGE 1

    BUT when I go to the excel desktop app I still see MS 365 Apps for Business. I have tried to "Switch License" and "Update License" and Updating my MS apps. - IMAGE 2

    I would like to avoid reinstalling all my MS office apps if possible.

    IMAGE 1

    Image

    IMAGE 2

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2024-06-11T02:49:03+00:00

    Could you share your office subscription?

    From SharePoint folder is available for Enterprise subscription.

    Power Query data sources in Excel versions - Microsoft Support

    Was this answer helpful?

    0 comments No comments