Skip to main content

Posts

Use SharePoint Online List As A Data Source In Power BI

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
Recent posts

Create Custom People Search Page With Phone Number Attribute In SharePoint Online

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

Use Wikipedia As A Data Source To Prepare Power BI Report

Overview Power BI is a business intelligence tool that supports so many data sources to prepare a report. As we all know, Wikipedia is a very good resource of useful information, and we can consume Wikipedia data as a data source and prepare a Power BI report. Example In this example, we will prepare a report of the largest selling pharma products. We will use the following URL as a Data Source - https://en.wikipedia.org/wiki/List_of_largest_selling_pharmaceutical_products If we open the above link, it will show the analytical data for selling  a pharma product. Note -  Make sure of one thing - If we want to use Wikipedia as a data source, its information must be stored in a tabular manner. Only then can we consume its data in Power BI. Now, let’s get stated! Step 1 Open Power BI Desktop and click on Get Data.   Step 2 Select Other Services > Web as a data source. Then, click "Connect".   Step 3 It will ask you to enter the URL. Post the URL a