It would be very useful a functionality for insert query prompt in order not to extract an entire table if you only need a subset of it. Se we would like to have the possibility to insert a variable...
I can't understand by now why is not possible in power bi web to have parameters to be displayed before data refresh ... Because I have billions of row in my fact table for two years of sales ...
