Forum Discussion

TungNguyen_19's avatar
TungNguyen_19
Icon for Helper III rankHelper III
3 years ago
Solved

How to use only 1 parameter to switch different database connections rather than 2?

Hello everyone, Based on many related helpful posts changing connections by using 2 parameters (just like this one ) but I faced to this task when I have theses Azure SQL databases with different UR...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    3 years ago

    Hi TungNguyen_19 

     

    When you connect to Azure SQL databases, Power Query uses Sql.Database function. It requires server and database as two separate parameters. So it seems not possible to use only one parameter to switch the data source. 

    Sql.Database(server as text, database as text, optional options as nullable record) as table

     

    If you use Odbc.DataSource, it may be possible to use only one parameter as it only requires connectionString. I haven't tested this yet. However ODBC connector only supports Import mode and the query performance is not as well as the SQL Server database connector. 

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.