Chennai Power BI User Group

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.

Power BI Report Server - Change Data Source using REST API

  • 1.  Power BI Report Server - Change Data Source using REST API

    Silver Contributor
    Posted Feb 01, 2020 12:48 AM

    This post gives an idea that you can change the Power BI report's data source without using Power BI desktop. Do you think is it possible? I am talking about Power BI Report Server.

    Yes. This is possible with the help of Power BI Report Server REST APIs. You can go through the supported API methods using the below URL.

    https://app.swaggerhub.com/apis/microsoft-rs/PBIRS/2.0

    The syntax of the REST API is http://<reportservername>/reports/api/v2.0/

    Scenario:

    I have a report published into Power BI Report Server portal and I want to change the database used on the report to some other database. In this example, I am using a database called IT_Dev on my report and I will be changing the database to IT_Prod. Even you can change the server name also.

    Check the following blog article for more information - http://dataap.org/blog/2020/01/17/power-bi-report-server-change-data-source-using-rest-apis/

    Share your comments.



    ------------------------------
    Hariharan Rajendran

    ------------------------------