Forum Discussion
Parameters to SQL Server Reporting Services throw Power BI
Hi there,
I would need to pass a parameter that is set in Power BI to my SQL Server Reporting Services. I would like to open the link of the report from SSRS filtered by the register that I have chosen on Power BI but I have not been able to do it. Manually, I would have to be able to filter the Report from SSRS using the URL adding "?rs:Embed=true&filter=..."
Thanks in advance
Hi maserr ,
Have you tried to create a measure that combining the url and the filter as a hyperlink to jump to the SSRS?
For example, we select a value in Column "Category" called A, and we have a measure using following dax:
Link = "https://XXXXXX?rs:Embed=true&filter=Category eq" & SelectedValue(‘Table'[Category)
Then we can set this measure as an action of button.
Best regards,
2 Replies
Hi maserr ,
Have you tried to create a measure that combining the url and the filter as a hyperlink to jump to the SSRS?
For example, we select a value in Column "Category" called A, and we have a measure using following dax:
Link = "https://XXXXXX?rs:Embed=true&filter=Category eq" & SelectedValue(‘Table'[Category)
Then we can set this measure as an action of button.
Best regards,
