# SharePoint list to Power BI dashboard, or a grouped view first

> For the full documentation index, see https://250highstreet.com/llms.txt

> Build a Power BI dashboard from a SharePoint list: Export to Power BI or Power BI Desktop, refresh limits, and who needs a license. Plus a grouped view for simple counts.

To build a Power BI dashboard from a SharePoint list, open the list and choose Export, then Export to Power BI, or in Power BI Desktop choose Get data, More, Online Services, SharePoint Online List, paste the site address and tick the list. Then build visuals and save. Sharing the report needs a Power BI Pro or Premium Per User license for the sharer and each viewer, unless the report sits in a workspace on Premium capacity or Fabric F64 or larger. If you only need counts by status, a grouped list view with totals is the simpler first step.

Exact names may differ on your screen. The Microsoft pages behind each step are listed at the end.

## Why managers do not want the grid

A list is built for the people who do the work. It has one row per item and many columns. A manager asks a different question: how many are open, how many are waiting, and is that more than last week. Reading a grid to answer that means counting by hand. Counting by hand is slow, and two people get two answers.

Microsoft's Power BI tutorial opens with "Sometimes a chart is a much easier way for users to quickly understand the data rather than looking at the list itself."

So the goal is a small set of numbers that anyone can read in ten seconds, and that comes from the list itself, not from a copy.

## Decision list: grouped view or Power BI

Answer these in order. Stop at the first "yes" that fits.

1.  Do you need only counts or simple totals for one list, for people who already open that list? Use a grouped view with totals.
2.  Do you need a chart, such as bars by status? Use Power BI.
3.  Do you need to put the numbers on a page for people who do not open the list? Use Power BI.
4.  Do you need numbers from more than one list on one screen? Use Power BI.
5.  Is nobody on your team ready to learn a new tool right now? Start with the grouped view. You can move to Power BI later, because the list stays the same.

Power BI is a separate tool with its own learning curve, and sharing has a license rule. Microsoft says a free Power BI user can make reports only for their own use. To share a report, the person who shares it and the people who view it each need a Power BI Pro or Premium Per User license. The exception is a workspace on Premium or Fabric F64 or larger capacity, where free users can view shared reports. Ask your admin which of these your team has.

## Option 1. A list view with grouping and totals

Microsoft's page on list views says you can group list items by the information in a column. It also says a view can show totals, which are summary calculations for the columns in the view. The page names count, average, maximum and minimum. The page says that setting a column to Count shows the number of items.

Here is one way to start. The worked example uses a help desk list. See "[Help desk ticket tracker in a SharePoint list](/guides/help-desk-tracker-sharepoint/)" for how to build that list.

1.  Open the list and make a new view. Name it "Counts by status".
2.  Open the view options and choose Edit current view. This opens the full view settings.
3.  Find the Group by section. Pick the Status column.
4.  Find the Totals section. Set the Title column to Count.
5.  Save the view.

Worked example. Your Status column is a Choice column. Use numbered choice values: 1 New, 2 In progress, 3 Waiting, 4 Done. Now the view shows four groups, and each group heading carries its count. A manager can read "1 New: 7" without opening any item.

Limits to know, all from the same Microsoft page:

- The page says the maximum number of items in a view is 5,000. For a bigger list, see "[SharePoint list over 5,000 items: what breaks and the fix](/guides/sharepoint-list-view-threshold/)".
- The page says you cannot use Edit in grid view on a grouped view. Keep your editing view separate from your counting view.
- Only public views can be the default view. A personal view is only for you.

Microsoft says filters with \[Today\] or \[Me\] need the classic view editor (Edit current view, then Filters). Our advice, not a Microsoft rule: use the classic view editor for blank and "is not equal to" filters too. If your manager wants "open tickets only", that filter is also set there.

## Option 2. Power BI

Microsoft documents two ways to start from a SharePoint list.

Path A. Power BI Desktop. Microsoft's tutorial for Power BI Desktop says to open Power BI Desktop, choose Get data, then More, then Online Services, then SharePoint Online List. You paste the address of your SharePoint site, sign in with your Microsoft 365 account, tick the list in the Navigator, and select Load. The page then says to open the Report view, tick the columns you want to visualize, and change the visual type if you need to. You can add more than one visual to the same report. Select Save to save the report.

The tutorial also says to check your number columns. They should show the Sum icon in the Data pane. If they do not, change the Data type to Decimal Number or Whole Number.

Path B. From the list in the Power BI service. Microsoft's page on semantic models says you can create a semantic model directly from a SharePoint list. In the list's actions bar, select Export, then Export to Power BI. Power BI then asks you to name the semantic model and choose a workspace. The page says a Power BI account is required. It also says a free Power BI user can save only to My workspace. The page says that if you need to model or change the data in ways the service does not offer, connect from Power BI Desktop instead.

Worked example. You want ticket counts by status.

1.  Use Path A or Path B to load the help desk list.
2.  Choose the Clustered column chart visual. Drag Status to the X-axis. Drag Title to the Y-axis.
3.  Power BI counts a text column placed there, so each bar shows Count of Title for one status. If it shows something else, select the arrow next to Title and pick Count.
4.  Look at the result. Each bar should match the group count from your grouped view in Option 1. If the numbers differ, stop and find out why before sharing anything.
5.  Save the report.

Who sees what. Microsoft's page says the Power BI view of the list data depends on the permissions of the account that set up the connection between Power BI and the SharePoint site. If someone reuses an older connection, the numbers can differ from what you see in the list. Check this before you share a report.

