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
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