Populate date parameters in sql query - denodo data source

[amrosullivan]

hello,

• i am using PBI April 2022 version
• connecting to Denodo - denodo.query
• executing a custom SQL query that requires date parameters
• import mode

is there a way i can create some way i can parameterise a list in power query that populated the custom sql query?

the requirement is to execute this query for multiple end of month dates - p_date_param1 in ('2023-03-31','2022-12-30')

can those two dates there be populated by a dynamic list in power query - for eg a list of month end dates for the last year 

thank you!

[v-yiruan-msft]

Hi @amrosullivan ,

Please check if list parameter the is what you want.

Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn

Best Regards