Forum Discussion

swrlabhe's avatar
swrlabhe
Helper I
1 year ago
Solved

Dynamic M query with snowflake

Hi All i am trying to setup a dynamic M query parameter with snowflake and date field. i have created the parameter in report and trying pinning in the query but somehow it always shows syntax erro...
Need Help
  • danextian's avatar
    danextian
    1 year ago

    Hi @
    Try something like below:

    let
  AsOfDateParam = AsOfDate,
  FormattedDate = Date.ToText(AsOfDateParam, "yyyy-MM-dd"),
  Source = Sql.Database(
    "YourServerName",
    "YourDatabaseName",
    [
      Query = "
            SELECT OrderID, CustomerID, OrderDate, TotalAmount
            FROM Sales
            WHERE OrderDate >= '"
        & FormattedDate
        & "'"
    ]
  )
in
  Source
v-kpoloju-msft's avatar
v-kpoloju-msft
Community Support
1 year ago

Hi swrlabhe,

Thank you for reaching out to the Microsoft fabric community forum. Also thanks to danextian, lbendlin, for those valuable insights on this thread. I reproduced the scenario, and it worked on my end. I used my sample data and successfully implemented it.



From snowflake I take server name from account shown in the image and warehouse name is COMPUTE_WH.

 



 

 


outcome:

I perfectly executed the Dynamic M query with the sample data, you can verify the below .pbix file.

I am also including .pbix file for your better understanding, please have a look into it:

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you for using Microsoft Community Forum.