Paginated URL Parameters

[@shankarparimella4109]

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

[@gpozzi.]

Now that PBI released this feature for pro users, this trick is more relevant than ever

[@shriyogisoulfulmusic4194]

Great Video. Is there a way instead of button, we can automate the export to a particular location

[@sambhur6712]

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?

[@cleophusj]

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.

[@olgamango6870]

Export is basic functionality of any bi system. Doing this kind of workournds for simple export is weird..

[@sakshiaggarwal9329]

Did you completely miss out the limitation of the default export functionality that limits the rows to only 150000?

[@neerajpokhrel2588]

A great workaround. Thankyou. i have a question if i use a daterange slider in the slicer will that still work ?

[@mikekostuch4891]

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!

[@GuyInACube]

Love it! It really does help to solve a problem point.

[@douglasbrito2921]

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

[@jeffrey6124]

Have the same scenario now .... hope we could get a response :-)

[@RahulYadav-my9tm]

Thanks for the Video! How we can pass multiple values from the parameter to the dax query?

[@GuyInACube]

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-my9tm]

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.

[@udayboppana3375]

@@RahulYadav-my9tm Did you manage to get round this issue? I am facing the same issue, any pointers are very much appreciated.

[@melissad4620]

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

[@tipums123]

Still having same issue :(

[@kirankumari1985]

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

[@nicolinadicaprio5927]

This solution perfectly solves my case, that's amazing! Thank you so much for sharing :)

[@chalanatyjostna2229]

How do we come back to my power bi report form this page?

[@Anish61097]

If its a dropdown slicer, I cannot copy they dax query from performance analyzer

[@vilenmoodley1390]

Awesome!!. I was wondering can i have url from power bi service to report server on prem? Any guidlines ?

[@Bharath_PBI]

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

[@GuyInACube]

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

[@sushantyadav4809]

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?

[@johngonzalez6071]

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).

[@GuyInACube]

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.

[@tipums123]

Nice Video, Adam. Unfortunately for a parameter if multiple value is selected noting returns. A big flaw..

[@DarkOri3nt]

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 ?

[@PauloSuttiunico]

OMG, this is very USEFULL!! Thanks Adam!

[@ep7391]

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.

[@joshessner4952]

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!

[@piyush5944]

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

[@anselmojg]

This is great! Thanks for sharing this cool solution to overcome the export limits....

[@livings4086]

for paginated reports all end users need to have premium licenses?

[@visheshjjain]

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.

[@marklund7498]

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!

[@marklund7498]

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.

[@dinesh1512]

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?

[@vpwl]

Awesome video! thank you! I always wondered why PowerBiI doesn't support export over 150k rows- what is the limitation?

[@MsNRodrigues]

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?

[@plamendimitrov9097]

Do we need to Enable anything at the tenant for this to work? It is beyond simple , but it is not working for me.

[@blse2000]

You saved my life...Thanks a lot

[@namanmittal7791]

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 ?

[@meganpritchard5792]

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

[@arturkrupa]

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.

[@leslie19611]

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,

[@chipnetics]

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.

[@petyadacheva2822]

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?

[@pabloboswell]

This is general issue with Microsoft expression language. Boolean comparisons can be challenging. I usually have to use 1/0 instead of True/False

[@udayboppana3375]

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.

[@helenhe4591]

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!

[@abigi4me]

This all stuff is awesome. Just loving it ❤️❤️❤️❤️❤️

[@andreashofer8745]

Thank you so much, so cool!

[@ankursingh516]

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?

[@GuyInACube]

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.

[@cybridpunk]

Thanks for this ☺️ Would be much useful.

[@arklur3193]

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.

[@denglishbi]

Smash, mind blown;) Keep being awesome!

[@vanessamogollon2611]

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

[@statisticshelp5225]

It s really awesome, thank you

[@mikekostuch4891]

Love you can publish to the service too directly.

[@GuyInACube]

Yes! it is a nice addition.

[@mathew9665]

is Paginated Reports only for Power BI Premium?

[@GuyInACube]

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.

[@mathew9665]

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

[@GreenTreeFrogO]

Yes, very useful!

[@athiiammu6814]

Do we need a PowerBI Premium Account for this?

[@GuyInACube]

Power BI Paginated reports are a Power BI Premium feature at this time.

[@canasman11]

When is Microsoft releasing this Pro users???

[@kishanbhise4733]

Please don't be in hurry ,it will be great if you explain everything