Forum Discussion
how to handle large data size
I tend to avoid direct query if performance is important as unless you are filtering down to small data sets on well indexed sources it can be slow.
Take a look at aggregations as here you can get the best of both worlds by importing aggregations and direct query for individual records
https://docs.microsoft.com/en-us/power-bi/desktop-aggregations
https://www.sqlbi.com/tv/aggregations-in-power-bi/https://radacad.com/power-bi-aggregation-step-1-create-the-aggregated-table
Anonymous
It really depends on what type of data you have. PowerQuery is really good and compressing data. In addition if you research the query folding data, you will be able to determine the best place for your query to fold to maintain performance. Here are a couple of good resourses for you.
https://powerpivotpro.com/2015/12/compression-with-power-pivot/
https://powerpivotpro.com/2010/02/surprising-example-of-powerpivot-compression/
https://www.mssqltips.com/sqlservertip/3635/query-folding-in-power-query-to-improve-performance/
https://blog.pragmaticworks.com/power-bi-checking-query-folding-with-view-native-query