Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
HowardFrazier76
Frequent Visitor

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 

1 ACCEPTED SOLUTION
v-stephen-msft
Community Support
Community Support

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.

View solution in original post

2 REPLIES 2
v-stephen-msft
Community Support
Community Support

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
Super User
Super User

@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

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.