Forum Discussion

javigold's avatar
javigold
Frequent Visitor
3 years ago
Solved

Using a Parameter in Query String

I have a query string that I'm using to pull data:

 

[Query="SELECT ID AS OrderId, Amount AS OrderAmount from TableOrders Where StoreId = '20'"]
 
How do I use a parameter as the StoreId and concatenate the string?   Everything I've tried has failed.  
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    Hi,

    I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

    The parameter is created in Power Query Editor.

     

     

2 Replies

  • javigold's avatar
    javigold
    Frequent Visitor
    3 years ago

    Geez!  I was making this so difficult.  Thank you!

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    3 years ago

    Hi,

    I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

    The parameter is created in Power Query Editor.