564 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Getting Started with Power BI Report Server
Part three of a three-part series of blogs
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.
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.
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.
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 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:
Installing a Power BI Report Server would be pointless if you couldn't save reports to it!
If you've saved a report to a report server, you can also open it from that location.
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.
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.
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.
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.
|Parts of this blog|
25 Aytoun Street