Connect Sharepoint files to power query

[olsenmolsen]

Dear Power Query Community,
I have been trying for quite some time to add a SharePoint as a source in the data source settings, but I don't see it listed there. Various help resources suggest selecting ‘New Source’ > ‘From File’ > ‘From SharePoint,’ but I do not have this option in my Power Query Editor. Nowhere can I find an option to add SharePoint. Even in the data source settings, I can’t find anything 😞 Are the instructions I’ve received from ChatGPT or other sources regarding the import possibly incorrect?

I am using 365 Business Premium

Thanks alot for your help

[olsenmolsen]

thanks alot. That helped me to connect the lists. I now can use them in power query

[uzuntasgokberk · Accepted solution]

Hello @olsenmolsen ,

İs it paginated report? İf it can you follow this link:
h target=_blank target=_blankttps://powerbi.microsoft.com/en-us/blog/get-data-with-power-query-avail...

İf it is excel can you follow below the image?

Kind Regards,
Gökberk Uzuntaş

📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |