none
Change server IP for multiple connection RRS feed

  • Question

  • Hello  Power Queriers,

    I have a report with large number of power queries, the IP of database server has changed so need to change the server connection.

    Is there any way to bulk update the power queries or can it only be one one by one?

    Thank you.

    Ben

    Thursday, February 4, 2016 8:41 AM

Answers

  • To handle this kind of change in the future, you could define a query containing the just IP address, and reference it from your other queries. Then if/when the IP changes, you can just update it once and all the other queries will get the new value.

    As far as I know, for now you're going to have to update them one at a time.

    Ehren

    Friday, February 5, 2016 7:20 PM
    Owner