topic Re: Need Guidance in migrating Excel Report ETL done through formulas to ADF Data Flow. in Dataflow

Need Guidance in migrating Excel Report ETL done through formulas to ADF Data Flow.

sagittarius_111 — Sat, 27 Sep 2025 07:10:41 GMT

Hello Everyone,

Kindly help me or share me tips for how to automate an excel report where the calculations/ ETL is being done in excel using formulas. I have to do that ETL in Azure Data Factory Data Flows, later to be visualised using Power BI.

I spefically need help in building the logic from Excel ETL done using excel formulas and convert it into ADF flow.

This is kind of report Automation being done and its my first Excel Report to Power BI Automation project. Any leads/ resources or tuitorials on any platform like youtube will be helpful.

Thank you.

Re: Need Guidance in migrating Excel Report ETL done through formulas to ADF Data Flow.

miguel — Sat, 27 Sep 2025 07:12:57 GMT

Does it necessarily need to be in Azure Data Factory? Or could you use Fabric Data Factory ?

Re: Need Guidance in migrating Excel Report ETL done through formulas to ADF Data Flow.

tayloramy — Sat, 27 Sep 2025 15:44:49 GMT

Hi sagittarius_111,

This forum is about Microsoft Fabric, not Azure Data Factory.

Do you have access to a Fabric capacity to build this in Fabric Data Factory?
If so we can help.
If not, I'd recommending checking on the Azure Data Community forum.

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.

Re: Need Guidance in migrating Excel Report ETL done through formulas to ADF Data Flow.

sagittarius_111 — Sun, 28 Sep 2025 03:24:34 GMT

Yes it has to be done in Azure Data Factory

Re: Need Guidance in migrating Excel Report ETL done through formulas to ADF Data Flow.

tayloramy — Sun, 28 Sep 2025 03:46:04 GMT

Hi sagittarius_111,

If you're looking for help with Azure Data Factory, please look on the Azure Data Community: https://www.microsoft.com/en-us/sql-server/community?activetab=pivot:sqlservertab

This forum is for Microsoft Fabric, and while there is some overlap, generally our focus is on Fabric, not Azure Data Factory.

I hope you find the support you are looking for over at the Azure Data Community.

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.

Re: Need Guidance in migrating Excel Report ETL done through formulas to ADF Data Flow.

sagittarius_111 — Sun, 28 Sep 2025 04:33:05 GMT

Ok Thanks, will post in community for ADF