Incremental Refresh with Merge Query

[HowardFrazier76]

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 

[v-stephen-msft · Accepted solution]

Hi @HowardFrazier76 ,

Check out this blog post. It provides the workaround for combined queries from several subqueries.

Incremental Refresh with Subqueries - Microsoft Power BI Community

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@HowardFrazier76 , As soon as you get the data, the first step after datatype change. You should insert the filter step using RangeStart and RangeEnd . Then check is allowing you to define incremental load on that table.

Parameter name should be same https://docs.microsoft.com/en-us/power-bi/admin/service-premium-incremental-refresh