Paginated Report URL using MultiSelect Power BI Slicer

[Anonymous]

Hi Community,

I am trying to create dynamic URL for paginated report based on my selections in Power BI report(pbix).

I have multiselect country slicer and now i want generate dynamic URL for paginated report based on my selections in Power BI Country Slicers.

let's say i have selected India and US in country dropdown.

I tried to concatenate my selections using "+" delimiter but still no success. I want the dynamic repetation of parameter and value  pair based on number of multi-select values.

My output should be: PaginatedReportURL?rp:country=India&rp:country=US

Thanks,

Pravin

[Hariharan_R]

Hi

Refer the below post which is relevant to your scenario to handle the multiple values in DAX Measure and frame the URL.

https://community.powerbi.com/t5/Desktop/Paginated-report-with-multi-valued-parameter-not-working/m-...

Thanks

Hari

[Anonymous]

Hi,

Actually in above post he was trying to pass parameters from paginated report to Power BI but in my case i want to do it vice versa that is power bi filters to paramters of paginated report.

Thanks,

Pravin

[Hariharan_R · Accepted solution]

Hi, 

That post is still covering Power BI Desktop to Paginated Report. You need to create a measure to get all the filter value and frame the URL like below.

Things to do in the PBI reoprt

1.Create a measure to export 

Excel Export URL =

VAR __Division =

IF (

NOT ( ISFILTERED ( Sites[Division] ) ),

BLANK (),

"&rp:Division="

& CONCATENATEX ( ALLSELECTED ( Sites[Division] ), Sites[Division] , "&rp:Division=" )

)

VAR __Site =

IF (

NOT ( ISFILTERED ( Sites[Site] ) ),

BLANK (),

"&rp:Site="

& CONCATENATEX ( ALLSELECTED ( Sites[Site] ), Sites[Site], "&rp:Site=" )

)

VAR __baseURL = "https://app.powerbi.com/groups/e29303d3-a2bd-4e1f-b6cb-a85be2cbf72f/rdlreports/5670f37c-f056-4cc5-8c...?" &__Division&__Site

VAR __FinalURL = CONCATENATE(__baseURL, "&rdl:format=EXCELOPENXML")

RETURN

__FinalURL

Thanks

Hari

[Anonymous]

That's Great.

It is working as expected. Now my only concern is , Is there any limitation on URL lenght and if yes, what is the limitation and How to hide Parameter section using URL.

I have tried rdl:parameterPanel=hidden.

Thanks,

Pravin