Forum Discussion

Alirezam's avatar
Alirezam
Icon for Helper V rankHelper V
5 years ago

Combining file sin dataflow receiving this error "we didn't recognize the format..."

Hi there,

I am trying to combine some attachments coming through emails in .csv format. I have no issue using on-premise Power Query to aggregate and read them but in 'dataflow' I keep getting this alarm and cannot combine the files. I am sure I filter the right extensions. Any idea what is wrong here with dataflow?

Thanks

Need Help

2 Replies

  • v-jingzhang's avatar
    v-jingzhang
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi Alirezam 

     

    I also met this issue before. My workaround is to combine the attachment files in the on-premises Power Query Editor first, then copy and paste the combined query into the dataflow. In this way, I can save and use the dataflow. You could have a try.

     

    Reference: Workaround to the problem in the dataflow – “We did not recognize the format of your first file”

     

    Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as the solution to help other members find it.

  • v-jingzhang's avatar
    v-jingzhang
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi Alirezam 

     

    Does my reply solve your problem? If yes, kindly accept it as the solution. Otherwise you could post your own solution to help other community members who may have similar questions. Thanks.

     

    Regards,
    Community Support Team _ Jing