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 conc...
  • Jihwan_Kim's avatar
    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.