Forum Discussion

sundayDriver's avatar
sundayDriver
Microsoft Employee
9 years ago
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...
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    9 years ago

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

     

     

     

  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    sundayDriver

     

    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,

v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
9 years ago

sundayDriver

 

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,