Reply
pjjfmarques
Frequent Visitor

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

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...

2 ACCEPTED SOLUTIONS
Habib
Continued Contributor
Continued Contributor

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.

View solution in original post

ankitpatira
Community Champion
Community Champion

@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. 

View solution in original post

3 REPLIES 3
ankitpatira
Community Champion
Community Champion

@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
Continued Contributor
Continued Contributor

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.

avatar user
Anonymous
Not applicable

Hi Habib,

 

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

 

Best Regards,

Ichebobo

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)