How to Create a Power BI Dashboard from SharePoint List

Transforming a SharePoint list into an interactive Power BI dashboard is one of those skills that looks incredibly complex from the outside but is surprisingly straightforward once you get started. If you have data living in SharePoint, you're sitting on a goldmine of insights waiting to be visualized. This guide will walk you through the entire process, step-by-step, from connecting your data to building a dynamic dashboard that updates automatically.

Graphed

Still Building Reports Manually?

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

Watch the Demo

First Things First: What You'll Need

Before jumping in, let's make sure you have the basics ready. It's a short list, and everything is readily accessible within the Microsoft ecosystem.

• Power BI Desktop: This is the free application from Microsoft where you'll do all the building. If you don't have it, you can download it for free from the Microsoft Store on your Windows PC.
• A SharePoint Online Site: You need access to a modern SharePoint site where your list is stored. This won't work with on-premise SharePoint servers from ages ago.
• A SharePoint List with Data: You need a list that you want to visualize. This could be anything from a project tracker and task list to a sales lead log or a simple inventory. For our example, we'll use a basic project task list with columns like 'Task Name', 'Assigned To', 'Status', 'Due Date', and 'Project'.

Step 1: Connect Power BI to Your SharePoint List

The first step is telling Power BI where to find your data. The connection process is quite simple, but there’s one small detail that often trips people up. Let's get it right.

1. Open Power BI Desktop.
2. On the Home tab, click Get Data. From the dropdown, select More... This opens a new window with a searchable list of all possible data sources.
3. In the search box, type "SharePoint" and select SharePoint Online list from the results. Click Connect.
4. Now, Power BI will ask for the Site URL. This is the crucial part. Do not paste the full URL to your specific list. You only need the URL of the main site. It typically looks something like https://yourcompany.sharepoint.com/sites/YourSiteName.
5. After you paste the Site URL and click OK, Power BI may ask you to sign in. Choose "Microsoft Account" and sign in with the same credentials you use for SharePoint and Office 365.
6. Once authenticated, a Navigator window will pop up, displaying all the lists and libraries available on that SharePoint site. Scroll through and find the name of the list you want to visualize. Check the box next to it.
7. You'll now see a preview of your data on the right. Below the preview are two options: Load and Transform Data. In almost every case, you should choose Transform Data. This opens the Power Query Editor, which is where we'll clean up our data before building visuals.

Step 2: Clean and Prepare Your Data in Power Query

Clicking "Transform Data" brings you into the Power Query Editor. Think of this as your data's workshop. SharePoint lists include a lot of extra system information that we don't need for a clean report, so spending a few minutes here will save you a massive headache later.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Remove Unnecessary Columns

Your SharePoint list comes packed with a ton of hidden columns that SharePoint uses for its own purposes (FileSystemObjectType, ServerRedirectedEmbedUrl, ContentTypeId, etc.). These are just noise for our report.

• In the Power Query Editor's ribbon at the top, go to the Home tab and click Choose Columns.
• A dialog box will appear with every column listed. First, uncheck the (Select All Columns) box at the top to deselect everything.
• Now, carefully go through the list and check only the columns you actually plan on using in your report. This might include your custom columns like 'Title', 'Status', 'Assigned To', and 'Due Date'.
• Click OK. Your table will now look much cleaner and will process faster.

Check and Fix Your Data Types

Power Query tries to guess the data type for each column (text, whole number, date, etc.), but it doesn't always get it right. Correct data types are crucial - you can't perform calculations on a number that's formatted as text, and you can't create a timeline from dates unless Power BI knows they are dates.

• ABC = Text
• 123 = Whole Number
• 1.2 = Decimal Number
• Calendar icon = Date
• Clock icon = Time

If a column has the wrong type - for instance, if your 'Due Date' column shows an 'ABC' icon - click the icon and select the correct data type from the list. Power Query will ask if you want to replace the current conversion step or add a new one, "Replace current" is usually the best choice here.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Expand Complex Columns (The Secret Sauce)

This is the most important cleaning step for SharePoint data. Columns like person pickers ('Assigned To'), choice fields ('Status'), or lookup columns are not stored as simple text. They are stored as records or lists within your table. To use them, you need to "expand" them to pull out the plain text value.

You can identify these columns by the facing-arrows icon in the header.

