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
I doubt based on blog shared above.If we need to limit data in dataset, we can opt for option 2.
I am confused that if i will publish this dashboard on service, will dataset hold all clients infotrmation or only those which are filtered out.
Continuation to this can we see dataset size which we publish on workspace, individually.
Super UserIn 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