Forum Discussion
On-Prem vs. Cloud?
Hi Rob,
We are trying to link SSRS reports to PBI reports dynamically with parameters as you have mentioned. So far, I have only come across the option of dynamically generating URLs with slicer values to connect to PBI from SSRS, but I am not sure if this is the best way to do it. Would you mind sharing how you did it?
Regards,
Sharmin
Hi Anonymous,
Happy to pass on the technique we use.
Essentially the trick is to use DAX. We create a calculated column in our data model that is a concatenated of the SSRS report URL and the parameters we wish to pass, job number, person ref etc.
We then mark that column as a web link / URL and on the PBI dashboard we include it in the table etc. As its a link when you click on it PBI navigates to the link,and that then opens SSRS report viewer.
if I remember right there is a "Guy In A Box" Youtube video that explains it, probably better than I have.
If you get stuck come back to me and I'll include a bit more detail.
Rob
Anonymous Great, thank you!