• Find a column like 'Assigned To' or 'Status'. Click the expand icon (double arrows) on the right side of the column header.
• A dropdown will appear showing the fields available within that record. For an 'Assigned To' column, it might show 'Id', 'Title', 'Email', and 'Department'. You probably just want 'Title' (the person's name). Uncheck everything except for 'Title'.
• Important Tip: Uncheck the box at the bottom that says "Use original column name as prefix." This prevents your new column from being named something messy like AssignedTo.Title and instead just names it Title (which you can then rename to 'Assigned To').
• Click OK. Your record-based column will be replaced by a clean text column containing the name of the assigned person.
• Repeat this process for any other Choice, Person, or Lookup columns you have.

Once you are happy with how your data looks, click the Close & Apply button in the top-left corner. Power BI will apply your cleaning steps and load the data into your report model.

Step 3: Build Your First Dashboard Visuals

This is where your work comes to life! You're now back in the main Power BI window, in "Report view". On the right side, you'll see the Visualizations pane and the Fields pane, which lists your clean data columns.

Create a Simple Count with the Card Visual

Cards are great for showing a single, important number. Let’s create one to show the total number of tasks.

1. Click on an empty space on your report canvas, then click the Card visual icon in the Visualizations pane.
2. A blank card will appear on your canvas. From your Fields pane, drag your main task field (often called 'Title') into the 'Fields' well of the card visual.
3. By default, it will show "First Title". We want a count. In the Fields well, click the small down-arrow on your field and select Count (Distinct). The card will now display the total number of unique tasks in your list.

Visualize Tasks by Status with a Bar Chart

Now, let's see how many tasks are in each status category. A bar chart is perfect for this.

1. Click on the canvas again and then select the Stacked column chart icon.
2. Drag your 'Status' column to the X-axis field well.
3. Drag your 'Title' column to the Y-axis field well. Again, make sure its aggregation is set to Count (Distinct).
4. Instantly, you'll see a bar chart showing the breakdown of tasks by their status ('Not Started', 'In Progress', 'Completed').

See Detailed Information in a Table

Sometimes you need to see the raw details. The Table visual is your best friend here.

1. Select the Table visual from the pane.
2. Drag several fields you want to display into the Columns field. For example: 'Title', 'Assigned To', 'Due Date', and 'Status'.
3. You now have a sortable, filterable table on your dashboard that provides a granular view of your project tasks.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 4: Make Your Dashboard Interactive with Slicers

The real power of a Power BI dashboard is interactivity. Slicers are on-screen filters that allow your users (or you) to easily drill down into the data.

1. Make sure no other visual is selected, then click the Slicer icon in the Visualizations pane.
2. Drag a categorical field you'd want to filter by - 'Assigned To' is a perfect example - into the Field well for the slicer.
3. A simple list of names will appear. Now, try clicking on a name in the slicer. Watch as all the other visuals on your dashboard - the card, the bar chart, and the table - instantly filter to show data only for that person.

You can add multiple slicers for different fields, like 'Project' or 'Status', giving users a powerful way to explore the data on their own terms.

Step 5: Publishing Your Report

Once your dashboard is looking good in Power BI Desktop, you'll want to share it. You do this by publishing it to the Power BI Service (the cloud-based version).

• Click the Publish button on the Home tab.
• You'll be prompted to save your work and then choose a workspace to publish to. "My workspace" is your personal one.
• Once published, you'll get a link to open the report in your browser. From there, you can use the Share function to give read-only access to colleagues and stakeholders. Best of all, you can set up a scheduled refresh so your dashboard automatically pulls the latest data from the SharePoint list every day.

Final Thoughts

By connecting your SharePoint list to Power BI, you've transformed a simple table of data into a living, breathing report that offers real insights. This process empowers you to monitor progress, spot bottlenecks, and communicate performance far more effectively than a static list ever could.

While building your own reports is an incredibly powerful skill, we know it still requires manual steps - connecting sources, cleaning columns, and picking visuals. When we built Graphed you, we designed it to automate this entire workflow. You can securely connect sources like SharePoint, Google Analytics, and Shopify, then just use natural language to ask for what you need. Instead of building a report click-by-click, you can just ask, “Show me my project tasks from SharePoint grouped by status and assignee,” and our AI generates the interactive dashboard for you in real-time.