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

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
2 years ago

connectmukesh1 Create a Parameter. You can then use that Parameter in your SQL query. You can use the & concatenation operator.