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.

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

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

        Hi NehaGoel_2203,

         

        Here looks like error is because the compressed size is exceeding the per dataset limit on your capacity. In power bi service --> under dataset settings --> Large dataset storage format, turn On.

        • If possible, store the images as url’s for example in azure blob storage and reference them in your report visuals instead of embedding the actual image data in the model
        • If the large dataset format is already enabled and you are still hitting the limit, please share the exact error message and the current dataset size from the dataset settings so we can look more into the issue and provide you the best solution possible

         

        Thanks and regards,

        Anjan Kumar Chippa

    • NehaGoel_2203's avatar
      NehaGoel_2203
      Frequent Visitor
      1 month ago

      Give the steps 

    • NehaGoel_2203's avatar
      NehaGoel_2203
      Frequent Visitor
      1 month ago

      hi v-achippa 

      this is the exact error

      {"error":{"code":"DM_GWPipeline_Gateway_CompressedDataSizeForPacketExceededError","pbi.error":{"code":"DM_GWPipeline_Gateway_CompressedDataSizeForPacketExceededError","parameters":{},"details":[],"exceptionCulprit":1}}}

      • v-achippa's avatar
        v-achippa
        Community Support
        1 month ago

        Hi NehaGoel_2203,

         

        Here looks like the error is because a single image row is larger than the maximum packet the gateway can send during refresh, it's a fixed service limit, so it cannot be increased with settings or capacity.

        At the source side resize the photos to a small resolution and store them as plain binary not as base64. Refresh the dataset once no single image exceeds the limit.

         

        Thanks and regards,

        Anjan Kumar Chippa