Forum Discussion
On-Prem vs. Cloud?
Hi des,
Happy to help, but a little caveat, I am not a MS Licensing expert, so you need to check this with the people you buy your licenses from or Microsoft direct maybe. I'm looking at the SQL Server 2017 Licensing Datasheet ( https://www.microsoft.com/en-gb/sql-server/sql-server-2017-pricing ) as I write this.
My understanding is that if you Buy a SQL server 2016 / 2017 Enterprise License with Software Assurance then you are allowed to download and install the Power BI Report Server on the same server you have the SQL Sever installed. It has to be Enterprise and it has to have SA. This is what we have done, and it works fine. But this is only On-Prem, as I understand it.
To be able to use PBI in the cloud you need a different Cloud based subscription, if you want to have both On-Prem and Cloud I think you best option is to purchase Power BI Premium ( https://powerbi.microsoft.com/en-us/power-bi-premium/ ) this gives you both the On_Prem Report Server and the Cloud Based service.
With regard to the SSRS (or paginated reports as they are referred to now !) yes we have deployed both the PBI and the SSRS reports to the same PBI Report Server. We have actually gone a stage further and managed to dynamically link SSRS reports (with parameters) to PBI reports.
Hope this helps, happy to answer anything else if you need more info.
Kind Regards
Rob
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!