The one thing I’ve always waited on for SSRS and power bi reports is a css/style library, so we could pre-define our corporate styles and then apply them to our reports. That would be a game changer for reporting.
With the complicated things we build (full financial statements, operational dashboards) I still have to use Report Builder. (Tablixes, advanced groups etc.). Do you ever build those types of projects, Patrick?
It still is missing a lot of basic features I would need to find it useful. That said, I can see the vision with it and it could be a game changer down the road for everyday business users.
Patrick, I really like your mantra. Not Lazy, just very efficient! Bam. I started using it with my team at work. And, I tend to forward your vids to others. I want us all to stay sharp and grow together. Happ Sat, dude
The problem that this report when embedding it in another Power BI report is that it does not interact with the rest of the visual objects, nor does it even create field parameters for filtering. These low-code paginated reports are still missing a lot.
Sorry I didn't see this sooner. It is SO MUCH BETTER than slogging through that desktop interface for paginated reports. Guy in a Cube, you reduced my learning curve significantly!
Actually discovered this by accident today and managed to create a quick report in seconds. Struggled at first to get into Landscape from the default Portrait mode. Nice addition. Also, if you right click on any the available items from the query, you can choose to make them parameters on the report!
Hi Patrick, I love your videos! Would you create a video about how to run paginated report from inside power bi - with optional parameters, multi select parameters and with shared datasets as data source (so Dax is used to build queries, not SQL like in most tutorials). Ideally, the users should pass power bi slicer values to parameters, while paginated report parameters stay hidden. Ty
I have a challenging question! Is it possible to perform dynamic operations between columns where column came from different table and the table is on different filters. To be more specific, the table content is exactly the same in the beginning. What makes them different is the filters (manually click). These two tables can joined together and perform operations between columns but i want the operations to be dynamic like it's subject to change when i play with the slicers.
It is great feature, what I am missing in Power BI is the option to use multiple columns in Matrix visual (not in hierarchical way). Hope Microsoft thinks about it
Do you think it will be possible to create non-tabular paginated reports soon (like in SSRS or ReportBuilder) for things like invoices, contracts, salary pay-slips, etc? Thanks for the video, it was great !
Once you create and save/publish a Paginated Report in the Web UI, the "Editing" button disappears. After closing the report, you must use the desktop "Report Builder" client, which lacks many features originally available in the Web UI. Personally, I often need to make multiple adjustments after creating a report. Limiting access to advanced formatting, data modeling, and other features only until the report is closed is quite inefficient and short-sighted on Microsoft's part.
Cool. Report Builder for PBI was the entry level SSRS Report Builder with PBI publishing plugins. This is a webtools version for business analysts to play with and pretend they understand their data. So when will developers get support for paginated reports in a reporting development app like PBI desktop or Visual Studio?
This is what I've been waiting for, But there is a bigger question, When will the Paginated Reports support dynamic images? :D Because reporting requires many images, not only the numbers.
Hi Patrick, When I created the email subscription of the paginated report that was created in the workspace; it kept the source table name on the column header. How to get that corrected. I don't need to show the entire table name on my column headers. When I view the report, it doesn't show that but when I received on email, it has the long name on column headers. Thank you,
Is that possible to create charts in paginated reports? I can see it is not possible doing that on Power BI Online. But Can I do this on Report Builder?
Hello Patrick, We used to work with SQL Server reporting services on premises, we have developed more than a hundred paginated reports we want to evolve towards an Azure version. Which is the simplest way to achieve this goal. We hope to access with an Azure active directory account and above all the possibility of migrating or directly injecting our paginated reports in Power bi service in Azure is this possible?
Q: Our users want to slice and dice information in report and dump that data into a CSV which is then used as input for a new business process. They are not just looking for insights - they want to do something about it. The 150K rows limitation is a problem for that. What’s more our reports are in DirectQuery mode because we can’t replicate / ingest billions of rows into a PBI datasets - I’m sure we’re not alone here with this need - helo!
Let me ask a different question - Why would I want to create a paginated report if I'm not printing it out? For most if not almost all cases, a Matrix, even a complex one, is enough.
We use paginated reports to let the users export data (Mateix and tables PowerBI visuals have limited the number of rows that can export), while paginated reporta don't have that limitation - the limit would be the Excel maximim rows if they export to Excel, or no limot if they export to csv
@@martasanpedrogainza7140 ok, makes total sense. Actualy you got me thinking that I might come across this limitation in my upcoming project so i'll have to use the paginated report. Thanks a mil.
I still think that report builder will stay until they migrate the pixel-perfect properties Pane online for the many demanding customers who are very picky on presentation and also publish the reports in a governed way. I want version control for paginated reports like the power bi desktop has now
It has been seven months since this video has been published. I found this feature a bit amusing due to its lack of features. I’m not gonna start listing what is missing. I can simply tell you that pretty much all of it is missing and since the seven months of the publication of this video, no new features have been added to this. Just sayin’
Its too basic and trivial. Original designer supports much more complex layouts including multiple sessions, grouping and layers. Also you have 100% control of report interactions based on lots os properties.. service doesn't support professional design
I really like all the features of Power BI. But holy crap the licensing - what a freaking mess. I don't want to develop anything in power bi for fear of making something that requires a lever we are not paying for. Great tool, but wow, who is in charge of the licensing mess at MS.
The right hand doesn't know what the left hand is doing. This was available for at least 4 months, maybe longer. Pretty late for a dedicated PBI channel. The tool itself is primitive. Almost useless. Only the simplest use cases can be solved by this. IMHO failing to mention its limitations do not add to credibility of this channel.
![Lp. Сердце Вселенной #60 РОЖДЕНИЕ ЛОЛОЛОШКИ [Финал] • Майнкрафт](http://i.ytimg.com/vi/YoR0pAV9FVQ/mqdefault.jpg)
The one thing I’ve always waited on for SSRS and power bi reports is a css/style library, so we could pre-define our corporate styles and then apply them to our reports. That would be a game changer for reporting.
With the complicated things we build (full financial statements, operational dashboards) I still have to use Report Builder. (Tablixes, advanced groups etc.). Do you ever build those types of projects, Patrick?
I would be interested also, Power BI report builder is still on game, this video is a use case for simple flat tables.
It still is missing a lot of basic features I would need to find it useful. That said, I can see the vision with it and it could be a game changer down the road for everyday business users.
Patrick, I really like your mantra. Not Lazy, just very efficient! Bam. I started using it with my team at work. And, I tend to forward your vids to others. I want us all to stay sharp and grow together.
Happ Sat, dude
The problem that this report when embedding it in another Power BI report is that it does not interact with the rest of the visual objects, nor does it even create field parameters for filtering. These low-code paginated reports are still missing a lot.
Correct ...
I believe you can create parameters from the fields in this low code builder. I managed to do so today. It could be a newly added thing.
"Q:" Why only a table is available in the visuals option? Why not make it available for more options like Card visual or Matrix? Thx!
Sorry I didn't see this sooner. It is SO MUCH BETTER than slogging through that desktop interface for paginated reports. Guy in a Cube, you reduced my learning curve significantly!
Actually discovered this by accident today and managed to create a quick report in seconds. Struggled at first to get into Landscape from the default Portrait mode. Nice addition.
Also, if you right click on any the available items from the query, you can choose to make them parameters on the report!
Hi Patrick, I love your videos! Would you create a video about how to run paginated report from inside power bi - with optional parameters, multi select parameters and with shared datasets as data source (so Dax is used to build queries, not SQL like in most tutorials). Ideally, the users should pass power bi slicer values to parameters, while paginated report parameters stay hidden. Ty
I have a challenging question! Is it possible to perform dynamic operations between columns where column came from different table and the table is on different filters. To be more specific, the table content is exactly the same in the beginning. What makes them different is the filters (manually click). These two tables can joined together and perform operations between columns but i want the operations to be dynamic like it's subject to change when i play with the slicers.
Thank you Patric,
Are we going to have the ability to send each User their relevant Paginated Report? As in SSRS?
Nice. Can you still use the Report Builder to edit? What about grouping?
It is great feature, what I am missing in Power BI is the option to use multiple columns in Matrix visual (not in hierarchical way). Hope Microsoft thinks about it
you can - just switch off stepped layout - and you can even turn on/off row subtotals if you want
Do you think it will be possible to create non-tabular paginated reports soon (like in SSRS or ReportBuilder) for things like invoices, contracts, salary pay-slips, etc? Thanks for the video, it was great !
Once you create and save/publish a Paginated Report in the Web UI, the "Editing" button disappears. After closing the report, you must use the desktop "Report Builder" client, which lacks many features originally available in the Web UI. Personally, I often need to make multiple adjustments after creating a report. Limiting access to advanced formatting, data modeling, and other features only until the report is closed is quite inefficient and short-sighted on Microsoft's part.
Cool. Report Builder for PBI was the entry level SSRS Report Builder with PBI publishing plugins. This is a webtools version for business analysts to play with and pretend they understand their data. So when will developers get support for paginated reports in a reporting development app like PBI desktop or Visual Studio?
Doesn't Visual studio already have that capability?
So you can’t have dynamic filters like ssrs?
Thanks for this useful vid. Question. How would I do page split by different geography or by another dimension? Is that an option?
This is what I've been waiting for,
But there is a bigger question, When will the Paginated Reports support dynamic images? :D
Because reporting requires many images, not only the numbers.
But report builder already support URL as image - if It Is what you mean. I've built up a report including the picture of every item
Great content Guy in a cube. Always enjoy and learn something new from all of your teams videos. Keep it up. Cheers !!
Hi Patrick, When I created the email subscription of the paginated report that was created in the workspace; it kept the source table name on the column header. How to get that corrected. I don't need to show the entire table name on my column headers. When I view the report, it doesn't show that but when I received on email, it has the long name on column headers. Thank you,
Is there a way to sort the columns when sent out to stakeholders?
Thanks for video Guy.
I’m going to try this out because people still like paper some time.
SSRS 😂I miss you 😢
How can I add text box repetitively in report body on each every page.
I tried properties like report eith....
WITHOUT PARAMETERS, THIS OPTION IS NOTHING
Yes..i think we cannot use parameters or slicers right??
We still have to use Report Builder for Parameters right?
What if i want the user to filter the data for any date range? huh
Does it work with Power BI Report Server (the on-prem version of Power BI)?
Is that possible to create charts in paginated reports? I can see it is not possible doing that on Power BI Online. But Can I do this on Report Builder?
Hello Patrick, We used to work with SQL Server reporting services on premises, we have developed more than a hundred paginated reports we want to evolve towards an Azure version. Which is the simplest way to achieve this goal. We hope to access with an Azure active directory account and above all the possibility of migrating or directly injecting our paginated reports in Power bi service in Azure is this possible?
Where parameters?
If only I could mark a field as Image URL as in Power BI, and have it show the Image instead of the URL. Then I'd be pretty happy.
You can do that in report builder
Paginated Report builder is terrible unless you use tabular model. It's a mess honestly. Very difficult to use.
Q: Our users want to slice and dice information in report and dump that data into a CSV which is then used as input for a new business process. They are not just looking for insights - they want to do something about it. The 150K rows limitation is a problem for that. What’s more our reports are in DirectQuery mode because we can’t replicate / ingest billions of rows into a PBI datasets - I’m sure we’re not alone here with this need - helo!
Biggest limitations i see here when we add calculated column it wont allows to download the report in excel
Let me ask a different question - Why would I want to create a paginated report if I'm not printing it out?
For most if not almost all cases, a Matrix, even a complex one, is enough.
We use paginated reports to let the users export data (Mateix and tables PowerBI visuals have limited the number of rows that can export), while paginated reporta don't have that limitation - the limit would be the Excel maximim rows if they export to Excel, or no limot if they export to csv
@@martasanpedrogainza7140 ok, makes total sense. Actualy you got me thinking that I might come across this limitation in my upcoming project so i'll have to use the paginated report.
Thanks a mil.
can you set a schedule to send it via email? also attached it to said email as excel...
yes, once you save the report you can create subscriptions to get email as excel attachments
Yes. When you are "Viewing" a report you have the option to "Subscribe to report" and attach to email.
Not able to do parameters…
Unless there is full capabilities of web authoring available with it similar to Cognos/SSRS, it's not useful for building pixel perfect reports.
Can you make Parent Groups, Child Groups, etc? What about a Matrix?
I still think that report builder will stay until they migrate the pixel-perfect properties Pane online for the many demanding customers who are very picky on presentation and also publish the reports in a governed way. I want version control for paginated reports like the power bi desktop has now
Wow it's like Business Objects :D
So they basically changed the engine to use the Power BI engine instead of SSRS
No, it shares the same underlying engine that powers SSRS RDL reports.
It has been seven months since this video has been published. I found this feature a bit amusing due to its lack of features. I’m not gonna start listing what is missing. I can simply tell you that pretty much all of it is missing and since the seven months of the publication of this video, no new features have been added to this. Just sayin’
Its too basic and trivial. Original designer supports much more complex layouts including multiple sessions, grouping and layers. Also you have 100% control of report interactions based on lots os properties.. service doesn't support professional design
can ms make it available for the pro license, this shouldn't be a premium feature its 2023
Paginated Reports are available for pro for more than 6 months now.
Maybe we can get rid of BusinessObjects
Why use PBI to Crete a data table if Excel does it much better?
Excel has so many limitations
I really like all the features of Power BI. But holy crap the licensing - what a freaking mess. I don't want to develop anything in power bi for fear of making something that requires a lever we are not paying for. Great tool, but wow, who is in charge of the licensing mess at MS.
The right hand doesn't know what the left hand is doing. This was available for at least 4 months, maybe longer. Pretty late for a dedicated PBI channel. The tool itself is primitive. Almost useless. Only the simplest use cases can be solved by this. IMHO failing to mention its limitations do not add to credibility of this channel.
Parameters Parameters Parameters 🫣 wish they are available soon