Microsoft 365 Community Experts from the field, 7 Sep 2023

Previous Meeting Next Meeting

⏯

youtube image

►

From YouTube: No more Report Builder for Power BI Paginated Reports???

Description

Not a fan of Power BI Report Builder? Still want to use Paginated reports? Patrick shows the new Paginated authoring experience within the service! It's BANANAS!

Low code authoring of paginated reports
https://powerbi.microsoft.com/blog/low-code-authoring-of-paginated-reports/

Create paginated reports that you can export in the Power BI service
https://learn.microsoft.com/power-bi/paginated-reports/web-authoring/paginated-formatted-table

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

🎓 Guy in a Cube courses: https://guyinacu.be/courses

*******************
LET'S CONNECT!
*******************

-- http://twitter.com/guyinacube
-- http://twitter.com/awsaxton
-- http://twitter.com/patrickdba
-- http://www.facebook.com/guyinacube
-- https://www.instagram.com/guyinacube/
-- https://guyinacube.com

***Gear***
🛠 Check out my Tools page - https://guyinacube.com/tools/

#PowerBI #Paginated #GuyInACube

A

Yooo!, what's up?, it's patrick from guy in a cube,, and I've been working with paginated reports for many years.

A

What's up, chris finland, cookie mccrave,, my former paginated report pms.?

A

What's going on? hey, paginated report bear. when we were designing paginated reports,, you needed visual studio or you needed power. Bi report builder, and there was some code involved potentially.

A

but now,. But now there's a low code authoring experience.

A

And I wanna show everybody because now it's so easy to get started with paginated reports. so,. You know what I like to do?.

A

Instead of all this talking,, let's do what?, let's head over to my laptop., to get started,, you can go to the onelake data hub.

A

And you can click right, here, and you can choose, create paginated report.

A

or you can go to the workspace where that dataset lives,.

A

And you can go here and click on create paginated, report.

A

Or you click on the dataset itself, and the context menu's table screen will show up and you can choose, create paginated report there, or you can create the dropdown and choose paginated report.

A

Regardless, you'll land in the same place..

A

This is really,, really good experience, and it makes creating paginated report so easy..

A

So the first thing I wanna do is insert me an image.

A

Into this report. and you'll be like, what,, an image? yeah, check this out.. So I just have the url to this image. That's out on the web.

A

Click insert. boom,, there's my image. look at that. and what I'm gonna do is there's a little divider here.

A

If you go to view,, you can actually hide that section divider or hide the margins, right?. I'm gonna keep 'em both 'cause, I wanna make sure I'm within the margins of the page.

A

okay,. So I added my little logo here, and then I'm gonna also insert a text box, and we're gonna call this adventureworks.

A

Annual sales report.

A

and then what we're gonna do is bold it and make it like 22.

A

So we got that, and then we got a little formatting going on. and then I'm gonna take the section header and kind of collapse it a little bit.. So now I have all my real estate to work with.

A

now I can start designing my report. there's a filter section,. So I'm gonna choose the latest year.

A

So I'm gonna drag here to my filter, section 2021.

A

So our report will be filtered by 2021.

A

and then you start designing your report.. So I want month, boom. sales territory,. I want the country, and then I would like to add a few measures.

A

And this is where it gets fun., so I'm gonna go internet sales.. I know I want total sales amount.

A

and I was looking through this list, and this is a data set that adam created, and he forgot to add a total quantity.

A

Of the items that we sold. and I was like,, what am I gonna do? but watch this.? There is an implicit measure, and you can see the summation symbol, here, that I can use..

A

So I'm gonna go ahead and click it. it'll, add it to the canvas.. If I collapse all this and open up bill,, I can actually change how it summarizes..

A

So I want it to sum,, but I can use other different summarizations. If I want.

A

also notice that I can turn the totals.

A

so for any of the implicit or explicit measures,.

A

I can automatically turn totals on and off at a column, level.

A

see, right there. or if I click the table,. What I can do is turn 'em off for every column, on the table.

A

It's pretty nice., I did notice, and I think, there's a little bug here that the formatting of my title changes as I toggle about.

A

So I'm sure the team's aware of that, and they're, probably working on it right now to get it corrected.. What I can also do is, I can resize these columns.

A

So if I just click, look at there., I can get a little real estate back.. I can also rename., so I don't want this to be sales country..

A

I just want that to be country., bring it in a little bit.. Oops, went too far. there we go.. I only want this to be sales amount.

A

and then what we're gonna do is resize that.

A

and also we just want this to be qty..

A

We're gonna bring this on over., just like that,. It works so great.. Maybe I wanna add another measure.. I got it,, I got it.. I don't need your help., so I'm gonna go ahead and add what people did last year.

A

And boom, right? it all fits in the margins.. Maybe I can move this over just a little bit to center it.

A

beautiful., with just a couple of clicks. didn't write. Any code. the most I did was do some very awful adventureworks.

A

Typing on the title., but besides that,, not a lot of code., so once this is done,. If I go back over to my view, tab,.

A

I can switch to web layout,. I can go to print layout,.

A

I can even see the diagnostics of the report.

A

and you can see it took 121 milliseconds to retrieve the data, to count the rows, to process time, to render the report.

A

pretty nice. I can switch to viewing the report. I gotta give it a name before I do. This, right?

A

we're gonna call this annual sales.

A

click, save. yeah,, replace the existing report, and then we'll see what this looks like once it's rendered all on the same page. I can share the report. Now, I can view the report,.

A

I can toggle back over to my editing, view.

A

And then finally,, what I can do is I can export this out.

A

I can export this to pdf, excel. we'll do a quick export to pdf, open it up.

A

I've done it a couple of times. and boom,. There's my report. there's two pages in my report. noticing that my title's not there,, but I'm sure they're working on correcting that.. What do you think?? Have you been using this low code authoring experience?.

A

I'd love to know what challenges you run, into,.

A

What kind of new creative things you're doing with it.?

A

You know what to do. post it in the comments below.. If you wanna know more about paginated reports,, take a look at the playlist, that's flying over my head.

A

and as always, from adam and myself,. Thanks for watching.

A

see you in the next video.