Filtering at Source

[vshiva]

I am creating a dashboard which will be used by 100+ users. 

Context: I have 10M rows with 30+ columns of data in Oracle / SQL DB. I need to filter them at the source (before loading into Power BI) to improve my dashboard performance.

Need: I have to filter them based on multiple conditions (Min 3 nos) which can be from either a single column or across multiple columns.

My users are not much familiar with Power BI and I need to simplify their filtering process. I am thinking of below two options. (Not sure about the Feasibility though)

1. Give them this as a filtering option in the Dashboard itslef. i.e., User can input / select the criteria from a dropdown list.

2. Use some buttons in the Power BI Dashboards to do this?

Request to kindly shed some light on this.