Forum Discussion

jrieman's avatar
jrieman
Frequent Visitor
1 year ago
Solved

Is it Possible to Parameterize Server Type - Switch From MySQL to SQL Server?

edited for clarity Is it possible to parameterize  the database type I'm connecting to?  I want to change from MySQL server to SQL Server.   My reports query databases hosted on a MySQL server.  M...
Need Help
  • jrieman's avatar
    jrieman
    1 year ago

    I ended up doing it by making Source conditional, based off value of parameter, within the Power Query advanced editor.  

    I'm using the approach below.

     

    let
    Source =if server= "xerxes" 
    then MySQL.Database("xerxes.corp.brillo.com", "brilloweb_api", [Query="select *#(lf)from products;", ReturnSingleDatabase=true])
    else if 
    server = "alexander"
    then Sql.Database("alexander.corp.brillo.com", "brilloweb_api", [Query="SELECT * FROM products p;"])
    else MySQL.Database("xerxes.corp.brillo.com", "brilloweb_api", [Query="select *#(lf)from products;", ReturnSingleDatabase=true])  
in
    Source

     

     

lbendlin's avatar
lbendlin
Super User
1 year ago

Are you using Query Folding?  Are you using native queries?

jrieman's avatar
jrieman
Frequent Visitor
1 year ago

I believe folding.  Simple select * against data warehouse table.   When I right click 'Source' under APPLIED STEPS, view native query is greyed out.  I think that indicates I'm folding?