Earlier, I was getting issues with SQL combiner, I turned off this setting and it went through but failed on partition-enabled datasets. Maybe this is the main reason? It could not combine queries from each partition.

Please, can you share the error message?