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...
same problem here. Our fact tables have millions of rows and I'm not able to use power Bi desktop for that amount of data. Pre filtering via prompts is crucial. Any ideas?
