paginated report using sharepoint

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 | Microsoft Learn

 

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.

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!