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.
- GilbertQ7 years agoSuper UserHi 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.