I need to pull data via a SQL function that requires a date parameter. The SQL query is very simple: SELECT * FROM dbo.FunctionName('20230630'). All the search results I've found focus on using date parameters to filter the dataset once it is returned to Power Query. However, this function does not return a date column. Thus, filtering the dataset in Power Query is not an option. Is there any way to do this? Thanks

DukeCarey I created a parameter, called startdate, in your case it is linked to an Excel sheet, it;s fine. Here is the modified code, which should work for as well. Modify the Date format as per your source system. let DateParam = "'" & Date.ToText(StartDate, "yyyy-MM-dd") & "'", Source = Sql.Database(".", "ContosoRetailDW_2019", [Query="SELECT * FROM dbo.GetCustomersByDateFirstPurchase(" & DateParam & ")", CreateNavigationProperties=false]) in Source

Pass date parameter to a SQL function | Microsoft Fabric Community

Forum Discussion

Related content

Fabric passing parameter

Passing Parameter to warehouse

Pass Parameters to SQL Queries

Passing Parameters in measures

UDF: can we pass a column as parameter?