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.

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.