Forum Discussion
restrict loading of dataset
if you filter the customers within the PowerBI interface, it should apply query folding to apply the filter
https://blog.crossjoin.co.uk/2017/06/11/query-folding-and-writing-your-own-sql-queries-in-power-querypower-biexcel-get-transform/In Option 2, your entire data is brought in, Only after that your filters are applied. In Other Words, Your report will have all clients information, but your visuals will get only the restricted clients information as you are applying the filters to your dataset before using in Visuals
Yes you can see the datset size in your Group Storage Section. Find below the image
Clicking on this, will display all the information related to the data sets
In Option 2, the entire dataset is first loaded into Power BI, and then filters are applied at the visual level. This means that while the report contains all client data, only the restricted client information appears in the visuals.
However, loading the full dataset before filtering can impact performance, especially with large datasets. A more optimized approach is to apply filtering at the source level using a SQL query before loading data into Power BI. This reduces the dataset size and improves report performance.
For example, instead of bringing in all client data and filtering later, you can use a SQL query with a WHERE condition to load only the required data:
SELECT *
FROM Clients
WHERE Region = 'West' -- Load only data for the 'West' region
This ensures that only relevant data is imported, leading to faster refresh times and improved report efficiency.
Regarding dataset size, you can check it in the Group Storage Section in Power BI Service, where it provides details on how much space your dataset occupies. Below is an image showing where you can find this information.