Excel-Arbeitsmappe von Power Query Desktop zu Sharepoint

[ajourneyinto]

die Funktion ist verschwunden:
Excel-Arbeitsmappe von Power Query Desktop zu Sharepoint

wieso??? und einmal wieder nicht dokumentiert!!!

https://learn.microsoft.com/de-de/power-query/connectors/excel#prerequisites

[Anonymous]

Hi @ajourneyinto,

I wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.
If the community member's answer your query, please mark it as "Accept as Solution" and select "Yes" if it was helpful.
If you need any further assistance, feel free to reach out.

Please continue using Microsoft community forum.

Thank you,
Pavan.

[Anonymous]

Hi @ajourneyinto,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please "Accept as Solution" and give a 'Kudos' so other members can easily find it.

Thank you,
Pavan.

[Anonymous]

Hi @ajourneyinto,

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, kindly "Accept  as  Solution" and give it a 'Kudos' so others can find it easily.

Thank you,
Pavan.

[Anonymous · Accepted solution]

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.

[ajourneyinto]

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?

[Anonymous]

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.