Power BI Visualization on Share Point List

Thamaraijay
BI3 Technologies
Published in
3 min readSep 17, 2021

In this blog, we are going to see the creation of share point list and integrating the same with Power BI , then instantly we can get the visualization without any DAX formulas, Queries, etc..

Power BI recently released this feature : Power BI Visualization directly from Share Point List.

Open Your Organization’s Share Point to create Share Point List

Step 1: Click on New to create a list

Click “New” to list down the values

Step 2: Choose the list

Click List to create

Step 3: Select the list type, what you want

In this, we just Selecting the Blank List. you can choose based on your wish.

Choose blank list/From Excel/From Existing List

Step 4: Enter the Name & Description of the list

Give Name & Description

Note: On enabling the “Show in site navigation” will give the list in the side menu bar to quick access.

Step 5: Add Columns you want in the list by clicking the “Add Columns

Add Columns for your list

You should choose/enter the Column name followed by column datatype here

Choose the column type in the list of values
Describing the column details

Note: Here I have created the Product_Name, Price, Sold_Date, Profit, Quantity, Sales columns in the Sales list.

Step 6: On clicking the New, we can add the row values to the list

Add some rows of data here
Enter value to all the columns in the list by clicking “New”

Step 7: Let’s Integrate the Power BI with this share point list

  1. Click on Integrate
  2. Click on Power BI
  3. Click on Visualize the list
Integrating with Power BI

In just a second we can see the auto generated “Power BI Visualizations” in the new tab

Generated Visualization at initial

We can customize the visualization as per our wish

Customized Visualization 1
Customized Visualization 2

Yes, Finally we have the Power BI Visualization in hand for the Share Point List in the simple way.

We will see the latest features from the Power BI in the future blogs to update you guys.

About Us

Bi3 has been recognized for being one of the fastest-growing companies in Australia. Our team has delivered substantial and complex projects for some of the largest organizations around the globe and we’re quickly building a brand that is well known for superior delivery.

Website : https://bi3technologies.com/

Follow us on,
LinkedIn : https://www.linkedin.com/company/bi3technologies
Instagram :
https://www.instagram.com/bi3technologies/
Twitter :
https://twitter.com/Bi3Technologies

--

--