Forum Discussion

connectmukesh1's avatar
connectmukesh1
Regular Visitor
2 years ago
Solved

Native SQL Query support

Hi There, I have a situation with a native query in power bi desktop. The developer wrote a native query to fetch a specific table, but I need the table name to be dynamic. This way, when the enviro...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi connectmukesh1 ,
    Thanks for his reply. Here is what I need to add, first create a new parameter in power query. Then open the advanced editor and call the parameter

    let
    Environment = if Parameters[Environment] = "UAT" then "UAT_TableName" else "Prod_TableName",
    Source = Sql.Database("ServerName", "DatabaseName", [Query="SELECT * FROM " & Environment])
in
    Source

     

    Best regards,
    Albert He

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi connectmukesh1 ,
Thanks for his reply. Here is what I need to add, first create a new parameter in power query. Then open the advanced editor and call the parameter

let
    Environment = if Parameters[Environment] = "UAT" then "UAT_TableName" else "Prod_TableName",
    Source = Sql.Database("ServerName", "DatabaseName", [Query="SELECT * FROM " & Environment])
in
    Source

 

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly