In this example, I have a purchases list that keeps track of the organization’s purchases and categorizes them. One benefit of using SharePoint to store this data is the metadata that SharePoint automatically captures like the person who created the SharePoint list item and the date it was created. This information is available for us to use in Power BI. Here are the list columns I am using in my Purchases List.