Forum Discussion

aroyappan's avatar
aroyappan
Frequent Visitor
9 years ago

Update connection string of PBIX file

Hi All,

 

I'm new to power bi. We have multiple clients consuming different database with same schema. I couldn't find a way to dynamically update connection string after publishing the report to Power BI service in order to share the report across all the clients. 

So I wanted to use the REST API to programatically update the connection string of the pbix file and publish the report (using import) to the Power BI service. Is it possible to update the connection string using the APIs?

 

Thanks in advance.

Need Help

1 Reply

  • Eric_Zhang's avatar
    Eric_Zhang
    Microsoft Employee
    9 years ago

    aroyappan

    AFAIK, there's no way to change the connection string in the pbix file, you can check this idea Power BI Designer API and vote it up.

     

    To update the connection string of a published dataset, you can check this API SetAllConnections, note that this API can only be called DirectQuery dataset.