Forum Discussion

Calcul8or's avatar
Calcul8or
Frequent Visitor
9 years ago

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.

APIS and Embedding
Data Modeling

1 Reply

  • v-haibl-msft's avatar
    v-haibl-msft
    Microsoft Employee
    9 years ago

    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