Options for getting only preffered data before loading into power bi

Hi, When creating power bi reports or dashboards, most of them are linked directly to the datawarehouse where we have full control over what query to write in order to get only data we need. But for...