cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Calcul8or Frequent Visitor
Frequent Visitor

Merging Tables Efficiency Question

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.

1 REPLY 1
Highlighted
v-haibl-msft Super Contributor
Super Contributor

Re: Merging Tables Efficiency Question

@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