Forum Discussion

Nikhillearn's avatar
Nikhillearn
Frequent Visitor
5 years ago

uncompressed data size exceeds 10 gb

I am working on a report that pulls data from a database. I am pulling data from a single table of size 1.6GB.  I am able to refresh the report in desktop and get in published. When I try to refresh in my workspace however I get an error message saying that uncompressed data size exceeds 10 GB. I am confused. I am sure that the source data does not exceed 1.6 GB. The pbix file is 370MB. Why is power bi giving this error ?

Need Help

3 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    5 years ago

    Use DAX Studio to examine your data sources, check cardinality and compression rate. Any cross joins or expensive merges in your data source scripts?

    • Nikhillearn's avatar
      Nikhillearn
      Frequent Visitor
      5 years ago

      Thank you for the suggestion.

      I have used Dax studio with this report but no luck. As I said earlier, I am pulling data from a single table, no transformations. I can see that there are some columns with high cardinality but that is justified, these are facts and are supposed to have high cardinality. What I don't understand is why 1.6 GB in database which becomes 360 MB in Power BI is exceeding 10 GB limit on gateway. 

  • v-kelly-msft's avatar
    v-kelly-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi Nikhillearn ,

     

    Check the similar thread below:

    https://community.powerbi.com/t5/Service/Online-refresh-is-failing-The-received-uncompressed-data-on-the/td-p/190001/page/2

     

    Uncompressed data limits for refresh

    The maximum size for datasets imported into the Power BI service is 1 GB. These datasets are heavily compressed to ensure high performance. In addition, in shared capacity, the service places a limit on the amount of uncompressed data that is processed during refresh to 10 GB. This limit accounts for the compression, and therefore is much higher than 1 GB. Datasets in Power BI Premium are not subject to this limit. If refresh in the Power BI service fails for this reason, please reduce the amount of data being imported to Power BI and try again.

    and this leads us to believe that the problem no longer exists or you have other more pressing business priorities. If I do not hear to the contrary, I will close this incident tomorrow at close of business on 07/06/2017.

     

    If your database is over 1G,it may cause such problem while refreshing the data,as it will be highly uncompressed during refreshing which may result to be over 10 times the size of your database.

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!