The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I created a new shortcut to get the CSV files from the Data Lake and then loaded into a table.
The issue I have is that the CSV files has a carriage return that is throwing off the position of the data loaded (column _c0 in the screenshot below). Any idea on how to remove the carriage return prior to loading into the table?
Hi @joelhtown80
Thanks for using Fabric Community.
You can use a Dataflow Gen2 for transforming the data before loading into a table. Please refer to the screenshots.
Create a new dataflow gen2. Upload the CSV file which you want to load into a table.
Click on the triangle button for the column which you want to replace the carriage return and click on replace values.
Leave the Replace with tab as empty. After clicking ok the carriage returns are replaced with none.
After doing the transformations, select a destination for the Dataflow Gen2 and publish it.
Hope this helps. Please let me know if you have any further queries.
Hi @joelhtown80
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. Otherwise, will respond back with the more details and we will try to help.
Thanks
My apologies, I was pulled into another project. But here is my feedback.
Instead of uploading the CSV, my source is from the Data Lake. I used the connection below.
Everything was looking fine except I get the error below when I try to publish the dataflow.
I changed all the data types to Text and re-publish but the error still persists.
Hi @joelhtown80
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. Otherwise, will respond back with the more details and we will try to help.
Thanks
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Fabric update to learn about new features.
User | Count |
---|---|
6 | |
3 | |
2 | |
2 | |
2 |
User | Count |
---|---|
27 | |
12 | |
8 | |
4 | |
4 |