I need that user could specify a specific date and the report would refresh from data source to show it. It could be chosen from a calendar, date picker or simply by writing down a date in the field as a string. The problem is that the data can't be loaded and then filtered. It has to use this chosen date in the SQL query, which would allow to recalculate data. Users are Power Bi PRO and uses the cloud version. Would it be possible?
As Sam Nseir suggested you can use Dynamic M query parameters, you can check the following question that seems to be similar to yours:
How to change the power query parameter from the Power BI Interface?
A part from MS the reference given by Sam Nseir you can check this article that can be helpful: