[Mapping Data Flow] 0 Total columns - Source Excel - Bug Found

Question

Hi
My source is excel and I am trying to read the data in MDF Azure Data factory.
I am able to preview the data. But the count is display as Columns : 0 total.

I checked and tried with the options given in this thread:
https://social.msdn.microsoft.com/Forums/en-US/52c1b832-fad8-42b0-a53d-c24de4b953c1/mapping-data-flow-0-total-columns?forum=AzureDataFactory
But no luck.

Please check and assist.

Answer 1

Hello @Madhanlal Vannu ,

Thanks for posting the question and welcome to Microsoft Q & A .

I think I was able to repro the issue but that only happens for me when the worksheet name is not selected .
Please find the details in the image , hope this helps .

In case if you are still facing the can you please, please help us with more info .

1.Are you reading a single worksheet ? If yes how many records does that have .

2.Can it be possible to share some dummy data , so we can investigate this further . Please send an email to email to AzCommunity@microsoft.com with the below details. We will respond to the thread with our findings.

Thread URL :https://learn.microsoft.com/en-us/answers/questions/71311/mapping-data-flow-0-total-columns-source-excel.html
Subscription ID: 
Subject:Attention : Himanshu

Thanks Himanshu
Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members

Answer 2

They're actively answering Power Automate questions in dedicated forums here.
https://powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

--please don't forget to Accept as answer if the reply is helpful--

Answer 3

You can report bugs here.
https://feedback.azure.com/forums/223579-azure-portal/category/129061-bugs

--please don't forget to Accept as answer if the reply is helpful--