Skip to main content

    Power BI

    Needs Votes

    Progrmatically update data source connection

    Vote (56) Share
    Selva's profile image

    Selva on 31 Oct 2017 21:04:45

    Hi,

    We have requirement to update the data source connection programmatically. We deploys same PowerBI report for multiple cleints, only we need to update the data source connection. Our complete process is taken care by SSIS. Using SSIS or C# or powershell, we need to update our data source without open the PBIX everytime in PowerBi desktop to update the connection.

    Comments (1)
    Selva's profile image Profile Picture

    Menno van Tienhoven on 05 Jul 2020 23:48:03

    RE: Progrmatically update data source connection

    Looks similar to https://community.powerbi.com/t5/Report-Server/Deploying-POwer-BI-Reports-to-Power-BI-Report-Server-Using-RS/td-p/208354

    and
    https://ideas.powerbi.com/forums/282523-bi-in-sql-vnext/suggestions/7497163-enhance-deployment-options-without-visual-studio

    But as far as I can tell, there is no option to do this with PowerShell at least.