How to reduce the amount of data that is loaded into my Power BI Report

[pjjfmarques]

My objective is to reduce the amount of records that my Power BI report loads from my DB.

So ,how can I (in query editor) aplly a filter on a table Query depending of information in other related table?

Example: I am defining a query to load my sales lines (table 1) only for the clientes (table 2) that lives in the state xyz (table 3).

Is that possible? How?

Thanks for the help...

[Habib · Accepted solution]

If you want data loading to be filtered out at DB side, only option is views. Create view in database and use as your data source.

If you want your data to be filtered in Query Editor, then you can use Parameters option.

[ankitpatira · Accepted solution]

@pjjfmarques on top of what @Habib said depending on type of DB you've got but if it is sql server you also have option to write in sql statements when connecting using which you can filter. 

[Habib · Accepted solution]

If you want data loading to be filtered out at DB side, only option is views. Create view in database and use as your data source.

If you want your data to be filtered in Query Editor, then you can use Parameters option.

[Anonymous]

Hi Habib,

How Can an use 'Parameters option to reduce my data?
Can you please list the steps for Parameter Option.

Best Regards,

Ichebobo