Forum Discussion
Report like SSRS
I want to create a report in BI similar to an SSRS report with the columns across the top and be able to group by a column or two.
What is the best way to do that in BI would anyone know?
Thanks.
You have to utilize Report Builder to create your pagination. Power BI Report Builder - Power BI | Microsoft Learn
6 Replies
Hello! Pagination in Power BI (which can be done with Report Builder) is similar to SSRS. What are paginated reports in Power BI? - Power BI | Microsoft Learn and Pagination in Power BI paginated reports - Power BI | Microsoft Learn
Can you do these in Power BI Desktop by just adding a Paginated report or does this need to be done using ReportBuilder?
There is a Paginated Report visual in Power BI that you can use: Create and use the paginated report visual - Power BI | Microsoft Learn
However, this renders pagination in desktop - the building of the pagination still happens in Report Builder. That being said, the model you build in Power BI desktop is the same model you will use for report builder - no need to create a new one.
Hi PowerBrowse ,
As audreygerred said, you can't create paged reports in power bi desktop, you can create paged reports with Report Builder and use paged reports visualization in power bi desktop.
Best regards,
Albert He
