cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
olimilo
Helper V
Helper V

Help resolving dataflow query timeout

I have 2 dataflows containing tables from separate sources (Archives and Current) both whose sources are hosted on Sharepoint. We're trying to combine both dataflows into one dataflow and standardize the columns into one format. The Archives data should have about 10 years worth of data.

 

I pull a table each from the Archives and Current dataflows and try to combine them into 1 table in the Combined dataflow however at the 10 minute mark, the query timeouts and I am unable to proceed with validating the queries in the dataflow. Is there something I can do to fix this? Or a better way of doing this?

1 REPLY 1
lbendlin
Super User
Super User

Have you considered incremental refresh and bootstrapping of partitions? You can then refresh individual partitions independently.

Advanced incremental refresh with the XMLA endpoint in Power BI - Power BI | Microsoft Docs

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Kudoed Authors