Possible to join 20 dimension tables to a fact table, from the same SQL Server database?

[David_Wong]

Hi @Niels2,

Did you create a separate dataset for your fact and dimension tables? When you join datasets in SPICE, each one is considered as its own source even if the underlying database for each one is the same.

I believe you’re hitting the same limitation that was discussed in these 2 topics:

Join tables releases error, due to exceed join memory, need to increase size of join

Hello All, could some one help on this please, this is very weird, how come join limit only 1GB? now we can’t reduce of join, or else if we remove it will breaks whole dashboard, how to increase join size to 10 GB, please error: QuickSight ran out of join memory while processing your request. To join between data sources, the smaller source tables combined can’t exceed the join memory limit of (1GB). The largest one, “accounts_users”, doesn’t count toward the memory limit. To…

Joining dataset is not allowed due to capacity[High Priority]

Hello I am trying to join two dataset in spice, and i keep getting the issue mentioned in the picture. Can you please advice on what should be done? Please note that I tried to filter one of the datasets before joining and it is still not working. Thanks [imit]