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?

@adnanebekkaoui9480

5 ай бұрын

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

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!

Great content Guy in a cube. Always enjoy and learn something new from all of your teams videos. Keep it up. Cheers !!

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.

@abhayrajsinghbisht9999

9 ай бұрын

Correct ...

Thanks for video Guy. I’m going to try this out because people still like paper some time. SSRS 😂I miss you 😢

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

Thank you Patric, Are we going to have the ability to send each User their relevant Paginated Report? As in SSRS?

"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!

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.

Thanks for this useful vid. Question. How would I do page split by different geography or by another dimension? Is that an option?

Nice. Can you still use the Report Builder to edit? What about grouping?

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 !

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?

@KO-cp9ws

10 ай бұрын

Doesn't Visual studio already have that capability?

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.

@thesunnynight

10 ай бұрын

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

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

@SM23Studio

4 ай бұрын

you can - just switch off stepped layout - and you can even turn on/off row subtotals if you want

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,

Wow it's like Business Objects :D

Is there a way to sort the columns when sent out to stakeholders?

How can I add text box repetitively in report body on each every page. I tried properties like report eith....

Does it work with Power BI Report Server (the on-prem version of Power BI)?

WITHOUT PARAMETERS, THIS OPTION IS NOTHING

@venupedduri6989

10 ай бұрын

Yes..i think we cannot use parameters or slicers right??

@dhruvishah790

7 ай бұрын

We still have to use Report Builder for Parameters right?

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?

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.

@thesunnynight

10 ай бұрын

You can do that in report builder

What if i want the user to filter the data for any date range? huh

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?

Unless there is full capabilities of web authoring available with it similar to Cognos/SSRS, it's not useful for building pixel perfect reports.

Where parameters?

can you set a schedule to send it via email? also attached it to said email as excel...

@docilerambo

9 ай бұрын

yes, once you save the report you can create subscriptions to get email as excel attachments

@user-rn2by7wj8i

9 ай бұрын

Yes. When you are "Viewing" a report you have the option to "Subscribe to report" and attach to email.

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.

@martasanpedrogainza7140

10 ай бұрын

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

@zygfrodo

10 ай бұрын

@@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

Can you make Parent Groups, Child Groups, etc? What about a Matrix?

So they basically changed the engine to use the Power BI engine instead of SSRS

@docilerambo

9 ай бұрын

No, it shares the same underlying engine that powers SSRS RDL reports.

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!

Maybe we can get rid of BusinessObjects

can ms make it available for the pro license, this shouldn't be a premium feature its 2023

@docilerambo

9 ай бұрын

Paginated Reports are available for pro for more than 6 months now.

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

Paginated Report builder is terrible unless you use tabular model. It's a mess honestly. Very difficult to use.

Why use PBI to Crete a data table if Excel does it much better?

@perfectionist6624

8 ай бұрын

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.

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’

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