Forum Discussion
Is there a way to batch change the data source connection string?
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!
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
1 Reply
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