Forum Discussion
Solved
Start and End Date Parameters for SQL statement in Import mode
My IT associate and I recently configured a Direct Query in Power BI that leverages a SQL Function with parameterized Start and End Dates for my Reports. I've received authorization to bypass the SQL...
Sorry for the late reply. Hopefully you managed to figure it out, but if not then you need to go into the Model view, then bind the column to a parameter. Please note that this will only work in you have Direct Query connection. And ONLY Direct Query. If you have a mix of SharePoint, or anything else, it won't be available.
Try without the @
That's how I have it in one of my queries.
edit: Oh, and StartDate and EndDate are separate parameters: