You can store and manage Power BI reports on premises in the Power BI Report Server web portal, just as you can store Power BI reports in the cloud in the Power BI service (https://powerbi.com). You create and edit reports in Power BI Desktop, and publish them to the web portal. Then report readers in your organization can view them in a browser or in a Power BI mobile app on a mobile device.
If you've already created Power BI reports in Power BI Desktop, then you're ready to create Power BI reports for Power BI Report Server. If not, here are four quick steps to get you started.
You may already have installed Power BI Desktop to create reports for the Power BI service. We recommend installing the version of Power BI Desktop optimized for Power BI Report Server so you know the server and the app are always in sync. You can have both versions of Power BI Desktop on the same computer.
In the Power BI Report Server web portal, select New > Power BI Report.
If you don't have access to a Power BI Report Server web portal, go to the Microsoft Download Center and download Microsoft Power BI Desktop (Optimized for Power BI Report Server - June 2017 GA).
At the end of the installation process, check Start Power BI Desktop now.
It starts automatically and you're ready to go. You can tell you have the right version because "Power BI Desktop (Report Server)" is in the title bar.
If you're not familiar with Power BI Desktop, consider watching the videos on the welcome screen.
In the June release of Power BI Report Server, the only data source supported with Power BI Report Server is a live connection to a SQL Server Analysis Services (SSAS)tabular model or multidimensional cube.
With the August Preview release, you can connect to any data source. Read more about connecting to data sources.
From the welcome screen, select Get Data.
Or on the Home tab, select Get Data.
Select Analysis Services (or, in the August Preview release, select any data source).
Fill in Server, and optionally, Database. Make sure Connect live is selected > OK.
Choose the report server where you'll save your reports.
Here's the fun part: You get to create visuals that illustrate your data.
For example, you could create a funnel chart of customers and group values by yearly income.
Read much more about designing a Power BI report.
When your report is ready, you save it to the Power BI Report Server you chose in Step 2.
On the File menu, select Save as > Power BI Report Server.
Now you can view it in the web portal.
Reports in Power BI Report Server and in the Power BI service (http://powerbi.com) act almost exactly the same, but a few features are different.
Power BI Report Server reports support all visualizations, including:
Power BI Report Server reports don’t support:
Power BI Report Server reports support all the basic functionality in the Power BI mobile apps, including:
Phone report layout: You can optimize a report for the Power BI mobile apps. On your mobile phone, optimized reports have a special icon, , and layout.
Power BI Report Server reports don’t support these features in the Power BI mobile apps:
There are so many great resources for creating reports in Power BI Desktop. These links are a good starting point.
More questions? Try asking the Power BI Community