How to ask Power Query to auto detect data types

preview_player
Показать описание
When we want to define the Data Types for our data, we can ask Power Query to auto-detect them. Usually, it does a good job. Then, it is our turn to review Power Query’s guess and amend any data type wrongly assigned if needed.



----------------------

Celia Alves - Microsoft MVP & Certified Excel Expert, Solutions Developer



Twitter: @celia_excel

Instagram: @solveandexcel


#excel #msexcel #powerquery #dataanalysis #snapreports #solveandexcel #automation #reportautomation #VBA

-------------------------

#Excel #shorts #solveandexcel #microsoft365 #toronto #torontobusiness #wit #msexcel #microsoftexcel #excelreport #excelautomation #snapreports #powerquery #canada
Рекомендации по теме
Комментарии
Автор

Just the perfect little reminder I needed. Thank you, Celia!

Slykklondon
Автор

Thank you very much, i so much needed this. short and right to the point, you are the best.

MoodFaka
welcome to shbcf.ru