How to data mine a SharePoint List with Power BI
Many organizations who use Office 365 use SharePoint lists to keep track of data. It can be any number of items. We’ve seen process information, project tasks, inventory, and more being managed in Power BI.
Power BI provides a SharePoint list connector that connects to the SharePoint OData connector. Theoretically, it should make the connection process easier, yet there are many posts on the Power BI Community site with people struggling to do the basics.
In the video below, I’ll take you through how to connect to the SharePoint list, how to avoid a common security issue, and how to fix data type issues. Please post any questions or suggestions in the comments below.