Great videos, I love PQ in general, but I appreciate that you took time and idea to dedicate your skills into Excel Power Query!!! I hope you will do more and more videos, especially M-language coding or some "real-life" examples too.
This is awsome, I have a small problem, I tried with a csv file that is over 1M rows, and it states that every column type is text. Is there anything that can be done?
@jeromeastier462 What did you get when you use the auto detect data type from the UI? I'm trying to determine whether you need a clean-up step before data type.
The “detect data type” UI does return the column with a decimal number as a text. I tried with a sample csv file with 2 one record and three columns, and it still does not recognize the number a a number. When I force it by clicking on the left hand ABC column header then “1.2 decimal Number”, then it does transform it as a decimal. Could the problem be that at the source, all columns are labeled “text” - not undetermined as when it comes from an xlsx file?
@jeromeastoer462 there are few things that can potentially cause this issue. Happy for you to email me the sample CSV and I'll have a look at it instead of back and forth. Reach me out through LinkedIn.
![BLACK BAG - Official Trailer [HD] - Only in Theaters March 14](http://i.ytimg.com/vi/Du0Xp8WX_7I/mqdefault.jpg)
Great simple explanation
Thank you, @vacilando86. Glad you think so!
Thanks about your tutorial
the file simple can easy to follow step by step
practice
thanks very much
Glad it helped
Great videos, I love PQ in general, but I appreciate that you took time and idea to dedicate your skills into Excel Power Query!!! I hope you will do more and more videos, especially M-language coding or some "real-life" examples too.
Thank you mirr velll! I am more than happy to share a lot of more ideas how I use PQ in excel (definitely will cover M code)!
Great video, thanks so much even if I dont like this robotic voice..
Thank you for your feedback. Greatly appreciated 🙏
Another Brilliant video, very useful tip :)
Thank you Sumanth Sasidharan.
This is awsome, I have a small problem, I tried with a csv file that is over 1M rows, and it states that every column type is text. Is there anything that can be done?
@jeromeastier462 What did you get when you use the auto detect data type from the UI? I'm trying to determine whether you need a clean-up step before data type.
The “detect data type” UI does return the column with a decimal number as a text. I tried with a sample csv file with 2 one record and three columns, and it still does not recognize the number a a number. When I force it by clicking on the left hand ABC column header then “1.2 decimal Number”, then it does transform it as a decimal. Could the problem be that at the source, all columns are labeled “text” - not undetermined as when it comes from an xlsx file?
@jeromeastoer462 there are few things that can potentially cause this issue. Happy for you to email me the sample CSV and I'll have a look at it instead of back and forth. Reach me out through LinkedIn.
@@bsmart2gether408 thank you very much KT, much appreciated. Just want to add that your videos are stellar!
very rich, as usal
thanks for posting
Thank you Stefano. I have adjusted the the speed, focal point and structure. I hope it can be much easier to follow.
@@bsmart2gether408 yes indeed a much better experience, thanks for your help