Forum Discussion
Error: Internal Error of Dataflow
Super UserHey Anonymous ,
Is the third dataflow using a different Data Source? Or different Gateway? Are both of those correctly configured? Is this an error after a long time (like maybe you are timiing out)?
Hi,
Q: Is the third dataflow using a different Data Source? Or different Gateway?
Ans: Basically the 3rd dataflow are combining the table from 3 excels files into single table. The excels are located on the same sharepoint destination using my connection.
Q: Are both of those correctly configured?
Ans: Subject to my above answer, I guess both of them are correctly configured. Please advice if it is not.
Q: Is this an error after a long time (like maybe you are timiing out)?
Ans: Yes, the refresh tooks very long period (more than 2 hours).
Do you have idea the root cause subject to the above response??
- collinq
Hey Anonymous ,
I am betting the issue is the third one - the time limit. There is a 2 hour time limit on refreshes with a Pro license. I am wondering if you can maybe get the three files separately? Or, make your query more efficient somehow? Or, maybe make the source file smaller (ie. if it is a lot of years of data and you only need the last 5 then trim the source before you try to hit it).
But, I think that is the first place to look - to get the refresh time under 2 hours. Preferrably way under 2 hours so that if the data grows a bit you aren't in the same position quickly.