connect data present on SharePoint with power bi

[Anonymous]

How to connect data present on SharePoint with power bi desktop and service? Will it require an individual's corporate id? Can we skip that?

[Anonymous]

Hi @Anonymous ,

Which one you want to connect? SharePoint Online or SharePoint Folder?

• To connect to a SharePoint folder:

Please refer to the following document for more details.

https://docs.microsoft.com/en-us/power-query/connectors/sharepointfolder#connect-to-a-sharepoint-folder-from-power-query-desktop

• To connect to Sharepoint Online:

Please refer to the following document for more details.

https://docs.microsoft.com/en-us/power-query/connectors/sharepointonlinelist#connect-to-a-sharepoint-online-list-from-power-query-desktop

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@Anonymous you not to use oautho2 to connect to SharePoint, maybe create a service account that has access to SharePoint and can be used in Power BI.

✨ Follow us on LinkedIn

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