Forum Discussion

Caroline_Jin's avatar
Caroline_Jin
Frequent Visitor
9 months ago

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

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 ! 

Dataflow

6 Replies

  • Avinash-kb's avatar
    Avinash-kb
    New Member
    9 months ago

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

     

    Apparently we have issue with PowerBi - Desktop as well.

  • HL20's avatar
    HL20
    Frequent Visitor
    9 months ago

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

  • v-venuppu's avatar
    v-venuppu
    Community Support
    9 months ago

    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's avatar
      Caroline_Jin
      Frequent Visitor
      9 months ago

      Hi all , 

       

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