Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi All
I have uploded a CSV file into a DataLake and created a table from it, but table columns values coming up differently from csv values:
CSV:
Site,FileUrl,Size,Created,Modified,Name,Author,Editor
SiteName1 , /sites/SiteName1/Shared Documents/Barclays/Contracts/BarclaysContract 2013.pdf , 2.48953819274902 , 08/11/2015 09:41:20 , 08/11/2015 09:41:20 , BarclaysContract 2013.pdf , ,
SiteName1 , /sites/SiteName1/Shared Documents/Barclays/Contracts/Barclays Client Contract.pdf , 3.56038379669189 , 08/11/2015 09:41:13 , 08/11/2015 09:41:13 , Barclays Client Contract.pdf , ,
DataLake table:
I know some file may contain commas and that could be cosing this issue, but majority are ok
Is there any way to sort it?
Thanks
Thanks for using the Microsoft Fabric Community.
I tried to repro the scenario with the same data and didn't find any difficulty in creating a table. Please find the screenshot for reference.
I would suggest you to create a new .csv file and try to create table.
If the issue still persists, please do let us know. Glad to help.
I hope this information helps.
Thank you.
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others.
Otherwise, will respond back with the more details and we will try to help.
Thanks.
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others .
If you have any question relating to the current thread, please do let us know and we will try out best to help you.
In case if you have any other question on a different issue, we request you to open a new thread.
Thanks.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
29 | |
15 | |
6 | |
6 | |
3 |
User | Count |
---|---|
50 | |
44 | |
15 | |
7 | |
6 |