Forum Discussion

MrMP's avatar
MrMP
Helper III
4 years ago
Solved

data flow csv from sharepoint folder doesnt work (encoding problem?)

Hi all,

 

I am trying to combine dozens of csv files that are stored on sharepoint folder using data flow. I did try it with Power Query and it worked nicely. Now with data flows I am getting weird characters and I have no idea why. csv is encoded in UTF-8.

Please see the screenshot below:

Thank you for your help!

Need Help
  • MrMP's avatar
    MrMP
    4 years ago

    I have changed the query completely now and tried combining it differently. Now everything works.

4 Replies

  • KNP's avatar
    KNP
    Super User
    4 years ago

    Are you able to post your full Power Query code?

    (mask any sensitive detail)

     

    • MrMP's avatar
      MrMP
      Helper III
      4 years ago

      I have changed the query completely now and tried combining it differently. Now everything works.

    • MrMP's avatar
      MrMP
      Helper III
      4 years ago

      That folder contains only csv, there are no zip files there.