Native SQL Query support

[connectmukesh1]

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!

[Anonymous · Accepted solution]

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

[robert245]

---

@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

[connectmukesh1]

can you please share ?

[Greg_Deckler]

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