Forum Discussion

Kevin8's avatar
Kevin8
Frequent Visitor
4 months ago
Solved

Problems with importing data from AWS Redshift

Hi everyone,   I have a Power BI Report called stored in a Power BI Workspace within my work organsiation. It is set to refresh weekly on Monday mornings. The refresh fails and the reason for th...
Need Help
  • tayloramy's avatar
    tayloramy
    4 months ago

    Hi Kevin8, 

     

    Switching to large semantic model storage might help. 

    Is your 11m row fact table a full load on refresh or is it incremental? If it is a full load, you may want to look at making it incremental.  

tayloramy's avatar
tayloramy
Super User
4 months ago

Hi Kevin8, 

 

According to the error your report is expanding to over 25GB during refresh. 

 

What type of workspace do you have? Is it a pro workspace, or a premium workspace attached to a capacity? If it is attached to a capacity, which capacity sku do you have?  

  • Kevin8's avatar
    Kevin8
    Frequent Visitor
    4 months ago

    Hi Tayloramy,

    The capacity SKU is F64. The workspace also says:

    Semantic model storage format Small semantic model storage format.