Data Flow refresh failing

[ajaymanshani]

I have created a dataflow, that uses .csv files stored in Azure Blob Storage. There are around 50 csv files and I am combining them as I want to union the contents of the file. In the Transform Data window this seems to work fine and in the final step the unioned data is getting previewed. But when I am running the refresh, the refresh fails. 

In the error, I am getting only this -

Error:  Request ID: a683e9e7-922c-292a-3e65-c7506837179a Activity ID: 4bc14595-b8ec-4032-b2ff-82186c04eec7

[Anonymous]

Hi, @ajaymanshani 

Maybe you can try disabling Enable Load on all source entities in Power Query, just leave it enabled for the final merged table.

You can refer to the following post:

Solved: Data Refresh Fails When Report Merges Data Flow wi... - Microsoft Fabric Community

Solved: Dataflow refresh has failed in Power BI service - Microsoft Fabric Community

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Poojara_D12]

Hi @ajaymanshani 

The refresh failure may be due to the following reasons:

1. Ensure all CSVs have the same columns and data types.
2. Split large files and test again.
3. Check Power BI’s access to Azure Blob Storage.
4. Use the Activity ID to find detailed error logs.
5. Optimize transformations for better performance.

Did I answer your question? Mark my post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Poojara
Data Analyst | MSBI Developer | Power BI Consultant
Please Subscribe my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS 

[ajaymanshani]

Your answer is very general, sorry but didn't help.