Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Paginated Report URL using MultiSelect Power BI Slicer

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...
multi select parameter
Paginated Report
Paginated URL
  • Hariharan_R's avatar
    Hariharan_R
    5 years ago

    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 __FinalURL = CONCATENATE(__baseURL, "&rdl:format=EXCELOPENXML")

    RETURN
    __FinalURL
     
    Thanks
    Hari
Anonymous's avatar
Anonymous
Not applicable
5 years ago

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's avatar
Hariharan_R
Solution Sage
5 years ago

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 __FinalURL = CONCATENATE(__baseURL, "&rdl:format=EXCELOPENXML")

RETURN
__FinalURL
 
Thanks
Hari
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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