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 P...
Need Help
Eric_Zhang's avatar
Eric_Zhang
Icon for Microsoft Employee rankMicrosoft 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.