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.  

Kevin8's avatar
Kevin8
Frequent Visitor
3 months ago

Unfortunately changing the workspace setting to a large semantic model, didn't fix the issue, and the report continues to fail when trying to refresh in service with the error message siting not enough memory.

I will try another round of to reducing the report in size.  

  • v-ssriganesh's avatar
    v-ssriganesh
    Community Support
    3 months ago

    Hello Kevin8,
    Thank you for the update.
    Reducing the report size is a good approach, and hopefully that helps resolve your issue.

    If you continue to experience the issue after making those changes, please let us know, we’ll be happy to assist further. Your update will be valuable to the community and may assist others with similar concerns.

    Thank you for being part of the Microsoft Fabric Community.