CODEWITHSUNDEEP
sharepointpowerbisharepoint-onlinepowerbi-datasource
Murilo Santana
Murilo Santana

Reputation: 665

Power BI Report Builder - SharePoint as data source

Is it possible to use Power BI Report Builder to connect to a SharePoint list?

It seems that it was possible to do that with the old SSRS Report Builder - link.

I would like to Build a SSRS-like report with Power BI using different SharePoint lists as Data Sources. I tried to use the Power BI Desktop app to build a report but I couldn't matrix/tables/sections repetitions.

enter image description here

Upvotes: 1

Views: 7535

Answers (2)

Gangula
Gangula

Reputation: 7254

In the latest update(July 2019) of Power BI Report Builder, you can use NON-PREMIUM datasets from Power BI Service as a data-source for Report Builder.

So you can simply create a Dashboard in Power BI desktop from any SharePoint list and publish it in your work-space. To create a dataset from a SharePoint list, go to Get Data > Online Services > SharePoint online list and add fill in the details. Then Publish your dashboard in your workspace.

Once that is done, you can use that dataset in your report builder.

Check the image below:

Report Builder - Power BI Dataset

Note: You can also Schedule a Refresh on your dataset so that your data is up-to-date.

Upvotes: 3

Lee
Lee

Reputation: 5493

Get data->More, you could find SharePoint Online List option.

enter image description here

Upvotes: -2

Related Questions