Forum Discussion
On-Prem vs. Cloud?
Hi, We are just about to embark on our PowerBI journey after doing some preliminary POC demos late last year. Since we already use SSRS quite a bit, one question we are trying to get clarity ...
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!