Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

PBIX Size problems vs embedded premium capacity

  I have a PBIX size of 1,048,000 KB.    I had difficluty publishing the PBIX to a premium capacity backed workspace on A1 tier and had to scale up to  A2 (limit 5 GB RAM).     Here is the error in ...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    5 years ago

    Hi Anonymous ,

     

    1. The possible reason is that your dataset will exceed 1GB after refreshing, so the dataet refresh failed.

    2. For A1, there is indeed a 1GB limitation.

    Datasets in Import mode 

     

    Best regards,
    Lionel Chen

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

     

Eugene_Ov's avatar
Eugene_Ov
Helper I
5 years ago

Anonymous I managed to deal with this using XMLA read-write, in two steps:

Process database -> Process Clear

Process database -> Process Full

 

This method has some disadvantages: during this process, you'll have dataset with no data. I also experienced some connectivity issues when Full processing ended with timeout error. 

 

Additionally, you could try another solution: automate SKU tier raising before processing the cube and downgrading after it's finished.

 

Eugene