How to Create a Power BI Report from SharePoint List

Transforming a simple SharePoint list into a dynamic Power BI report can feel like unlocking a superpower. SharePoint is fantastic for collaborative data entry - tracking tasks, logging issues, or managing inventory - but its native reporting capabilities can be limiting. This guide will walk you through, step-by-step, how to connect your SharePoint list directly to Power BI to create powerful, interactive, and shareable reports.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Connect a SharePoint List to Power BI?

Connecting these two Microsoft powerhouses is a game-changer for several reasons. SharePoint provides an easy-to-use, collaborative front-end for your team to input and update data in real-time. Power BI then acts as the sophisticated analysis and visualization engine on the back-end.

This allows you to:

• Visualize Project Progress: Turn a task list into a dashboard showing tasks by status, assigned user, and due date.
• Analyze Survey Data: Convert survey responses stored in a list into charts that reveal trends and sentiment.
• Monitor Inventories: Create reports that track stock levels, flag low-inventory items, and show inventory turnover.
• Build Interactive Reports: Allow stakeholders to slice and dice the data with interactive filters and slicers, going from a high-level overview to granular details in a single click.

Before You Begin: Required Elements

To get started, make sure you have the following ready. It's a short list, and most of it is free to use.

• Power BI Desktop: If you don't already have it, you can download it for free from the Microsoft Store. This is where you'll build your report.
• SharePoint Online Access: You need permission to access a SharePoint Online site where your list is located.
• Your SharePoint Site URL: You'll need the main URL for your SharePoint site, not the full URL to the specific list. We'll cover how to find this next.

Step-by-Step: Connecting Power BI to Your SharePoint List

Let's walk through the process of getting your data from SharePoint into Power BI. Follow these steps carefully to ensure a smooth connection.

Step 1: Find Your SharePoint Site URL

This is the most common place where users get stuck. Power BI does not need the long URL that points directly to your list view. It only needs the root URL of the SharePoint site where the list lives.

Navigate to your SharePoint list in your browser. Look at the URL. It will look something like this:

https://bigcorp.sharepoint.com/sites/MarketingDepartment/Lists/CampaignTracker/AllItems.aspx

You only need the first part of that URL. In this case, it would be:

https://bigcorp.sharepoint.com/sites/MarketingDepartment

Copy this root URL. You'll need it in a moment.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 2: Get Data in Power BI

Open Power BI Desktop. In the "Home" tab of the ribbon, click on Get Data. A dropdown menu will appear. You might see "SharePoint List" here, but the best practice is to click More... at the bottom to open the full data source navigator.

In the "Get Data" window, type "SharePoint" into the search bar. You will see a few options. Select SharePoint Online List and click Connect.

Step 3: Enter Your Site URL

A dialog box will pop up asking for the Site URL. This is where you paste the root URL you copied in Step 1. Don't paste the full link to the list anymore.

You'll also see an 'Implementation' option. It's generally best to leave this as 2.0 (the default), as it's more robust and uses an optimized API. Click OK.

If you're not already signed in, Power BI will prompt you to authenticate. Choose "Microsoft Account" and sign in with your Microsoft 365 credentials.

Step 4: Select Your List

Once you successfully connect, a "Navigator" window will appear. This window shows you all the lists and document libraries available on the SharePoint site you connected to. Scroll through the list or use the search bar to find the specific list you want to visualize. Check the box next to your list's name. A preview of the data will appear on the right.

Step 5: Transform Your Data (Don't Skip This!)

At the bottom right of the Navigator window, you'll see two buttons: "Load" and "Transform Data." While pressing "Load" is tempting, you should almost always click Transform Data.

This button opens the Power Query Editor, a powerful tool for cleaning and preparing your data before you start building visuals. SharePoint lists contain many hidden and system-generated columns that you don't need, and Power Query is the perfect place to clean them up.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Cleaning Your Data in Power Query

The Power Query Editor is where you ensure your data is clean, correctly formatted, and easy to work with. Taking a few moments here will save you hours of headaches later.

1. Remove Unnecessary Columns

A SharePoint list brings in dozens of columns that start with prefixes like "FileSystemObjectType" or "ContentTypeId." These are for internal use and will just clutter your report.

Select the columns you actually need for your report (hold Ctrl to select multiple columns). Then, in the "Home" tab, select Remove Columns and choose Remove Other Columns. This gets rid of all the clutter in one click, leaving only the data you care about.

2. Expand Record Columns

Columns that look up information, such as "Created By" or "Assigned To," will appear as [Record] or [List] in Power Query. You need to expand them to access the underlying data (like the person's name or email).

Click the two-way arrow icon in the column header. A dropdown will appear with the fields you can pull out, such as Title (the display name), Email, Id, etc. Select only the fields you need (e.g., Title) and uncheck "Use original column name as prefix." Click OK.

3. Rename Columns and Check Data Types

Clean up your column names to be more readable. You can double-click any column header to rename it (e.g., rename "Title" to "Task Name").

Finally, check that the data types for each column are correct. Power Query is usually smart about this, but it's good to confirm. Look at the icon next to each column name. Ensure dates have a calendar icon, numbers have a "123" icon, and text has an "ABC" icon. If anything is wrong, click the icon and select the correct data type.

Once you are happy with how your data looks, click Close & Apply in the top-left corner of the Power Query Editor. This will load your clean, transformed data into your Power BI model.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Building Your First Power BI Report

Now for the fun part! With your data loaded, you can start building visuals. The Power BI interface is divided into three main sections: the Fields pane (right), the Visualizations pane (middle), and the report Canvas (left).

Example 1: Task Status Pie Chart

1. In the Visualizations pane, click the Pie chart icon. A blank visual will appear on your canvas.
2. From the Fields pane, drag your "Status" column into the "Legend" field well in the Visualizations pane.
3. Drag your "Task Name" column into the "Values" field well. Power BI will automatically change this to "Count of Task Name," giving you a count of tasks for each status.

Example 2: Adding an Interactive Slicer

Slicers are interactive filters that make your report dynamic.

1. Make sure no visuals are selected by clicking on a blank area of the canvas.
2. In the Visualizations pane, click the Slicer icon.
3. From the Fields pane, drag the "Assigned To" column (or whatever you renamed the person field to) into the "Field" well of the slicer visual.

You now have a filter on your page. Clicking a name in the slicer will filter the pie chart (and any other visuals on the page) to show data only for that person.

Final Thoughts

You’ve now successfully connected a SharePoint List to Power BI, transformed the raw data into a clean, usable format, and built your first interactive visual. This process turns a simple list into a powerful foundation for building comprehensive dashboards that can inform business decisions and keep your team aligned.

While mastering tools like Power BI is an incredibly valuable skill, we know it still involves many steps and a steep learning curve. At Graphed, our goal is to eliminate that friction. We allow you to connect all your data sources in one-click - from Google Analytics and Salesforce to data in spreadsheets - and then build the exact dashboard you need by simply describing it in plain English. No more wrestling with data connectors or spending hours in the Power Query Editor, just ask a question and get a live, interactive dashboard in seconds.