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. Step 2 Search for SharePoint > SharePoint Online List. Step 3 Enter the URL of your SharePoint site. Step 4 Click on Organizational account > Sign In. Step 5 It will open the screen of Office 365 Login > Enter Credentials. Step 6 Click on Connect. 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. Step 8 It will load all the lists. Expand "Fields" column to view all the fields shown in the SharePoint List. We can also view all the lists in relationship list. In Data
We have a requirement from one of our clients. They want to modify the “peopleresults.aspx” page which is the default People Search Page provided by SharePoint OOTB. SharePoint OOTB People Search page provides the following properties. Name Title Department About Me Below is a screenshot of OOTB People Search result which will sync the above four properties from SharePoint User Profiles. We want to show Phone Number with People Search. For that, make sure that Phone number is already synced from AD to SharePoint User Profiles. I assume that we have synced Phone Number already. First, we will modify OOTB template of People Search. For that, first, go to Search Center Site. Ex - https://abc.sharepoint.com/search 1. Go to Site Setting > Web Designer Gallery >Master Page and Page Layout. 2. Click on "Display Templates". 3. Click on "Search". 4. Download a copy of “ItemPerson.html”. 5. Now, we will modify the code an