Can't combine two tables using amazon redshift

[mbudis]

Hi All, 

I would like to ask related error below, so my objective is to combine two tables A and B, using Append Queries as New with a granular column, is same here is my error 

Thanks.

Regards,

Budi 

[mbudis]

Hi Rita, 

Thanks for your quick reply, it quite englighting right now.

Thanks.

Regards,

Budi 

[Ritaf1983 · Accepted solution]

Hi @mbudis 

Based on the error message, it looks like your data model or query exceeds Power BI’s memory limits, which is common when importing large or granular datasets.

Here are some suggestions to consider:

Reduce Query Complexity:
Simplify the queries – remove unused columns or rows early in the query steps to reduce memory load.

Pre-Join in Redshift:
Instead of appending tables A and B in Power BI, consider creating a view or staging table in Redshift to combine them first.

Remove Duplicates and Unnecessary Data:
Apply filters early and make sure you’re not importing more data than needed.

Consider Moving to DirectQuery Mode:
If you're currently using Import mode, switching to DirectQuery can help offload processing to Redshift and avoid memory pressure in Power BI.

Model Optimization:

If your model is heavily normalized, consider denormalizing it and using a star schema.

Review relationships and avoid bi-directional filtering where not needed.

Open a Support Ticket (Optional):
If the issue persists, consider raising a support ticket with Microsoft and sharing a stripped-down version of the model for troubleshooting.

It's hard to give an exact fix without seeing your data model or query structure, but these are the most common ways to resolve such issues.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickl