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: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
286 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
217 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
199 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
200 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
218 Views

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

View All