Wow! Just completely WOW!! The amount of cool things that you showed in this video is going to take me days to digest. And you know if you get praise like that from me, you have done something.
@thomasivarsson24683 жыл бұрын
This is how we did it with Multidimensional and SSRS. Report actions. Great Video!
@AnonymousXMR3 жыл бұрын
Best use of paginated reports and BI
@HachiAdachi3 жыл бұрын
Whoa, somebody put extra caffeine, sugar AND Red Bull in Patrick's coffee this morning!
@trinitxu3 жыл бұрын
This video is awesome. Pls keep posting videos like this with creative solutions to typical client problems!
@noahhadro82133 жыл бұрын
Thanks so much. How do you set parameters when you write your own dax in Report Server. I keep getting an alert saying the parameter isn't declared? Also I would love more videos on paginated reports and using a power bi dataset :). Thanks again
@mann75693 жыл бұрын
Pure wizardry.
@kujtimramadani52493 жыл бұрын
Awesome, Patrick. We are working on something similar for PDF. This was very helpful.
@HarshaVardhan-mx2lk3 жыл бұрын
Superb Video
@atkearns3 жыл бұрын
Love the creative problem solving applied here. Way to go!
@manguyenbaongoc98933 жыл бұрын
thank you so much.. it's very very good to know this one
@bitips3 жыл бұрын
Amazing Patrick ❣️ congrats 👍
@sue_bayes3 жыл бұрын
I can see why you were so excited to show this, was blown away by the simplicity of the user interface to perform some very cool interactions. Looking forward to being able to play with Paginated Reports. Brilliant and thank you for sharing.
@adrianhenning33993 жыл бұрын
Super cool Patrick! I got some feedback from departments in our organization using our Power BI Premium service and they said the following: "I’m not sure how far you have gone with SSRS modernization investigation, but this could be a deal breaker ... I get the following message when uploading a SSRS Drill-Through report: 'Drillthrough feature is not supported'" I could reply to their concerns and give them this video to watch. Thanks a Mill :-)
@Crazy5exycurvy3 жыл бұрын
This is great! I will be using this very soon!
@simonmasters32952 жыл бұрын
Not one of you are asking shall we have a dimension table which is last year's sales, sales to date, next financial year projection..." Such a table can be used to ball park check completeness of data, and refresh partitions when rows get deleted.
@himanshurishi7203 жыл бұрын
Awesome!!
@tienienothnagel32343 жыл бұрын
This is brilliant, thank you very much!!!!
@yannisastaris73 жыл бұрын
Sooo good Thanks Patrick !! PS : I, too, was looking for the same monitor in 49"...just say'in ;-)
@monishrajadurai26513 жыл бұрын
Wow, This was mind blowing, Awesome work Patrick, Keep Going!
@pawewrona97493 жыл бұрын
Thank you, Patrick, amazing. Definitely this will be implemented :)
@kartikwat3 жыл бұрын
This is cool stuff
@filippogiustini26103 жыл бұрын
Amazing! very smart solution to stop all request from those users who want to navigate hundred thousand rows detail, which is both insane and nonsense
@CoHamGuy2 жыл бұрын
thanks Patrick
@mohamadfaizan23162 жыл бұрын
Can we use measurement filter or calculation to make drll through?
@Silverlythia3 жыл бұрын
Wow this is so very very awesome! I didn’t know you could do that with paginates reports! What are the other export options? If there is a link in the details, and I export, will the link stay there?
@Chancelier12697 ай бұрын
Hello. "Product Invoice Details" in the details Navigation check measure. Where is that coming from?
@Bharath_PBI3 жыл бұрын
Yooo, thank you for another cool trick. I'm currently working on Direct query, and as you mentioned table has hundreds of millions of records. And users will be using embed application rather service. Will this still a good choice?
@namanmittal77913 жыл бұрын
Hi Patrick, I tried this , works fine. Now regarding sharing with users, I now have to share two reports to user which is not a good thing..Do you have anything else for this
@williamrodriguez26943 жыл бұрын
It's not a wild card search (paginated) - only searches from the left...
@michellejamison62633 жыл бұрын
Awesome!
@brianross98573 жыл бұрын
Great stuff! Is there capability to extend this to embedded reports for external customers (App Owns Data scenario)? with the web action popping a new window I'm feeling like this will only work for users who have direct access to the PBI Portal.
@clifordakoyo4063 жыл бұрын
what the french toast...good job with the animations
@jaymehta33203 жыл бұрын
Mind blowing!!
@MarekHouska3 жыл бұрын
whau! respect. amazing..
@pravin_02093 жыл бұрын
how to generate URL for paginated report using multi select power BI slicer.
@martinbubenheimer62893 жыл бұрын
Looking forward to the Premium Per User license to have paginated reports available!
@MiguelGarcia-ip1zd Жыл бұрын
Muy buen truco, me gusto.
@1994ramfan3 жыл бұрын
Awesome work! Question outside this video and maybe a cool video is determining when to format in SQL or in Power BI. Example: Formatting Dates, Case Statements, Counts... is it better to do on the SQL/DB side or Power BI side?
@abubakrsaadmakyhoun75353 жыл бұрын
thank you Patrick, great idea and will help us to overcome of one of the most painfull requirements. Kindly can we apply same to power BI on-prime server??
@pabeader19413 жыл бұрын
Some of what he did is dependent on being in the service. But I am going to find a way to apply some of it to my on-prem server reports.
@abubakrsaadmakyhoun75353 жыл бұрын
@@pabeader1941 any good news?
@richagupta46663 жыл бұрын
hi Can you please let me know if "Go to Report" Action works in Paginated Report? If yes, how to do that, when I click on Browse in "Specify a report" I don't see my report which I just published to Power BI Service. How to access that report? I would appreciate help!
@HaiderAli-vt8wn3 жыл бұрын
Hi, is it possible that we return measure name instead of measure value i.e. measures are 18-19=2000, 19-20=2500...I want a new measure that simply reutn measure name istead of value like 18-19 instead of 2000
@udumangdesai74013 жыл бұрын
That was awesome Patrick.. I do have one question though. Can I select more then one invoice from the main selection. If I can then would it create separate pdf for each invoice?
@NovaFan053 жыл бұрын
11:13 Don't hurt yourself there Patrick :)
@ibrahimabdulrahmon48013 жыл бұрын
Hi Patrick, I really appreciate your videos I have learned a lot from them. I have a report in Power BI dataset in the service with RLS configure. I am using this PowerBI dataset in a paginated report. The RLS is not working on the Paginated report. How can I make sure that the RLS filters the data for each user in the Paginated report as well?
@dubbyist3 жыл бұрын
Thank you for a good trick.Is this trick applicable to PowerBI Pro license holder or its only applicable when you have Premium Per User license. Please advise
@santoshraghunath81333 жыл бұрын
Patrick it is ....u r amazing...
@saunakdas0013 жыл бұрын
Hi, can you make a video on how to create a report where we can export more than 150,000, any work around, as the client is insisting on using powerbi to make their company audit data, which is realy very huge.
@indhumathi47273 жыл бұрын
Is it possible to do row level security for paginated reports
@ankitkukreja5923 жыл бұрын
It's bananas 😊
@ingridrodriguez11543 жыл бұрын
Are paginated report still a Premium featyre only?
@leonardomauro78943 жыл бұрын
You are amazing guys. Thanks It is look like bananas after the video. Heheh
@huludShai3 жыл бұрын
First comment! Wohoo. Awesome content as always! Keep it up guys.
@francorg013 жыл бұрын
Thank you for your great videos!! A clarification: what do you mean when you say “keep your power BI datasets separated from PBI models?” Thank you again!!
@ingridrodriguez11543 жыл бұрын
Basically you publish a report with inly the data modelling and then publish another with the visuals so you can have reusable data for multiple reports. He mentions it here kzbin.info/www/bejne/qKS2aHhrqbSnes0
@francorg013 жыл бұрын
@@ingridrodriguez1154 thank you for reply, but that would be separating the datamodel from the report/visuals. He said to separate the dataset from the datamodel and I don’t get it.
@simonmasters32952 жыл бұрын
Patrick be like "I am so cool" when he need be slower like "So this is the problem (diagram|sketch) and how it got solved (keys)"
@mustafabiviji007113 жыл бұрын
Yeah this is interesting, but failed to understand why was the threshold still at 1000 ... it still results in a scroll bar on the Power BI report visual, and you can't automatically have a CSV generated for those items which have less than 1000 invoices. Also wouldn't you want to combine the two buttons so that the end-user can dynamically go to other Power BI report page or paginated report without having to deal with this threshold? Overall this seems like an exciting workaround but i would still categorize as a workaround and not as something I would like to give to a customer (unless you did more magic to make it look more unified).
@pabeader19413 жыл бұрын
He gave them what they asked for. Regardless of what you or I think about it. It's the customer that matters.
@francorg013 жыл бұрын
Actually Patrick said they wanted the 2 buttons because they may need to download the CSV file also for items with less than 1000 invoice lines. Moreover in case of items with more than 1000 invoice lines, considering you cannot click the button, you cannot navigate to the invoice details page and the visual there is never visualized and never populated.
@fatjanpaloja91823 жыл бұрын
With premium isn't it ?
@RodrigoArgumedo3 жыл бұрын
Yes. The paginated reports are assumed any Premium P SKU capacity.