Using a date parameter in Power BI

[Berl21]

Hi,

I have a report based on a sql with a date filter. Now what I want to do is the following:

- replace the date filter with a parameter

- let users fill in whichever date in the online version and then actualize the report

I am quite sure the first thing is possible as an admin, since I already did that a few years ago in Excel/ Power Query. Though I don't remember exactly how that works?
As for point 2 I need to know if a standard user can do that without having an access to the databank himself. Is it even possible?

Thanks,

Pauline.

[lbendlin]

Only if your SQL Server connection is Direct Query