Forum Discussion
Excel-Arbeitsmappe von Power Query Desktop zu Sharepoint
Hi ajourneyinto,
Thank you for reaching out in Microsoft Community Forum.
I’m sorry to hear that you’re having trouble finding the feature to import Excel workbooks from Power Query Desktop to SharePoint. There have been some changes and deprecations in certain Excel connectors, particularly in relation to Power Automate, Logic Apps, and Power Apps. These changes may have affected the availability of specific features.
For importing Excel files from SharePoint, it is recommended to use the "SharePoint Folder" connector in Power Query. This allows you to access files stored in SharePoint and load them into Power Query.
If the feature is still missing, it might help to install the latest version of Power Query or update your Office applications, as some features may be reintroduced in newer versions.
Please continue using Microsoft community forum.
If you found this post helpful, please consider marking it as "Accept as Solution" and give it a 'Kudos'. if it was helpful. help other members find it more easily.
Regards,
Pavan.
Hi ajourneyinto,
Thank you for reaching out in Microsoft Community Forum.
I’m sorry to hear that you’re having trouble finding the feature to import Excel workbooks from Power Query Desktop to SharePoint. There have been some changes and deprecations in certain Excel connectors, particularly in relation to Power Automate, Logic Apps, and Power Apps. These changes may have affected the availability of specific features.
For importing Excel files from SharePoint, it is recommended to use the "SharePoint Folder" connector in Power Query. This allows you to access files stored in SharePoint and load them into Power Query.
If the feature is still missing, it might help to install the latest version of Power Query or update your Office applications, as some features may be reintroduced in newer versions.
Please continue using Microsoft community forum.
If you found this post helpful, please consider marking it as "Accept as Solution" and give it a 'Kudos'. if it was helpful. help other members find it more easily.
Regards,
Pavan.
Hi
Well, Microsoft is constantly increasing the pricing but not delviering a constant service... even not for their own products... looks like Sharepoint is a different world now...
I have the latest Excel, PowerQuery and still nothing available to import Sharepoint Lists and Folders...
What to do?
Hi ajourneyinto,
Thank you for reaching out in Microsoft Community Forum.
Since you already have the latest Excel and Power Query updates. here are some troubleshooting steps to resolve the issue;
1. Open Power Query in Excel, go to Data > Get Data > From Other Sources, and look for SharePoint Folder or SharePoint List. If these options are missing, it might indicate a configuration issue.
2. If the SharePoint connector isn’t available, try using Get Data > From Web and enter your SharePoint URL directly. You may need to authenticate manually.
3. If Excel isn’t working as expected, you might consider Power BI or Power Automate as alternative ways to extract SharePoint data.
Please continue using Microsoft community forum.
If you found this post helpful, please consider marking it as "Accept as Solution" and give it a 'Kudos'. if it was helpful. help other members find it more easily.
Regards,
Pavan.