Solved: data flow csv from sharepoint folder doesnt work (...

MrMP · ‎01-22-2022

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!

MrMP · ‎01-24-2022

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

View solution in original post

lbendlin · ‎01-23-2022

This is a ZIP file, not a CSV.

MrMP · ‎01-24-2022

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

KNP · ‎01-23-2022

Are you able to post your full Power Query code?

(mask any sensitive detail)

Have I solved your problem?
Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;).

If you found this post helpful, please give Kudos.
It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen.
If you find my signature vaguely amusing, please give Kudos.