Paginated Report - SharePoint Online Datasource

[BM4291]

Hi,

Following some issues with a SharePoint Online list growing beyond 5k items I'm looking at different ways of delivering a report to end users; at the moment they have a custom UI that has been developed within an app whereby they select a report, filter it with parameters and the system can export an Excel file. This is all handled through JavaScript and REST.

Certain views of this report can no longer be queried as they break the 5k limit; short of coding in a solution to filter an array of all results (as select all is unaffected by the limit) I was thinking about creating a pagniated report that used SharePoint Online as a datasource, however it's my understanding that this isn't possible... Has anyone else had experience with using SharePoint Online and paginated reports? I can't connect using SSRS 2012 and recently had SSRS 2017 removed so can't see whether it's an option.

I could just set up an ordinary PowerBI report for this data however, a significant amount of it is shared with external parties and we do not currently have Azure B2B configured. The external users would need to see a list of entries for a period.

Any thoughts?

[v-piga-msft · Accepted solution]

Hi @BM4291,

I'm a little confused about your scenario.

It seems that you used to use SSRS create the report and you now you want to use Power BI to create the report similar to the report created in SSRS?

---

Following some issues with a SharePoint Online list growing beyond 5k items I'm looking at different ways of delivering a report to end users; at the moment they have a custom UI that has been developed within an app whereby they select a report, filter it with parameters and the system can export an Excel file. This is all handled through JavaScript and REST.

For the option you mentioned, " whereby they select a report, filter it with parameters and the system can export an Excel file", I think that is not supported in Power BI. In Power BI, we always use slicer to filter the data.

I was thinking about creating a pagniated report that used SharePoint Online as a datasource, however it's my understanding that this isn't possible... Has anyone else had experience with using SharePoint Online and paginated reports? I can't connect using SSRS 2012 and recently had SSRS 2017 removed so can't see whether it's an option.

In addition, I'm a little confused about your pagniated report, if you mean a long report is divided into many pages, I'm afraid that cannot be achieved in Power BI currently. Power BI Report Server could create pagniated report, but it cannot use SharePoint Online Source.

Finally, for your scenairo, you'd better post in Power BI Developer where you could get more professional help.

Best  Regards,

Cherry

[BM4291]

Hi @v-piga-msft,

You've answered my question!

'Power BI Report Server could create pagniated report, but it cannot use SharePoint Online Source.'

What I was asking was can I create a paginated report using SharePoint Online as a datasource; seems to be something distinctly missing. I was going to use a paginated report in the same way that you would a traditional report server report to replace the custom report I currently produce.