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.  

cengizhanarslan's avatar
cengizhanarslan
Super User
4 months ago

Do you have Calculated Columns or Power Query transformation steps that disables native query option? If yes, even the refreshed datasets size is lower then the max limit, the size of the model coult exceed the max limit during the refresh process. Consider making all those transformations on the source level which is AWS in your case.

Kevin8's avatar
Kevin8
Frequent Visitor
4 months ago

Hi Cengizhanarslan,

I have shrunk the report as much as possible, to fold the data to the source so that the data transformations are done in the sql query and the power query steps are reduced as much as possible.

However, before I did this the error message was the same, the report was a fraction too big, and needed to be made slightly smaller to work.

After massively reducing the report size, the same error message occured. This leads me to conclude it is not a Power BI memory issue. The same error message is given regardless of the report size.

Any ideas?