Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Before creating a thread I have tried searching for previous threads that have been solved and none of them seems to fit to what i am having trouble with.
Simply i need to add a data source folder that contains csv files and connect them to power bi. The problem is however power bi is splitting all commas(default delimiter for csv) which makes all columns have commas split into parts. An example of this would look like
Name | Age | Blood Type | Address |
Frank | 21 | O | #2, someaddress, some city |
Jonathan | 22 | B- | antartica |
And power bi will split them to
Name | Age | Blood Type | Address |
Frank | 21 | O | #2 |
someaddress | |||
some city | |||
Jonathan | 22 | B- | antartica |
What do i need to do? Some of the solutions from different threads are from 3 years ago, and some steps do not work anymore.
you can set it before loading the csv on power bi,
You can choose which delimiter you are going to choose and there is also a preview of the data after choosing the delimiter you need
If you exporting it from some source then you can force the string to be enclosed in " or can use tab-delimited.
changing the delimiter to something else combines all columns into one
Column1
Name,Age,Blood Type,Address |
Frank,21,O,"#2, someaddress, some city" |
Jonathan,22,B-,antartica |
Then i still need to separate them based on the delimiter commas. It would look like this now.
Name | Age | Blood Type | Address |
Frank | 21 | O | #2, someaddress, some city |
Jonathan | 22 | B- | antartica |
Which yes, solves this problem IF we are talking about one file. If the data source contains more than one combining them also includes the headers and when you split them makes the problem worse.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |