paginated report using sharepoint

[powerbiexpert22]

can i create paginated report using below as source systems

1 sharepoint online list

2. sharepoint on premises list 

[v-nuoc-msft]

Hi @powerbiexpert22 

@Sahir_Maharaj  Thanks you for sharing !

Yes, you can create paged reports using SharePoint Online and SharePoint local lists as source systems.

For SharePoint Online lists:

Export a paginated report for each row in an Excel Online table or SharePoint list - Power BI | Micr...

Solved: Paginted report from a Sharepoint Online list - Microsoft Fabric Community

For SharePoint local lists:

Although Power BI Report Builder does not directly support connectivity to SharePoint local lists, this can be resolved by using SQL Server Reporting Services (SSRS) to connect to local lists.

Alternatively, you can synchronize SharePoint local data to a cloud service such as Azure SQL Database and then connect Power BI Report Builder to that cloud service.

It is important to note that you can have multiple data sources for a single paged report, and you can create embedded data sources and datasets in the paged report itself.

However, you cannot use shared data sources or shared datasets to create reports in the Report Builder on the local computer.

What are paginated reports in Power BI? - Power BI | Microsoft Learn

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[powerbiexpert22]

Hi @v-nuoc-msft 

none of the approaches which you suggested can directly connect report builder with MS sharepoint online list, also we do not want to use SSRS reports so this option we cannot consider for connecting with MS sharepoint list for on premises

[Sahir_Maharaj]

Hello @powerbiexpert22,

Yes, you can. 

SharePoint Online List

• To connect to a SharePoint Online list, you would use the OData feed URL of your SharePoint list as the data source.
• Once your paginated report is created in Power BI Report Builder, you can publish it to Power BI service, provided you have a Power BI Premium or a Premium Per User (PPU) license.

SharePoint On-Premises List

• To access a SharePoint On-Premises list, you'll need to use the On-premises data gateway.
• SharePoint On-Premises lists can also be accessed via OData services

Note: For SharePoint Online, data refresh can be configured directly in Power BI service. For SharePoint On-Premises, ensure the On-premises data gateway is configured and running for scheduled refreshes.

Hope this helps!

[powerbiexpert22]

@Sahir_Maharaj 

there is no Odata connector available in power bi report builder