cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
MB2018
Regular Visitor

Power BI- URL action to SSRS report

Hi,

 

I have SSRS reports which do not reside on Sharepoint but live on a different server. I want to be able to  have a link from Power BI to SSRS report passing in paramaters which will then be passed into the SSRS report. Can this be achieved?

I have created a text box with a URL but unable to pass paramaters. The values which i would like to pass in the parameters will be the filters selected within the Power BI report.

 

Do you have an example? I have come across examples where you can specifiy the field\table eq value but this is not what i need.

 I am using Power BI Desktop March 2018.

Thank you

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft
Microsoft

Re: Power BI- URL action to SSRS report

If you are using RDL paginated reports you can specify any comibation of report parmeters on the URL. For PBIX desktop reports, currently on the simple eq value approach is supported. A more full featured URL based filtering similar to the PBI service is being considered for a future release of PBIRS. I'd encourage you to up-vote that on power bi user voice forums. 

View solution in original post

1 REPLY 1
Microsoft
Microsoft

Re: Power BI- URL action to SSRS report

If you are using RDL paginated reports you can specify any comibation of report parmeters on the URL. For PBIX desktop reports, currently on the simple eq value approach is supported. A more full featured URL based filtering similar to the PBI service is being considered for a future release of PBIRS. I'd encourage you to up-vote that on power bi user voice forums. 

View solution in original post

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.