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 environment changes from UAT to Production, the query will fetch data from appropriate environment table. This issue is preventing me from deploying from UAT to production.
Thanks!

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

     

4 Replies

  • robert245's avatar
    robert245
    New Member
    2 years ago
    connectmukesh1 wrote:

    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 environment changes from UAT to Production, the query will fetch data from appropriate environment table. This issue is preventing me from deploying from UAT to production. Lowes Life
    Thanks!

    Hello, 

    Thanks for creating this post actually i am also facing this querry but recently found this tpic which help me. 
    Thanks for the reply also.
    Best regards,
    robert245

  • 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