Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi.
I`ve figured out that I need to enable "ignore quoted line breaks" on CSV-import on the source I`ve got. Now I get the files automatically uploaded to a Sharepoint site, but adding a sharepoint folder I do not get the same option of ignoring line breaks.
Someone who knows about a work-around?
Solved! Go to Solution.
Hi @Nexans ,
To import 1 file with the options as indicated, next import the files from the folder and then adjust the relevant part of the generated code with the corresponding part of the code that was first generated for 1 file.
When importing files from a folder and combining them, you get several query objects.
The object that you should adjust is the query that transforms the example file, you can find at the location similar to this screenshot:
Please refer to this case.
Hi @Nexans ,
To import 1 file with the options as indicated, next import the files from the folder and then adjust the relevant part of the generated code with the corresponding part of the code that was first generated for 1 file.
When importing files from a folder and combining them, you get several query objects.
The object that you should adjust is the query that transforms the example file, you can find at the location similar to this screenshot:
Please refer to this case.
Thaks a lot.
And for future reference, it ic changing from QuoteStyle=QuoteStyle.None to QuoteStyle=QuoteStyle.Csv in advanced editor.
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |