Forum Discussion
Anonymous
7 years agoNot applicable
Dataflow size limit
I'm considering breaking one of my larger models into a series of Dataflows to improve the overall refresh performance of the model. I was wondering whether an individual dataflow had a size limit? A...
aldupler
7 years agoMicrosoft Employee
The biggest limit I've run into is refresh time out (2 hours). I'm running a lot of Native Queries against AAS. These run slow as it is, but my feeling is that dataflows are slower than a regular service refresh. As a result, I've broken up a big model into entities in 5-6 different dataflows in the same workspace. Then I just staggered the refresh of each by two hours over the course of the night. Now everything runs fine.
GilbertQ
7 years agoSuper User
Hi there
Yes extracting data out of AAS could potentially be very slow if you are using it as a data extraction tool with row by row data.
That will work with the staggering of dataflows refreshing.
Yes extracting data out of AAS could potentially be very slow if you are using it as a data extraction tool with row by row data.
That will work with the staggering of dataflows refreshing.