Solved: Re: data flow csv from sharepoint folder doesnt wo...

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.
KIfp67uy-Sr

Proud to be a Super User!

MrMP · ‎01-24-2022

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

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

Helpful resources

NEW! Community Notebooks Gallery

Fabric Community Update - April 2025