Dataflow Gen2's BC connection failed : DataFomat.Error: There were more columns in result than expe

[Caroline_Jin]

I have  issues in Fabric Dataflow Gen2 , all my dataflow gen2 with Business Central all report the same error message:
"DataFomat.Error: There were more columns in the result than expected.(esion 1D: e7db0925-5aad-460d-9b08-a91a8047d5ca, Region: asia"

I tried to create a new connection with BC in Fabric Dataflow Gen2 ,  the error message change to invalid credential , but the same credential is working in Power BI Desktop - Power Query. 

hope someone know how to solve this issues . 

Thanks ! 

[v-venuppu]

Hi @Caroline_Jin ,

Thank you for confirming that the issue got resolved.

[v-venuppu]

Hi @Caroline_Jin ,

I wanted to check if you had a chance to raise a support ticket and resolve this issue? If so, please consider sharing the solution in the forum,this will help other members find the answer more easily.

Thank you.

[Caroline_Jin]

Hi all , 

Just on second day , seems Microsoft already fixed the issues . I didn't do anything , but all dataflows are working now... 

[v-venuppu]

Hi @Caroline_Jin ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @HL20 @Avinash-kb for the prompt response.

I would recommend to raise a support ticket with your region and error details so your case can be tracked under the incident by using the below link:
Create a Fabric and Power BI Support Ticket - Power BI | Microsoft Learn

[HL20]

I am experiencing the same issue - will check in to see if a resolution is found. Good luck!

[Avinash-kb]

Hi lots of our clients reported the same issue since this morning.

Apparently we have issue with PowerBi - Desktop as well.