557 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
What Power BI report server is, and how to create reports through it
Part four of a five-part series of blogs
Puzzled as to why there are two near-identical versions of Power BI Desktop? Wondering if web portal is anything like Power BI report server? Confused as to what a paginated report is? This blog answers all these questions, and more!
To create a report for publication on Power BI Report Server, you must use Power BI for Report Server!
Power BI for Report Server is pretty much identical to Power BI Desktop, and you can run both applications side-by-side on your computer. The main difference is that Power BI for Report Server is more stable: it doesn't include any preview features, and updates are only released about once a quarter (as opposed to once a month for standard Power BI Desktop).
Follow the steps below to create a Power BI report for viewing in Power BI Report Server.
You start to add a Power BI report in the same way as adding a paginated report:
Choose this option to create a new Power BI report.
I've got Power BI on my laptop, but it's not the version for Report Server, so I've chosen to download the Report Server version:
Click on the button to download Power BI for Report Server.
You'll be taken to a website, where you can download the right version of Power BI Server:
Click to download the software (at the time of writing this is the May 2020 edition, which is 7 months behind the standard version of Power BI Desktop).
Choose whether you have a 32-bit or 64-bit computer:
I've got a 64-bit laptop, as (almost certainly) will you - why can't it detect this though?
When the installation program has downloaded, choose to run it:
What this looks like in Edge, for example.
After a couple of stages of the wizard, you'll be asked to choose an installation folder:
I've gone for the default, yet again!
You can now start the installation:
Go for it!
You'll probably then need to confirm you want to proceed, after which time you'll see a status message:
Things are going swimmingly.
Finally, you'll see a completion message:
You can now finish the installation.
When you create a new report again following the steps at the top of this page, you'll now be taken into Power BI for Report Server:
A trip back in time to the May 2020 version (at least at the time of writing).
Compare the two icons!
The one on the left is Power BI Desktop; the one on the right Power BI for Report Server.
You can then create your Power BI report:
This report was created using exactly the same data source as the paginated report for the previous page of this blog.
When you've created your report, you can save it directly to Power BI Report Server:
Choose Save as, and choose to save your report to Power BI Report Server.
If this is the first time you've done this, you'll be asked to type in the location of your report server:
Enter the location of your report server and select OK.
You can then give your report a name:
Here I've called this report Films for directors.
You could if you like click on the link to go to your report server.
When you press F5 to refresh Power BI Report Server, you'll see your new report:
You can now click on your new Power BI report to view it.
When you view your report, you'll see the interface is a bit different to (and simpler than) Power BI Service:
Viewing a report through Power BI Report Server
I've been astonished throughout creating this blog by how simple the process is, and how clear it is what's going on behind the scenes. I'm now a big fan of Power BI Report Server!
|Parts of this blog|
25 Aytoun Street