Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
GharbiamalBI
New Member

Importat an CSV files to Power BI

‎08-07-2022 04:54 AM

Hello everyone, I imported a csv file from kaggle to power BI, IMG_20220806_221511.jpgexcept there are cells left with commas.

Labels:
Message 1 of 3
391 Views
0
2 ACCEPTED SOLUTIONS
jcalheir
Solution Supplier
Solution Supplier

‎08-08-2022 03:50 AM

Would you care to share kaggle csv file?

 

View solution in original post

Message 2 of 3
322 Views
OliT
Resolver I
Resolver I

‎08-10-2022 02:19 AM

Hi @GharbiamalBI 

>> except there are cells left with commas.

My suggestion is to split these lines separately. There is a function of splitting by punctuation in power query. After they are split, then merge them with other lines.


Regards,

OliT

View solution in original post

Message 3 of 3
304 Views
0
2 REPLIES 2
OliT
Resolver I
Resolver I

‎08-10-2022 02:19 AM

Hi @GharbiamalBI 

>> except there are cells left with commas.

My suggestion is to split these lines separately. There is a function of splitting by punctuation in power query. After they are split, then merge them with other lines.


Regards,

OliT

Message 3 of 3
305 Views
0
jcalheir
Solution Supplier
Solution Supplier

‎08-08-2022 03:50 AM

Would you care to share kaggle csv file?

 

Message 2 of 3
323 Views

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

View All