Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago

USING PARAMETERS IN NATIVE SQL QUERY

Dear Community, I have the following query. I have a native SQL server query which has a date parameter and I need to be able to automate it from power query. I share the original query that feeds ...
v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, Syndicate_Admin ,

. Generally speaking we can reference parameters via:

  • Data Source
  • Filter Rows
  • Keep Rows
  • Remove Rows
  • Replace Rows

1-Click “New”

2-Type a name for the parameter

3-You can also write a description

https://biinsight.com/power-bi-desktop-query-parameters-part-1/

https://docs.microsoft.com/en-us/power-query/power-query-query-parameters

https://www.red-gate.com/simple-talk/databases/sql-server/bi-sql-server/power-bi-introduction-working-with-parameters-in-power-bi-desktop-part-4/


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.