Forum Discussion

aljabrha's avatar
aljabrha
New Member
6 years ago
Solved

Running PBIX Reports on SSRS

I already have an existing SSRS (on-premise). I want to use the same SSRS to host and render PowerBI reports.    According to Publish Power BI reports on-premises that this is possible. I tried to ...
Running PBIX Reports on SSRS
  • stretcharm's avatar
    stretcharm
    6 years ago

    You need to install PBI Report Server which is SQL2017 SSRS with powerbi features.

    https://powerbi.microsoft.com/en-us/report-server/

    If you have enterprise with support then your licenced Just need a pro user account for the uploader.

     

    Also you need to save your pbix from the desktop version that matches your server. Download from the sample place as the server

    Then you either publish from that desktop version or upload from the PBI SSRS.

     

    Not all features work on PBI RS but I found it to be pretty good.

     

    You can run all existing RS reports from the PBI SSRS or have the 2 running side by side on the same box with different instance names.

     

    I tested side by side then transitioned to a single RS.

stretcharm's avatar
stretcharm
Icon for Memorable Member rankMemorable Member
6 years ago

You need to install PBI Report Server which is SQL2017 SSRS with powerbi features.

https://powerbi.microsoft.com/en-us/report-server/

If you have enterprise with support then your licenced Just need a pro user account for the uploader.

 

Also you need to save your pbix from the desktop version that matches your server. Download from the sample place as the server

Then you either publish from that desktop version or upload from the PBI SSRS.

 

Not all features work on PBI RS but I found it to be pretty good.

 

You can run all existing RS reports from the PBI SSRS or have the 2 running side by side on the same box with different instance names.

 

I tested side by side then transitioned to a single RS.