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

[sagittarius_111]

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.

[tayloramy]

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.

[miguel]

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

[sagittarius_111]

Yes it has to be done in Azure Data Factory

[tayloramy]

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.

[sagittarius_111 · Accepted solution]

Ok Thanks, will post in community for ADF