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
Community Championif 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/
- Thejeswar
Super User
Hi Anonymous,
Yes you can filter the data set in PBIX Power Query window which you get when you click on edit Queries, just like the way you do in excel.
Click on the column drop down and filter the items that you want
Thanks alot for help
Hi,
There are two options available.Not able to understand consequences of each.
Which one should i prefer.
Option 1: Writing sql while importing my view in power bi desktop with where clause.What impact will it have to performance since it stops query folding.
Option 2: to apply select specigif id from columns populating in edit queries?Will it not pull all data from sql server and then apply filter?
- Thejeswar
Hi Anonymous,
I would say Option 1 is the better approach of the two specified.
In Option 1, your data will be restricted even before it is imported to your report. In this means, you can restrict the volume of data getting imported in Import Mode. In case of Direct Query, it will certainly improve performance as compared to applying filter in Power BI, as every time your query runs the query is applied on the entire table to which it is connected to
In your Oprion 2, as you say, even if you filter for specific id in the Edit Queries Window, the Filters will be applied only after the entire data is pulled in to the report