Select the SharePoint List you would like get data from into Power BI. In my example, I selected the Purchases list and then clicked Edit. You can click Load to load all columns in the SharePoint List, but this brings in more data than you would need, especially some of the internal SharePoint fields which would not be useful in analyzing the data.