- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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...
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Habib,
How Can an use 'Parameters option to reduce my data?
Can you please list the steps for Parameter Option.
Best Regards,
Ichebobo

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
05-28-2024 12:45 PM | |||
06-17-2024 09:57 AM | |||
06-06-2024 07:43 PM | |||
12-20-2023 05:34 AM | |||
02-13-2024 06:31 PM |
User | Count |
---|---|
141 | |
115 | |
84 | |
63 | |
47 |