Forum Discussion
jrieman
1 year agoFrequent Visitor
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...
- 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
1 year agoSuper User
Are you using Query Folding? Are you using native queries?
jrieman
1 year agoFrequent Visitor
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?