Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

In premium Gen2, getting error: database exceeds the maximum size limit on disk

Hi Community,

 

I'm getting an error when I'm trying to refresh my Power BI Dataset from the Service in a Premium P1 capacity with Gen2 activated.

 

The dataset has a size around 12GB (but the power bi file has a size of few MB as it contains only a subset of data, and the source is parameterized).

 

I have two workspaces (UAT, PROD: both in same capacity), for one it's working smoothly and for the other I'm getting this error.

 

Any help would be very appreciate.

 

Thanks

Need Help

4 Replies

  • selimovd's avatar
    selimovd
    Most Valuable Professional
    5 years ago

    Hey Anonymous ,

     

    what exactly is your data source?

    Try to use a relational database as SQL server. If that is already the case try to filter out the big chunks as a first step of your transformation. Does the query folding work to filter out the big chunk?

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     
    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi thanks for your reply. 

       

      I'm using parquet files stored in a datalake as a source, there is no query folding. But this is working fine in one workspace. And on the other I am getting this issue: 'Database xxx exceeds the maximum size limit on disk'.

       

      I saw the limitation of 12GB in import mode but Gen2 is removing this limitation right?