cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

How to pass Power BI slicer value to SSRS 2016 Paginated Reports

Hello,

 I have a requirement to pass the Power BI slicer value to SSRS 2016 Paginated Report link dynamically. Is there any possibilty way to do that approach? The Power BI report is connected through SSAS Live Cube. 

 

Ex:

I have transaction date and Status (Open/Closed) in the Power BI report slicer. I need to pass the transcation date and status dynamically based on the user selection to the SSRS Report link.

 

Tried the below URLpassing URL Filter. It didn't help me out.

https://docs.microsoft.com/en-us/power-bi/service-url-filters

 

 

5 REPLIES 5
Highlighted
Microsoft
Microsoft

Re: How to pass Power BI slicer value to SSRS 2016 Paginated Reports

Not sure exactly what you're trying to achieve, but If you want to go from a powerBI report into a paginated RDL report:

 

In PBI report you can genearate a hyperlink, potentially using a slicer to filter the values in a table:

 

https://docs.microsoft.com/en-us/power-bi/power-bi-hyperlinks-in-tables

 

Then, define your URLs in the PBI report to link to a paginaged report under http://[servername]/reportserver/[path]/[reportname]?[parameters].

 

If you want to go the other way (RDL into PBI) then create a URL action on a textbox in your RDL, generate the URL of the PBI report and if you are using PBIRS October you can pass filters on the URL as described in the link you included.

 

-jon

 

 

 

Highlighted
Helper I
Helper I

Re: How to pass Power BI slicer value to SSRS 2016 Paginated Reports

Thanks for your reply Jon-Heide. I am trying to pass the slicer value dynamically based on user selection from Power BI to SSRS report through URL.

Is there anway that i could store the Power BI slicer value when user select the slicer?

Highlighted
New Member

Re: How to pass Power BI slicer value to SSRS 2016 Paginated Reports

Can anyone provide latest updates to this request

Highlighted
Advocate III
Advocate III

Re: How to pass Power BI slicer value to SSRS 2016 Paginated Reports

Is there any update on this. I am looking for the soultion.

Appreciate any help.

 

Thanks,

soumya

Highlighted
Helper I
Helper I

Re: How to pass Power BI slicer value to SSRS 2016 Paginated Reports

If you want to pass parameters dynamically you can use DAX for achieving this.

 

E.g. 

Link =
VAR FirstSlicer = SELECTEDVALUE( 'Table'[Column] )
VAR SecondSlicer = SELECTEDVALUE( 'Table2'[Column2] )
VAR URL = "powerbiserviceurl?"

RETURN
URL & "rp:Column=" & FirstSlicer & "&rp:Column2=" & SecondSlicer

 

The full description you can find here: https://sqlserverbi.blog/2019/07/04/drillthrough-from-power-bi-to-an-ssrs-paginated-report/

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors