Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello,
One of the column I imported from my data source (CSV) is in Euro and has the following format when I open it via Excel:
FINAL_QUOTE |
46.88 |
144.69 |
63.54 |
20.63 |
8.9 |
32.24 |
8.9 |
8.9 |
When I open the Query Editor, I find my column without any dot:
FINAL_QUOTE |
4688 |
14469 |
6354 |
2063 |
89 |
3224 |
89 |
89 |
Do you have a solution to avoid that dots disappear? Or to re-add a dot in Power BI (but I'm afraid it's not possible as there isn't always two decimals so we can't decide to add a dot before the last 2 figures)?
Thanks a lot for your help,
thimremy
Solved! Go to Solution.
You probably have non-english regional settings right?
It happens for example when you have german CSV where delimiter is Semicolon but decimal seperator whould be comma but in your file its dot. Then he does not auto detect that.
Solution is when using GET DATA Text/Csv in the following window on Data Type Detection select "Do not detect data types"
then it is imported as text and you can change it in Query Editor.
You probably have non-english regional settings right?
It happens for example when you have german CSV where delimiter is Semicolon but decimal seperator whould be comma but in your file its dot. Then he does not auto detect that.
Solution is when using GET DATA Text/Csv in the following window on Data Type Detection select "Do not detect data types"
then it is imported as text and you can change it in Query Editor.
Hello cs_kit,
Thanks for the piece of advise, it worked!
Have a nice day,
thimremy
User | Count |
---|---|
121 | |
69 | |
67 | |
57 | |
50 |
User | Count |
---|---|
176 | |
83 | |
69 | |
65 | |
54 |