Forum Discussion

swrlabhe's avatar
swrlabhe
Icon for Helper I rankHelper 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
Icon for Community Support rankCommunity 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.

v-kpoloju-msft's avatar
v-kpoloju-msft
Icon for Community Support rankCommunity Support
1 year ago

Hi swrlabhe,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.