Hi Adam, Your "Paginated URL Parameters" video helped me a lot for both calling a paginated report from a power bi report itself and also exporting bundles of data in excel application via paginated report. Following you, I have successfully finished the activities given to me in my company. Thanks a lot and keep posting such useful videos for us....!!!!
@olgamango68704 жыл бұрын
Export is basic functionality of any bi system. Doing this kind of workournds for simple export is weird..
@sakshiaggarwal93293 жыл бұрын
Did you completely miss out the limitation of the default export functionality that limits the rows to only 150000?
@mikekostuch48914 жыл бұрын
This is really great option as our options in Power BI are limited on export and Paginated Reports is the proper tool to use for exporting! I am just waiting for AppOwnsData model support for Paginated Reports and I will be using it TONS!!!! This was a huge added feature!
@GuyInACube4 жыл бұрын
Love it! It really does help to solve a problem point.
@johngonzalez60714 жыл бұрын
Thank you for sharing. It's a great tool to have in our back pocket. It is quite a bit of work since you essentially have to make 2 reports, but our organization loves to export and print (2 features Power BI is bad at).
@GuyInACube4 жыл бұрын
Agreed it is a bit of work. It also has the downside of being a little inflexible because if you alter one, you have to alter the other to make it consistent with the data that is being used. For example, if you add a column to one and not the other. But, it is an option.
@gpozzi. Жыл бұрын
Now that PBI released this feature for pro users, this trick is more relevant than ever
@nicolinadicaprio59272 жыл бұрын
This solution perfectly solves my case, that's amazing! Thank you so much for sharing :)
@anselmojg4 жыл бұрын
This is great! Thanks for sharing this cool solution to overcome the export limits....
@joshessner49524 жыл бұрын
Great video. Wish this would have been done months ago as it took me a long time to poke around and figure out how to copy and paste the dax query in. Very useful trick though. Thanks!
@PauloSuttiunico3 жыл бұрын
OMG, this is very USEFULL!! Thanks Adam!
@shriyogisoulfulmusic41943 жыл бұрын
Great Video. Is there a way instead of button, we can automate the export to a particular location
@chipnetics4 ай бұрын
Thanks, pretty good tutorial. But more complex examples with parameter names with spaces, options with spaces (strings instead of numbers), etc are usually better. PBI has weird quirks when dealing with non-simple things like "year" and a number.
@abigi4me4 жыл бұрын
This all stuff is awesome. Just loving it ❤️❤️❤️❤️❤️
@blse20003 жыл бұрын
You saved my life...Thanks a lot
@sambhur67123 жыл бұрын
Is these report can be embedded in the external application ? is this button click to paginated report navigate back to power bi service instead of rendering report in the application itself?
@RyanBetker Жыл бұрын
Yes, very useful!
@douglasbrito29214 жыл бұрын
Hi Adam, awesome video. Is it possible to put all those features on a Embedded PBI Report. I mean use paginated report to end users to export data from a PBI report released in a Embedded website. Thanks
@jeffrey61243 жыл бұрын
Have the same scenario now .... hope we could get a response :-)
@cleophusj4 жыл бұрын
Adam, is there a way to have the PDF download without jumping to another PBI page? I just want the PDF to download when the link is selected. Thanks.
@mikekostuch48914 жыл бұрын
Love you can publish to the service too directly.
@GuyInACube4 жыл бұрын
Yes! it is a nice addition.
@DarkOri3nt4 жыл бұрын
Ok . So I like some of the things you have covered in this video, but it does seem like alot of work for some exportable functionality. Also you have 2 reports to achieve something pretty basic in an original ssrs report with a sql server connection. But I do like the fact the 2 are linked together which in legacy can be a good thing to get the users onto the new format. I would assume you can put a link in the SSRS report back to the power bi tabular report ?
@cybridpunk4 жыл бұрын
Thanks for this ☺️ Would be much useful.
@andreashofer87452 жыл бұрын
Thank you so much, so cool!
@RahulYadav-my9tm4 жыл бұрын
Thanks for the Video! How we can pass multiple values from the parameter to the dax query?
@GuyInACube4 жыл бұрын
just add more parameters to the query string &rp: :) The official blog has an example of that - powerbi.microsoft.com/en-us/blog/url-parameters-for-paginated-reports-are-now-available/
@RahulYadav-my9tm4 жыл бұрын
Thanks for the reply! Yes, I was able to pass multiple values using url parameter. But, paginated report is showing 0 rows. Whereas if we pass 1 filter value it works correctly.
@udayboppana33754 жыл бұрын
@@RahulYadav-my9tm Did you manage to get round this issue? I am facing the same issue, any pointers are very much appreciated.
@melissad46203 жыл бұрын
@Rahul Yadav @Uday Boppana Did either of you get multi value parameters to pass and show the correct rows? I have the exact same issue with the correct values returned for a single value, but 0 rows for a multi value.
@tipums1232 жыл бұрын
Still having same issue :(
@statisticshelp52253 жыл бұрын
It s really awesome, thank you
@vanessamogollon26114 жыл бұрын
Hellow I love your Chanel!!! I'm from Colombia and I really apreciate this videos, please could you show How to do a stacked clouster bar in power bi thank you!!!!
@neerajpokhrel25883 жыл бұрын
A great workaround. Thankyou. i have a question if i use a daterange slider in the slicer will that still work ?
@Bharath_PBI4 жыл бұрын
Yoo guys, thank you for sharing. how can this be done on a power bi report server, any link would be helpful.. can the export row limit be uplifted by using this on pbirs when connected to on-prem SSAS tabular??
@GuyInACube4 жыл бұрын
you can use the same trick with SSRS or Power BI Report Server paginated reports. The URL parameters are a little different though. Here is a reference article for SSRS. PBIRS uses the same. For Paginated reports. - docs.microsoft.com/en-us/sql/reporting-services/url-access-parameter-reference?view=sql-server-2017
@arklur31934 жыл бұрын
07:55 "Sure I could hand type all that DAX" -- But am I gonna? :D Great idea by the way, I saved it for later, this is something we will need eventually, I'm sure.
@tipums1232 жыл бұрын
Nice Video, Adam. Unfortunately for a parameter if multiple value is selected noting returns. A big flaw..
@vpwl3 жыл бұрын
Awesome video! thank you! I always wondered why PowerBiI doesn't support export over 150k rows- what is the limitation?
@kirankumari19854 жыл бұрын
Hi Adam, It is great! Can I get a sample file to download.? Does the dataset has to come from Power BI service for paginated report?
@-DSrikanth Жыл бұрын
If we have more than 2 selected filter how should we concatenate them
@leslie196114 жыл бұрын
I've tried linking to SSRS (it seems we have to call it 'paginated reports' now!) from a Power BI matrix. It is possible using a similar DAX expression to create the url, but the problem is there's no way (I can see) to create hyperlinks in the matrix cells containing the values. The only way seems to be to create a measure containing the url and add this as another column in the matrix. With a single column this isn't too bad, but say if you have a column for each month, you end up with 2 columns for every month, one showing the value and one next to it showing a link icon, what's missing is the ability to apply an action to the cell so you click on the value itself to follow the hyperlink. In other words, Power BI needs the action/go to url functionality that's been in SSRS for as long as I can remember,
@denglishbi4 жыл бұрын
Smash, mind blown;) Keep being awesome!
@vilenmoodley13904 жыл бұрын
Awesome!!. I was wondering can i have url from power bi service to report server on prem? Any guidlines ?
@marklund74984 жыл бұрын
Hi Adam, this is great when the user is selecting one or a few values from a slicer, as we can pass the list of concatenated values in the URL. However if our slicer has 100 values and the user doesn't select any (eg Select All), then the URL fails as there seems to be a limit on the number of values which can be passed. Is there a way to pass a single value which will tick the Select All option in the Paginated Report? We desperately want to offer our users a Excel download icon, which will replicate all of their slicer settings into a fully formatted Excel report, however we can't roll this out until our users have the option of leaving a key slicer as 'Select All'. Thoughts appreciated!
@marklund74984 жыл бұрын
After much investigation and great support from Microsoft, we found the solution and it was dead simple! Set the paginated report up so all parameters are loaded with Default values from the dataset. And then for the URL string passed from the calling Power BI report, only reference a parameter if the user has actually selected a value from a slicer. If the user has selected no values from any slicers (eg Select All), then simply submit the default Paginated Report URL string. If a user has selected a value from a slicer, then modify the URL to include a reference to this parameter and the selected values.
@ep73914 жыл бұрын
Thanks for this amazing video. Can this be done for pbirs on premises? When i click the "Add power bi dataset connection ..." asks for a connection to Microsoft and not to my PBIRS service. Is there any work around? Thanks in advance.
@livings40864 жыл бұрын
for paginated reports all end users need to have premium licenses?
@visheshjjain4 жыл бұрын
The data set needs to be in a workspace backed by premium capacity. So all users don't need a premium license. Here is the URL and information is right above the 'Create reports in Power BI Report Builder': docs.microsoft.com/en-us/power-bi/paginated-reports-report-builder-power-bi Anyone please correct me if I am wrong.
@Mahruumdilse3 жыл бұрын
Hello - This is a very useful video. Thank you. I am trying to do something similar. I followed your steps and have correctly defined in the parameter in "Query Paramters" and have used this parameter in my DAX query as well but I constantly keep getting an error "OLEDB or ODBC error: The query contains the "XXXX" parameter, which is not declared". But I have properly created the parameter. I am really not able to understand what am I doing wrong. Would you be able to help out on how can I go about resolving this issue?
@piyush59444 жыл бұрын
How to configure Parameter for mutiple values in dax when using Power BI Dataset ? It shows 0 Results when more than one value selected in Parameter.Thanks in advance!!
@sushantyadav48093 жыл бұрын
This technique is awesome and crazy work around! but when i connect to PowerBI dataset to paginated report, its has limitation to take 1 million rows only! is that true?
@namanmittal77913 жыл бұрын
Hi Adam, 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 ?
@dinesh15124 жыл бұрын
Hi Adam, Thanks for the workaround. Is there a way to skip the authentication dialog for on-premises SSRS/ PBI Report Server when using the url access? It is again an additional step with this route as well for the users to enter the credentials and get the export from on-premises SSRS/PBI Report Server.
@himanshusachdeva5600 Жыл бұрын
i am facing the same problem, have you got the solution for this?
@meganpritchard57923 жыл бұрын
I can see how this is useful, but needing to set parameters on my PowerBI report URL. I have a report which is project based, and needing to display the data for each project as an embed dashboard in our project system, with a copy of the dashboard as the homepage for each project...
@petyadacheva28224 жыл бұрын
Hey Adam, great video! I used it to implement the same functionality. I have troubles with Boolen parameters though. I trued everything - passing true,false, 0 and 1. Nothing! It completely ignores the value for the boolean parameter, while the rest work perfectly. Any tips and tricks on this one?
@pabloboswell3 жыл бұрын
This is general issue with Microsoft expression language. Boolean comparisons can be challenging. I usually have to use 1/0 instead of True/False
@plamendimitrov90973 жыл бұрын
Do we need to Enable anything at the tenant for this to work? It is beyond simple , but it is not working for me.
@arturkrupa4 жыл бұрын
Hi Adam, this is awesome video, thank you for that! Can I take a chance and ask one question related to Power BI Paginated reports URL? I have this scenario: I'm publishing a paginated report to PBI service. In that paginated report I have a button/textbox with "Go to URL" action calling another paginated report in the same PBI workspace. It's passing the report parameters and everything is working like a charm in PBI service. I even created a new experience app on top of that workspace and the link is working fine. But when I run this report on my mobile device via the Power BI app, the URL link does not open the target report. Do you know any way to work around this? Thanks in advance, Artur.
@udayboppana33754 жыл бұрын
I tried Passing multi valued parameter i.e. lets say Year is a parameter and I want to pass 2014 and 2015, the paginated report doesn't understand, and can we pass null value? i.e. if I don't select anything it should automatically select all the values and it is also not working for me.
@helenhe45913 жыл бұрын
Hello Have you figured out how to pass Multi-value parameters? I tried for a long while, it did not work. Can someone please share their experience? Thanks!
@ankursingh5164 жыл бұрын
Hi Adam and all the developers out there...Hope you are doing good...I came across this error when clicking on the Query Designer button -- > Syntax error : Missing operand after 's' operator. Has any of you came across this issue or has any idea how to solve this?
@GuyInACube4 жыл бұрын
Not enough details on that. can you check the query syntax? maybe there is an underlying syntax error? May need to open a support ticket.
@athiiammu68144 жыл бұрын
Do we need a PowerBI Premium Account for this?
@GuyInACube4 жыл бұрын
Power BI Paginated reports are a Power BI Premium feature at this time.
@mathew96654 жыл бұрын
is Paginated Reports only for Power BI Premium?
@GuyInACube4 жыл бұрын
No. You can also have Paginated reports within SQL Server Reporting Services or Power BI Report Server. The URL parameters for SSRS and PBIRS are a little different though. But the approach works.
@mathew96654 жыл бұрын
@@GuyInACube we already have Power BI Pro - I tried finding the cost for Power BI Report Server and is talks about it being part of Power BI Premium - is there a cost for having Power BI Report Server, or is this free? (powerbi.microsoft.com/en-us/report-server/)
@canasman114 жыл бұрын
When is Microsoft releasing this Pro users???
@kishanbhise47332 жыл бұрын
Please don't be in hurry ,it will be great if you explain everything