cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
dimitrishuk
Helper I
Helper I

Power BI Report Server and Power BI Desktop publishing problem

Hi. I'm testing out SQL Server 2017, SSRS 2017 (Version 14.0.600.594 October 2017), Tabular (1400), Power BI Report Server (March 2018) and associated Power BI Desktop RS. All have been installed with Developer edition license.

 

I have my db, tabular models working fine and loading in analysis services. SSRS Loads as expected (http site) and installed the Power BI report server in developer edition. Strange thing is I dont see an option to download Power BI desktop on the SSRS site. It still looks as it did before. Also when I try to 'Save As' from Power BI Desktop RS (March 2018) I get 'We couldnt find a Power BI report server at this address". Power BI Report Server service is running fine and have restarted the machine to make sure it was a post install issue.

 

If I upload the pbix file from SSRS 2017 (http://sqlserver.mydomain.com/reports), it uploads, but when I click the file it just downloads the pbix file rather than opening in the browser as expected.

 

I dont have a Power BI Premium license, SQL Server Enterprise + SA, or Power BI Pro service, as this is not a production environment, rather for proof of concept.

 

Am I missing something? Have I set it up wrong? Is it a licensing issue? Help! I've got so far this is really the last step to getting buy-in for further development and eventually production!

 

1 REPLY 1
Jon-Heide
Microsoft
Microsoft

Sql Server Reporting Services does not support viewing of PowerBI reports, only storage. You need to use Power BI Report Server available at: https://powerbi.microsoft.com/en-us/report-server/. You can use the evaluation or developer editions of PBI Report Server to try it out. Note that if you install both SSRS and PBIRS on same machine, you need to ensure the URL's and databases are all configured separately. I'd reccomend only installing PBIRS to make it easy as it has everything SSRS has + PowerBI. 

 

 

 

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.