Forum Discussion

Geo_Dor's avatar
Geo_Dor
Frequent Visitor
3 years ago
Solved

Unable to save document

Hello everyone,

 

Im trying to save a huge pbix and the error below occured

 

the data model is already 5.5 gb and when i try to add more tables and save the file this error appears.

 

Thanks in andvance for the help.

Need Help
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    Hi, Geo_Dor 

     

    Yes, Premium doesn't have a 1GB limit. 

     

    You can try the following methods.

    1. Increase Cache. File -> Options and setting -> Option -> Data load

    2. Increase virtual memory of the system. Sometimes C drive does not have enough space to expand. if you other drive add Virtual memory there

    How to reduce your Power BI model size by 90%! - Data Mozart (data-mozart.com)

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

  • v-zhangti's avatar
    v-zhangti
    Icon for Community Support rankCommunity Support
    3 years ago

    Hi, Geo_Dor 

     

    Your data model is too large and needs to be refined. If it is an import mode, the maximum support is only 1GB.

    If the data is very large, it wouldn't be feasible to import it all. DirectQuery, by contrast, requires no large transfer of data, because it's queried in place.

     

    There are a few benefits to using DirectQuery:

    • DirectQuery lets you build visualizations over very large datasets, where it would otherwise be unfeasible to first import all the data with pre-aggregation.
    • Underlying data changes can require a refresh of data. For some reports, the need to display current data can require large data transfers, making reimporting data unfeasible. By contrast, DirectQuery reports always use current data.
    • The 1-GB dataset limitation doesn't apply to DirectQuery.

     

    For reference:

    Using DirectQuery in Power BI - Power BI | Microsoft Learn

    Use DirectQuery in Power BI Desktop - Power BI | Microsoft Learn

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Geo_Dor's avatar
      Geo_Dor
      Frequent Visitor
      3 years ago

      Hello v-zhangti ,

       

      Thanks for the answer. My account is premium, so i have believed than there is no t limitation in the pbix file.

       

      is n't it true?

      • v-zhangti's avatar
        v-zhangti
        Icon for Community Support rankCommunity Support
        3 years ago

        Hi, Geo_Dor 

         

        Yes, Premium doesn't have a 1GB limit. 

         

        You can try the following methods.

        1. Increase Cache. File -> Options and setting -> Option -> Data load

        2. Increase virtual memory of the system. Sometimes C drive does not have enough space to expand. if you other drive add Virtual memory there

        How to reduce your Power BI model size by 90%! - Data Mozart (data-mozart.com)

         

        Best Regards,

        Community Support Team _Charlotte

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.