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
Your code is redundant - you could fold the SQL server into the Else branch.
Does the refresh work on the Power BI Service?
jrieman
1 year agoFrequent Visitor
Yes it refreshes, though the visual didn't reflect the new data until I went into edit mode (within service) and selected refresh.