Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 upload .pbix file in my Report Manager, and everytime I click on the file it downloads - meaning it doesn't render and open as it would in browser.
Is there anything I should do on my existing Report Server to allow it to run PowerBI reports? How can I accomplish this?
Appreciate your help.
Himyar.
Solved! Go to Solution.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
7 | |
4 | |
3 | |
2 |
User | Count |
---|---|
14 | |
11 | |
5 | |
5 | |
2 |