Filtering at Source

vshiva — Wed, 26 Sep 2018 06:43:33 GMT

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.

topic Filtering at Source in Report Server

Filtering at Source