Forum Discussion

NehaGoel_2203's avatar
NehaGoel_2203
Frequent Visitor
7 months ago
Solved

Reduce PBIX file size

Hi Team,   The data has been taken from SQL Server, and my two PBIX file size is (2591219KB,1962302KB) very large. I would like to know how to reduce the file size. I have already removed unused co...
Need Help
  • Tutu_in_YYC's avatar
    Tutu_in_YYC
    7 months ago

    Another option is to use Direct Query instead of Import. This way the data is stored in the SQL database, not in the cloud.

NehaGoel_2203's avatar
NehaGoel_2203
Frequent Visitor
7 months ago

tayloramy thankyou for the help sir. That is a university data and all rows data are important. It can't help to reduce data size

tayloramy's avatar
tayloramy
Super User
7 months ago

Hi NehaGoel_2203, 

 

If there is no way to reduce the dataset size, then the last option is to upgrade your capacity. 

 

 

  • NehaGoel_2203's avatar
    NehaGoel_2203
    Frequent Visitor
    7 months ago

    how?

    • v-achippa's avatar
      v-achippa
      Community Support
      7 months ago

      Hi NehaGoel_2203,

       

      Thank you for reaching out to Microsoft Fabric Community.

       

      Thank you cengizhanarslan, Tutu_in_YYC and tayloramy for the prompt response. 

       

      Upgrading capacity should be the last option.
      Even if all rows are required, large pbix file size is usually because of high cardinality columns, date time precision, auto date/time tables and data types, not just row count. So before upgrading, please try DirectQuery or optimize the model properly (cardinality, date time columns, data types, incremental refresh).
      If the dataset is still large after proper modelling, then consider PPU or Fabric capacity.

       

      Thanks and regards,

      Anjan Kumar Chippa

       

       

      • NehaGoel_2203's avatar
        NehaGoel_2203
        Frequent Visitor
        2 months ago

        We have already upgraded the capacity and successfully adjusted all relevant settings. However, the system is still encountering the CompressDataSize error during the schedule refresh.