BLOGS BY TOPIC▼
BLOGS BY AUTHOR▼
BLOGS BY YEAR▼
Power BI encourages you to publish reports to an online service so that you can share your beautiful reports with the world. If you'd rather keep them a secret you can use Power BI Report Server to deploy your reports to an on-premises server, as this blog series shows you.
Posted by Andrew Gould on 19 March 2019
You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.
Power BI Desktop for Report Server
You may be familiar with creating reports in the Microsoft Power BI Desktop application and then publishing these reports to the online Power BI Service. If you want to save reports to a Power BI Report Server you'll need a different version of Power BI Desktop with the catchy name of Microsoft Power BI Desktop (Optimized for Power BI Report Server)!
You can have both the regular and Report Server versions of Power BI Desktop installed at the same time.
Obtaining the Software
One way to download the application is from the Web Portal. Navigate to the Web Portal as described in the previous part of this blog series and click the download arrow button shown in the diagram below:
Click the download arrow button and choose Power BI Desktop from the menu.
You'll be taken to the download page for the application:
Click the Download button to obtain the software.
Choose the 32-bit or 64-bit edition of the software then click Next.
We're choosing to download the 64-bit edition of the software.
When the file has finished downloading, double-click it to launch the installer:
Double-click the file to launch the installer.
You can then follow the simple wizard to install the software.
Running the Application
When you've finished installing the software you can run it from the Start menu, as shown in the diagram below:
Each version of Power BI Desktop has a distinct icon. The regular Power BI Desktop application has a bright yellow icon with a black graphic. The icon for the Report Server version has the colour scheme inverted.
Run the application by clicking the icon shown above.
Using the Application
Using the Report Server version of Power BI Desktop is almost identical to using the regular version of the application. There are some minor differences, as summarised below:
- You can save a report to a Power BI Report Server.
Installing a Power BI Report Server would be pointless if you couldn't save reports to it!
- You can open reports directly from a Power BI Report Server.
If you've saved a report to a report server, you can also open it from that location.
- You can't use Preview features.
In the regular version of Power BI Desktop you can choose File | Options and settings | Options in order to enable Preview features. These aren't available in the Report Server version of the software.
Saving to a Power BI Report Server
Once you've created a report you can choose to save it to a Power BI Report Server as shown below:
From the menu choose File | Save as | Power BI Report Server
You can then enter the URL of the Web Portal to connect to the Power BI Report Server:
Enter the URL of the Web Portal that you created in the previous part of this blog series.
Click OK then enter a file name and click OK again to save your report:
Enter a file name in the text box and click OK.
Viewing the Saved Report
When you have saved the report to the report server you can choose to view it immediately:
Click the Take me there link to open the Web Portal in your default browser and navigate to the report you have just saved.
From the Web Portal you can return to the home page to view any other content that has been saved to the Power BI Report Server:
Click the Home link at the top of the report to return to the home page of the Web Portal.
Saving Other Content to a Power BI Report Server
Users of SQL Server Reporting Services, SQL Server Report Builder and SQL Server Mobile Report Publisher may be interested to know that you can also publish content created in these applications to the Power BI Report Server. The diagram below shows how to do this in Report Builder:
In Report Builder you can connect to a Power BI Report Server using the Web Service URL and save your reports directly to this server.
In Mobile Report Publisher you can add a connection to the Power BI Report Server using the URL of the Web Portal:
Once you've added a connection to the Power BI Report Server you can choose it when you save a report.
Each type of report you save to the Power BI Report Server occupies a separate section on the Web Portal home page:
Power BI reports and Mobile reports each have an
SSRS reports created in Report Builder or Visual Studio are assigned to the Paginated Reports category.