## Refresh basics

A report is only useful if the numbers are current.

- Microsoft's page on semantic models says to keep the data fresh, either refresh the data manually or set up scheduled refresh.
- Microsoft's page on data refresh says Refresh now starts an on-demand refresh. It says a scheduled refresh runs at the times you set.
- The same page says that on shared capacity, Power BI limits a semantic model to eight scheduled refreshes a day. On Premium, Premium Per User or Fabric capacity, you can schedule up to 48 a day. Which one your team has is a question for your admin.
- The page says the owner gets a refresh failure email by default.
- The page says a refresh in the service fails if a source column or table is renamed or removed. Rename or delete list columns with care once a report depends on them.
- The page says an open report does not update on its own when a refresh finishes. Reload the page to see the new numbers.

Microsoft's page says the owner gets refresh failure emails by default, and you can add other people under Email these contacts when the refresh fails. Our advice, not a Microsoft rule: add a second person there, so a failed refresh is seen when the owner is away.

## What to avoid

- Do not build a Power BI report when a grouped view answers the question.
- Do not trust a chart you have not checked against the list. Compare one count by hand.
- Do not rename or delete a list column after a report uses it. The refresh can fail.
- Do not share a report before you check what the connection account can see. Microsoft says the Power BI view of the list is set by that account's permissions.
- Do not put a "days open" number in a calculated column that uses today's date. SharePoint blocks \[Today\] in formulas. Use a view filter instead, or see "[Late tasks nobody notices](/guides/late-tasks-nobody-notices/)".
- Do not copy the list into a spreadsheet each week just to chart it. For the problems with that, see "[SharePoint list export to Excel fails or misses rows](/guides/sharepoint-list-export-to-excel-not-working/)".

## Honest limits

A grouped view shows counts and simple totals. It does not draw charts. Power BI draws charts, but it is a separate tool, and what your team may do with it depends on your plan and your admin. The numbers above, 5,000 items in a view, eight or 48 scheduled refreshes a day, come from Microsoft's pages and can change. Test with your own list.

For another list that managers like to count, see "[RAID log in a SharePoint list: risks, actions, issues, decisions](/guides/raid-log-sharepoint-list/)".

## When to get help

You can build all of this yourself in Microsoft 365. If you would rather have it built and tested for your team, I do that. A tracker like this is a fixed price: \$5,000 for one, built in 2 weeks. See "[What a SharePoint tracker costs to build](/guides/what-a-sharepoint-tracker-costs/)". Bring one example of the problem to a free call.

I am Al Davies. I run 250 High Street LLC and build SharePoint trackers and Power Automate flows for operations teams. I work remotely. The first call is free, and I will not try to sell you anything.

See trackers I built: [Tools I built](/portfolio/)

## FAQ

### How do I create a Power BI dashboard using a SharePoint list?

In the list, select Export, then Export to Power BI, name the semantic model and pick a workspace. Or in Power BI Desktop use Get data, More, Online Services, SharePoint Online List, paste the site address, tick the list in Navigator and select Load.

### SharePoint list Power BI refresh?

Refresh by hand with Refresh now, or set up scheduled refresh. Microsoft's page gives eight scheduled refreshes a day on shared capacity and up to 48 on Premium, Premium Per User or Fabric capacity.

### SharePoint list Power BI integration, where is the menu?

Microsoft's steps read "In the actions bar, select Export \> Export to Power BI." A Power BI account is required.

### Do I need to pay for Power BI?

A free user can build reports for their own use. To share a report, the sharer and each viewer need Power BI Pro or Premium Per User, unless the workspace is on Premium or Fabric F64 or larger capacity. Check Microsoft's current pricing page for costs.

### Why do my chart numbers not match the list?

Check the account behind the connection first. Microsoft says the Power BI view depends on the permissions of that account. Then check for filters, and for a refresh that has not run.

### Can I show only my own items on the dashboard?

A view is not security. For that need, see "[People see only their own items in a SharePoint list](/guides/people-see-only-their-own-items-sharepoint-list/)".

## Sources

- [Create, change, or delete a view of a list or library](https://support.microsoft.com/en-us/sharepoint/lists/data-and-lists/create-change-or-delete-a-view-of-a-list-or-library)
- [Create a report on a SharePoint List in Power BI Desktop](https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-sharepoint-online-list)
- [Create a semantic model from a SharePoint List](https://learn.microsoft.com/en-us/power-bi/connect-data/create-dataset-sharepoint-online-list)
- [Data refresh in Power BI](https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-data)
- [Microsoft Learn, Power BI service features by license type](https://learn.microsoft.com/en-us/power-bi/fundamentals/service-features-license-type)
- [Microsoft Support, Use filtering to modify a SharePoint view](https://support.microsoft.com/en-us/office/use-filtering-to-modify-a-sharepoint-view-3d8efc52-0808-4731-8f9b-3dfaeacea3d4)

## Related guides

- [SharePoint list export to Excel fails or misses rows](/guides/sharepoint-list-export-to-excel-not-working/)
- [Refresh Excel Online data connections on a schedule: what works and what does not](/guides/excel-online-refresh-data-connections-schedule/)
- [Which Power Automate license does a small team need?](/guides/power-automate-license-small-team/)

Source: https://250highstreet.com/guides/sharepoint-list-to-power-bi-dashboard/