Forum Discussion

HowardFrazier76's avatar
HowardFrazier76
Frequent Visitor
4 years ago
Solved

Incremental Refresh with Merge Query

I have a merged query that I made from two queries from the same table. I wrote two different queries from the same table but with different where statements where ID= A and then where ID=B the two different queries is because each query represents 2 differnet PDF forms that are submitted thru a web page and then the information from them is placed in this massive table. I used direct query to import them into Power Bi. Then merged them. The table I'm pulling from has over 87 million rows so the merges query takes time to refresh especially since the two queries are pull from this massive table. The refresh fails most of the time because it times out. I need to speed up the queries but I'm not sure if I need to set my parameters in thr first two queries or set it in the merge query in order to set up my incremental refresh 

2 Replies