cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
chinnapan_ma
Frequent Visitor

Error: Internal Error of Dataflow

Hi,

 

Currently, I am working on dataflows.

My 2/3 dataflows can be refreshed perfectly.

 

However, one of them cannot be refreshed. even I am trying to do the first refresh (refresh now) there is error like below.

"Error: Internal error Request ID: a76ee73d-2e6b-e6e6-37ec-cdb42fa7d5aa Activity ID: 8f483eba-e4e2-4fce-8266-897b522b049d"

I would like to understand the root cause of this error. So I can figure out the way to mitigate this problem.


Suggestions appreciated.

 

4 REPLIES 4
chinnapan_ma
Frequent Visitor

Hey, @collinq 

 

Thank you so much for your suggestion. I will split it into 3 flows as per your suggestion! 🙂

collinq
Super User
Super User

Hey @chinnapan_ma ,

 

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)?




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




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??

Hey @chinnapan_ma ,

 

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.




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors