Merging Tables Efficiency Question

[Calcul8or]

I had to download two tables (one table in two parts) from Google Analytics because of the 7 dimension limit Google imposes on all queries. I thought merging the two in PBI would be the best way to get around this limitation, and it seemed to work.......until I tried updating the merge.

3.14 BILLION rows of loaded data a few hours later, and it's still going!

Should I be concerned that something has gone horribly wrong with the query, cancel it, and try some other approach, or would it be better to just let it run it course?

Any help would seriously be appreciated.

[v-haibl-msft]

@Calcul8or

You can take a look at this thread for the merge performance. Maybe you can improve the performance with some suggestions there. 

There is also another workaround you can try, please refer to this article.

Best Regards,
Herbert