Is there a way to batch change the data source connection string?

[python]

I have more than 100 pbix file and I want to change the connection string for all these pbix file. Is there a way? Or I have to do it manually?

Can I make database connection string parameters?

Thanks!

[v-yulgu-msft · Accepted solution]

Hi @python,

As I know, power bi doesn't support to update data source connection string programmatically without opening the .pbix file. Please upvote this idea.

As a workaround, you could try to store the connection string to a config file, each time to change data source, you only need to analysis this file via a custom function. For more description, please check this similar thread.

For database connection string parameter, please refer to this blog:

POWER BI DESKTOP QUERY PARAMETERS, PART 1

Best regards,

Yuliana Gu