power BI dataflow refresh failed due to unknown error

Hi Nazirahmed1982,

The message you provided is from the refresh history? This error seems not related to the power query steps.
Can you please check below things?

1.Dataflow using any on-prem/cloud gateway connection? If yes weather the gateway status up and running when dataflow is refreshing.

2.On the same time frame any other dataflow running which using the same source?

for more clarifination can you provide the power query steps, So we can check more cearly.

Thanks, 

Yes Dataflow is using on-perm gateway and gateway up is online and up and running at the time and always on. No there is no other dataflow running at the same time which is using the same source.

I have only 2 steps in the power query. first step is a simple select query on the view and second step is data type coversion on a couple of ID columns to integer.

After refresh failure if we rerun it, then it scuceeds sometime. It fails random and succesds randomly.

Hi Nazirahmed1982,

We would like to confirm if our community members answer resolves your query or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are happy to help you.

Lodha_Jaydeep ,Thanks for your prompt response

Thank you for your patience and look forward to hearing from you.
Best Regards,
Prashanth Are
MS Fabric community support

Hi @Nazirahmed1982,

We would like to confirm if our community members answer resolves your query or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are happy to help you.

Thank you for your patience and look forward to hearing from you.
Best Regards,
Prashanth Are
MS Fabric community support

If this is blocking you we suggest, please consider raising a support ticket for further assistance.
To raise a support ticket for Fabric and Power BI, kindly follow the steps outlined in the following guide:

How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

We are following up once again regarding your query. Could you please confirm if the issue has been resolved through the support ticket with Microsoft?
If the issue has been resolved, we kindly request you to share the resolution or key insights here to help others in the community.
Should you need further assistance in the future, we encourage you to reach out via the Microsoft Fabric Community Forum and create a new thread. We’ll be happy to help.

Thank you for your understanding and participation.