Forum Discussion
Solved
How to Ignore Csv quoted line breaks
Hi, I have a Power BI Report that connected to a Sharepoint folder with many CSV files. And I know I have a quoted line break issue and need to find out a way to ignore the quoted line break. I'v...
- Why are you not using the Combine feature of Power Query?
- Don't use SharePoint.Files here. It looks like you are getting files from 1 folder. Change SharePoint.Files() in the source line to SharePoint.Contents(). Navigate to the folder you need, then do a combine (or filter further to just keep the CSVs you need, then combine).
edhans
Community Champion
Community Champion- Why are you not using the Combine feature of Power Query?
- Don't use SharePoint.Files here. It looks like you are getting files from 1 folder. Change SharePoint.Files() in the source line to SharePoint.Contents(). Navigate to the folder you need, then do a combine (or filter further to just keep the CSVs you need, then combine).
Hi edhans ,
1. I've watched a video (https://www.youtube.com/watch?v=3GIz50pftZ0) and found out this way is much more clean and simple.
2. I can do that, but it will use Combine which I'm trying to avoid. Though I know it can solve my issue here. Anyway, it's an option. Thanks~
Wondering is there any other fix can be done without changing my Source line?
