Introduction
In this article, we will check how we can use SharePoint List as a data source in Microsoft Power BI. Please follow the below steps to establish the connection of SharePoint Online list with Power BI.
Step 1
Open Power BI Desktop > Get Data > Click More.
![](https://static.wixstatic.com/media/16ed53_2a127edfb9fd40ec98e334d21b2ac569~mv2.png/v1/fill/w_115,h_121,al_c,q_85,usm_0.66_1.00_0.01,blur_2,enc_auto/16ed53_2a127edfb9fd40ec98e334d21b2ac569~mv2.png)
Step 2
Search for SharePoint > SharePoint Online List.
![](https://static.wixstatic.com/media/16ed53_e62fd1d4412046c1915ea279d31c08a0~mv2.png/v1/fill/w_63,h_67,al_c,q_85,usm_0.66_1.00_0.01,blur_2,enc_auto/16ed53_e62fd1d4412046c1915ea279d31c08a0~mv2.png)
Step 3
Enter the URL of your SharePoint site.
![](https://static.wixstatic.com/media/16ed53_a922f9a1184642f4aa46563835b9dfac~mv2.png/v1/fill/w_70,h_22,al_c,q_85,usm_0.66_1.00_0.01,blur_2,enc_auto/16ed53_a922f9a1184642f4aa46563835b9dfac~mv2.png)
Step 4
Click on Organizational account > Sign In.
![](https://static.wixstatic.com/media/16ed53_a6cd0aaa45014a459edfc304b20fa30a~mv2.png/v1/fill/w_70,h_43,al_c,q_85,usm_0.66_1.00_0.01,blur_2,enc_auto/16ed53_a6cd0aaa45014a459edfc304b20fa30a~mv2.png)
Step 5
It will open the screen of Office 365 Login > Enter Credentials.
![](https://static.wixstatic.com/media/16ed53_8eeb4f79b8ac4f95bc52e2c56d1ba236~mv2.png/v1/fill/w_49,h_34,al_c,q_85,usm_0.66_1.00_0.01,blur_2,enc_auto/16ed53_8eeb4f79b8ac4f95bc52e2c56d1ba236~mv2.png)
Step 6
Click on Connect.
![](https://static.wixstatic.com/media/16ed53_1d6ea7a7a87a4706b7995d6b628d452f~mv2.png/v1/fill/w_70,h_41,al_c,q_85,usm_0.66_1.00_0.01,blur_2,enc_auto/16ed53_1d6ea7a7a87a4706b7995d6b628d452f~mv2.png)
Step 7
It will show all the lists available in the SharePoint - lists are on the left corner and their preview is on the right.
Select all the lists which you want to use directly in the Power BI.
Click on Load.
![](https://static.wixstatic.com/media/16ed53_09f958a0ebbc42d59f4f5e896f749242~mv2.png/v1/fill/w_87,h_69,al_c,q_85,usm_0.66_1.00_0.01,blur_2,enc_auto/16ed53_09f958a0ebbc42d59f4f5e896f749242~mv2.png)
Step 8
It will load all the lists. Expand "Fields" column to view all the fields shown in the SharePoint List.
![](https://static.wixstatic.com/media/16ed53_adbf20b5506c400b8694dbbe2920fdf0~mv2.png/v1/fill/w_49,h_21,al_c,q_85,usm_0.66_1.00_0.01,blur_2,enc_auto/16ed53_adbf20b5506c400b8694dbbe2920fdf0~mv2.png)
We can also view all the lists in relationship list.
In Data tab, you can also view the data of your SharePoint List.
![](https://static.wixstatic.com/media/16ed53_63a759b6ed0c450c90b055cbbbc531ea~mv2.png/v1/fill/w_49,h_12,al_c,q_85,usm_0.66_1.00_0.01,blur_2,enc_auto/16ed53_63a759b6ed0c450c90b055cbbbc531ea~mv2.png)
Conclusion
This is how we can configure SharePoint Online List with Power BI Desktop. Now, you can use SharePoint List as a data source and prepare Power BI reports using different visuals.
Don't forget to subscribe to me on Youtube for amazing videos.. Follow Me