dynamics params

[Syndicate_Admin]

We need help for the following case:We load from bigquery two tables of which we will only need a data set that will be defined by the user (Date) We would like to use parameters associated with the sql code in the advanced editor. Example: "Select * from table where" Date parameter User selects two date parameters With power automate (button) the report is refreshed Problems, we are not able to do it by import, we only see that it is allowed to be done by DirectQuery and in Power automete we would only want to reload those two tables, not the complete schema. Thank you very much for the help