Forum Discussion
Solved
Slicer for getting data
Hi, I wanted to first say that power BI is an awesome tool that everyone in the team highly enjoys! I wanted to ask the following question: Our team has been running into the following problem: W...
Hi sundayDriver,
The limit for PBIX files is currently 1GB. Power BI uses compression that can compress up to around 10x so is your source data really around 10GB?
There are some tricks to reduce the import file size such as
- remove unnessary columns,
- aggregate your data in your source data if possible
- Split Datetime data into 2 columns (if time is needed)
If these don't help then sure, DirectQuery is an option but hopefully your source system is SQL2016 with columnstore indexes optimised to the max :)
As Phil_Seamark and Greg_Deckler, for large amount of data, you'd better use DirectQuery mode due to the 1 GB limitation. If you need to filter expected records (blue, green or yellow) during data retrieval, you need to do it in your query.
Regards,
You would want to look at using DirectQuery.