How To Create A Paginated Report In Power BI Service From A Published Data Set

[@EnterpriseDNA]

Check out our FREE courses: bit.ly/3N00AJw

[@Wzxxx]

Can't belive such simple things are achieved in such absolutely not user friendly envirement, 90's design app and idea. 2023 and still such solutions from MS. Unbelivable for me. Zero pleasure to work in such enviroment. Filtering a year with 1000 complicated steps. Unbelivable. By the way - there are filter for paginated report in Power BI service. At the end - thank You, it helped me a lot

[@EnterpriseDNA]

Hi @Wzxxx, we understand your frustration with the user interface and design of Power BI Service. Hopefully this is something that they can improve real soon. Thanks for the tip on the filter for paginated reports.We're glad our content has at least been of help!

[@laionegan]

Very clear and sound voice.I love that accent.thanks

[@EnterpriseDNA]

Hi laionegan, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!

[@houstonvanhoy7767]

Nicely done! The CC interprets "Tablix" as "tablets". Fortunately, you pointed to the Tablix tab once, which cleared up your meaning. ☑

[@EnterpriseDNA]

Hi Houston, unfortunately KZbin's subtitling can get some words incorrectly. But glad that you still appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!

[@sue_bayes]

Glad you enjoyed it

[@b123kotey]

This helped me massively today. Thank you!

[@EnterpriseDNA]

Hi Bartholomew, glad you found this video helpful! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!

[@kassiowifried]

Thank you 😊

[@EnterpriseDNA]

Hi Kassio, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!

[@user-lm5wb8vi1x]

Finished watching

[@EhsanRavana]

THANK YOU VERY MUCH. SO USEFUL

[@Bjoern_9]

Great!

[@EnterpriseDNA]

Hi Bjorn, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!

[@apolinarcamacho5176]

Thank you!

[@simplelearn25]

Thank you

[@Milhouse77BS]

And we can use Filters now also when building in Power BI service, but if edit in Power BI Report Builder, the filters are hard coded into the dataset.

[@EnterpriseDNA]

Hi Donald, that's right! This is an important consideration to keep in mind when deciding which tool to use for building and editing reports.

[@nagarajuyadav2162]

Thanks and maximum how many records we can control per page by using page break and also when we export to excel it shows multiple sheets but I need to show only single page with page break option.

[@user-yc8qx3lf5k]

Nice !!.. How to do the same for Multiple Selection.?

[@user-gg7jb2jo7t]

Hi, thanks for the nice video. I want to create a paginated report with 4 parameters. In that 1st two are date range and 3rd is by product name and 4th is product code. The trick is 1st two parameters are mandatory and (3rd and 4th are optional). This means I have to specify (parameters 1, 2 & 3) OR (parameters 1,2 & 4). Could you please explain how to do it. (Note: I am using a view as DS and not a procedure). - Thanks in advance

[@ahv5457]

Thanks for the video. How can we use a row level security based on the User ID/email in the paginated report? I am using [Email] = Username() for the RLS.

[@EnterpriseDNA]

Hi @ahv5457, It's a bit difficult to assess and give recommendation without looking at the data structure, model and working of the PBIX file for the reference. You can reach out to us on our Community Forum by providing a detailed description of your query along with relevant files for reference. Our members and team of Experts will be happy to help out! If you haven't yet, do subscribe to our KZbin channel and LinkedIn group to keep posted on the latest data skills and tools updates. Cheers, Enterprise DNA forum.enterprisedna.co/ www.youtube.com/@EnterpriseDNA www.linkedin.com/groups/12004506/

[@ahv5457]

@@EnterpriseDNA Thanks for the reply. Sure, will do.

[@Ramvundavalli]

How can we remove all the whitespace towards the right and anywhere else from the report ?

[@alifarooqi279]

How can you dataset to filter on the user only?

[@nissygeorge1029]

Hi, how can I implement row level security in paginated reports?

[@robrayborn1349]

Nice step-by-step to create a paginated report. But the process as a whole seems kind of clunky. Seems like there's opportunity for them to make the process easier.

[@sue_bayes]

I agree, I suspect it will become easier soon.

[@EnterpriseDNA]

Hi Rob, glad that you appreciated our content! Echoing Sue, surely Microsoft will get into making this easier one way or another -- soon hopefully! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!

[@PDPdrums93]

How has no one complained that you can't sort by the quantity?