This post explains how to use Postman tool to access the Power BI Report Server REST API. As you know, Microsoft Power BI team released the REST API feature for both Power BI Service and Report Server. Using this REST API, we can access and control the Power BI objects.
Use the below URL to access Power BI Report Server REST API.
The list of objects which supported in REST API are,
Microsoft providing the swagger site to show the detailed REST APIs.
If I want to see the list of Power BI reports then we need to use the below URL on the browser. Actually, it is a get method so we can use the browser.
It also will show the properties of each report.
If we want to use the other method like POST, PATCH, PUT and DELETE then we need to use any other application because it can’t be done in browsers. Use the Postman tool to access all the REST API methods.
Microsoft Power BI team releases a Power BI Report as generally available. We can get this report server as part of Power BI premium but still, we can use the trial version for 180 days.
This post explains to you that how we can setup the Power Bi report server. You can download the Power Bi Report Server here.
It contains two components
It is easy to install Power BI Report server in your system. Just follow the below screenshots and click Next and complete the installation.
Once the installation is completed, we need to configure the Report Server which is nothing but our regular SSRS report server configuration but for Power BI.
Configure as usual and test the web service and web portal URL.
To start developing the reports, need to install the Power BI Desktop RS which is same like regular Power Bi desktop but with few changes.
We can save the report in our on-premises portal with the PBIDesktop RS tool.
Check the general information about Power BI Report Server.
|Report Server||Power BI Report Server|
|Service||Power BI Report Server|
|Log on Account||NT SERVICE\PowerBIReportServer|
Microsoft SQL Server Reporting Services is the product which provides solutions to all the business enterprises. While it was in peak, Microsoft released another new BI tool which is nothing but Power BI.
Now Power BI is leading the Business Intelligence Industry. As it is a cloud-based service, business users were not able to use that tool for their business solutions because of security concerns. They were waiting for on-premises based Power BI server.
Now the wait is over. Microsoft released Power BI Report server which can be installed and configured for on-premises business solutions.
Power BI Report server is available for preview, you can download, install and experience the on-premises based Power BI Report.
As it is very new, it supports only analysis services as a source but in future, we can expect the same source connectors as like in Power BI cloud services.
This blog post explains to you that how you can experience the Power BI Report server using the Azure VM template.
Follow the below steps to spindle up Azure VM with Power BI Report Server on it.
Step 1: Login Azure portal and add a new Virtual machine
Step 2: Search for Power BI and it will show the below template
Step 3: Click create
Step 4: Add the VM name and credentials and choose which AS server you want to use from the drop down.
Step 5: By default, it using the below settings. In case, if you get an error message then change the name of the storage.
Step 6: At last, you need to click the purchase button. It will create and deploy the Power BI machine.Once the machine is deployed successfully, connect the machine and you can see the Power BI.
Once the machine is deployed successfully, connect the machine and you can see the Power BI Report Server.It also adds an option to create Power BI Report from the portal itself.