Forum Discussion

sevenhills's avatar
sevenhills
Super User
1 year ago

Dynamic Connection & Query Execution Across Multiple Databases in Azure SQL Server

Subject: Dynamic Connection & Query Execution Across Multiple Databases in Azure SQL Server Hi, We are having Azure SQL Server across Dev, QA, and Prod environments, with approximately eight ...
Need Help
v-echaithra's avatar
v-echaithra
Community Support
1 year ago

Hi sevenhills ,

Thanks for the update. 
As it worked with fabric warehouse, please try for azure SQL.

let
    Dev = Sql.Database("x6eps4xrq2xudenlfv6naeo3i4-wwtdsvdlvx2elaqgwcxhcqgmly.msit-datawarehouse.fabric.microsoft.com", "WH123", [Query="select * from SALES"]),
    QA = Sql.Database("x6eps4xrq2xudenlfv6naeo3i4-wwtdsvdlvx2elaqgwcxhcqgmly.msit-datawarehouse.fabric.microsoft.com", "WH456", [Query="select * from SALES"]),
    AllVersions = Table.Combine({Dev, QA})
in
    AllVersions

If this post helps, please give us Kudos and consider marking it Accept as solution to assist other members in finding it more easily.

Regards,
Chaithra


  • sevenhills's avatar
    sevenhills
    Super User
    1 year ago

    I'm not sure if you had a chance to fully read my original post—I’ve already tried the approach using individual server connections and queries. It is already done! 

    What I’m specifically looking for is guidance on using functions within Azure SQL Server and dynamic connections.

    I mentioned that I can already use functions with on-premise SQL Servers, so the goal here is to understand any viable options or limitations in the Azure context.

     

    I appreciate your effort and sample file to solve my issue. Please don’t take this the wrong way, but I’m not quite sure how your latest response addresses my question.

     

    I'd prefer to keep the thread open in case others have insights—either now or in the future.

    Regards