REST APIs For Power BI Report Server

The URL of the REST API service for PowerBI report server is highlighted below. This is the same for SQL Server Reporting Services from 2016 onwards.

http://<reportservername>/Reports/api/v2.0

Example - http://lab/PBIReports/api/v2.0

Steps to access REST API in the browser

1. Enter the following URL - http://lab/PBIReports/api/v2.0
   
   
   • Replace the report server name and reports folder
     
     
2. Refer to the following URL to check the available commands to access the report server elements https://app.swaggerhub.com/apis/microsoft-rs/pbirs/2.0#/
   
   
3. If you want to see the data from the Shared dataset then the URL should go as below.
   http://lab/PBIReports/api/v2.0/datasets(a8fd207a-bb6d-43ec-9b9e-391e293e2dd8)/data
   
   This will show the result as below based on the dataset that you used.
   
   
    

We can use this REST API on applications and can access the report resources from the application. Access includes read, write, and delete. Check the swaggerhub for more information.

Shared Dataset for Power BI Report

With the help of REST API, we can use the Shared Dataset as a source for Power BI Report. As you know, the Shared Dataset is one of the standard objects for SQL Server Reporting Services. Using Shared datasets, you can create multiple paginated reports and mobile reports.

REST API opens a channel to use the SQL Server Reporting Services Shared dataset as a source for Power BI report.

Follow the below steps to use the Shared dataset inside PowerBI

Data Connector: OData feed

1. Always make sure to check the below checkbox (Check the below screenshot).
   
2. Expand “More Columns”. It will create a new step in the applied steps section.
   
   

3. The above step will expand all the columns from the dataset as below. You can change the data type of the column and start to build the report.
   
   

Report Server Resource Utilization

Using REST API, we can build the report server resource utilization PowerBI report. Again, we need to use the OData feed for this scenario.

Follow the below steps,

1. Use the default REST API URL on the OData feed.
   
    

2. Specify the Table that you want to use for your report.
   
    

3. The table contains the below information. This table also contains a few columns which have additional information. If you want to consider that information, then you can expand those columns and add it to the data model.
   
   

4. When the data model is ready then you can create a report.