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: 

Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.

Reply
adrien5555
Helper II
Helper II

Presence of a delimiter (comma) in a few values create a mess

‎05-10-2016 06:29 AM

Hello all,

 

My data sources are mainly CSV files, whose delimiter is a "comma"

 

If ever there are commas within the values, it creates a mess, as every value is then offset:

 

test.png

 

Surely, there is an easy way to fix this in PBI?

 

Many thanks,

Message 1 of 3
682 Views
0
2 REPLIES 2
asocorro
Skilled Sharer
Skilled Sharer

‎05-10-2016 10:59 AM

This would be a problem with any tool.  The comma is overloaded.  If possible, ask for TAB-delimited files, for example.

Connect with me in LinkedIn: https://pr.linkedin.com/in/adolfosocorro
Follow me on Twitter: https://twitter.com/AdolfoSocorro
Message 2 of 3
667 Views
0
adrien5555
Helper II
Helper II
In response to asocorro

‎05-11-2016 04:06 AM

Ok, but rather than having to edit this CSV in excel, isn't it possible to edit it right from PBI? 

 

Message 3 of 3
652 Views
0

Helpful resources

Announcements
PBIApril_Carousel

Power BI Monthly Update - April 2025

Check out the April 2025 Power BI update to learn about new features.

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

Find out what's new and trending in the Fabric community.

View All