To connect to the your SharePoint Online List, you will need the root URL of your Sharepoint site which is visible on the browser's address bar.


It should look something like this hypothetical link: https://keminind.sharepoint.com/sites/KeminSales. The root URL should not include excessive numbers or symbols. 

 

SharePoint Online Lists are commonly used to collect data collected from Nintex Forms. The following is an example of SharePoint online list: 

 

    1. Open Power BI Desktop then select  Get Data > More…

     

     

      1. Search for SharePoint Online List 

       

       

        1. Enter the root URL of your SharePoint site

         

         

          1. Click on the Organizational account > Sign in

           

            1. A window will pop up to prompt you to sign in 

             

              1. Click on Connect

               

               

                1. It will show all lists available on the SharePoint site. Select the lists that you need to import into Power BI. Then click Load. 

                 

                 

                  1. You are now set to build your visualizations or transform your data.