Forum Discussion
Power BI Report Builder Capability
Hi,
At my work, I need to be able to provide pdf or excel export option to the users.
The problem is, I need to provide multiple tables by company names and they need to be in one export.
For example,
Company: A
Table with column 1,2,3,4
Company: B
Table with column 1,2,3,4
Company: C
Table with column 1,2,3,4
and so on..
Can Power BI Report builder provides this service? Company name and column 1,2,3,4 will be all in one Power BI dataset.
Please advise.
Thank you,
2 Replies
By the way, the number of companies is not pre-determined and it depends on the timing of data refresh. I would need to be able to provide X number of tables when there are X number of companies.
Yes, it is possible.
SSRS and paginated reports on PBIRS are same, FYI.
There are FEW WAYS to do it. I guess you are looking as
A list data region with Company ID/Company Name
and nested table with the format you need of the columns 1, 2, 3, 4
Other way is nested table and make certain rows and column have zero borders to get the effect.
Check these to give you an idea
https://sqlserverbi.blog/2010/03/11/nested-tables-in-a-repeating-list-data-region-2/
https://www.tutorialgateway.org/create-a-list-report-in-ssrs/
https://sqlserverbi.blog/2017/04/05/chapter-7-advanced-report-design/
