Forum Discussion
Paginated Report - SharePoint Online Datasource
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
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
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.