{"id":3776,"date":"2024-12-03T04:00:06","date_gmt":"2024-12-03T04:00:06","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/vo-hieu-hoa-chuc-nang-tu-phat-hien-kieu-du-lieu-trong-power-query-editor\/"},"modified":"2024-12-03T04:00:06","modified_gmt":"2024-12-03T04:00:06","slug":"vo-hieu-hoa-chuc-nang-tu-phat-hien-kieu-du-lieu-trong-power-query-editor","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/vo-hieu-hoa-chuc-nang-tu-phat-hien-kieu-du-lieu-trong-power-query-editor\/","title":{"rendered":"V\u00f4 hi\u1ec7u ho\u00e1 ch\u1ee9c n\u0103ng t\u1ef1 ph\u00e1t hi\u1ec7n ki\u1ec3u d\u1eef li\u1ec7u trong Power Query Editor"},"content":{"rendered":"
\n

Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch t\u1eaft t\u00ednh n\u0103ng t\u1ef1 ph\u00e1t hi\u1ec7n v\u00e0 nh\u1eadn d\u1ea1ng ki\u1ec3u d\u1eef li\u1ec7u trong Power Query Editor<\/a><\/strong>. T\u00ednh n\u0103ng n\u00e0y tuy kh\u00e1 h\u1eefu \u00edch, tuy nhi\u00ean trong m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p ta mu\u1ed1n t\u1ef1 tay m\u00ecnh quy \u0111\u1ecbnh ki\u1ec3u d\u1eef li\u1ec7u cho t\u1eebng tr\u01b0\u1eddng c\u1ee5 th\u1ec3 thay v\u00ec \u0111\u1ec3 Power Query Editor t\u1ef1 \u0111\u1ed9ng nh\u1eadn d\u1ea1ng. Trong m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p c\u00f3 th\u1ec3 vi\u1ec7c t\u1ef1 \u0111\u1ed9ng nh\u1eadn d\u1ea1ng n\u00e0y kh\u00f4ng ch\u00ednh x\u00e1c.<\/em><\/p>\n

Khi\u00a0nh\u1eadp d\u1eef li\u1ec7u v\u00e0o Power Query ho\u1eb7c khi th\u1ef1c hi\u1ec7n c\u00e1c thao t\u00e1c bi\u1ebfn \u0111\u1ed5i th\u00ec ngay sau \u0111\u00f3, n\u1ebfu b\u1ea1n ch\u01b0a t\u1eaft t\u00ednh n\u0103ng t\u1ef1 \u0111\u1ed9ng nh\u1eadn d\u1ea1ng ki\u1ec3u d\u1eef li\u1ec7u th\u00ec Power Query Editor t\u1ef1 \u0111\u1ed9ng nh\u1eadn d\u1ea1ng cho b\u1ea1n. \u0110i\u1ec1u n\u00e0y nhi\u1ec1u khi kh\u00f4ng c\u1ea7n thi\u1ebft l\u1eafm v\u00e0 l\u00e0m cho c\u00e1c b\u01b0\u1edbc trong Applied Steps c\u0169ng nh\u01b0 M \u2013 Code tr\u1edf n\u00ean d\u00e0i d\u00f2ng h\u01a1n nhi\u1ec1u.<\/p>\n

\"Power-Query-Editor-1\"<\/p>\n

S\u1ebd c\u00f3 l\u00fac b\u1ea1n s\u1ebd th\u1ea5y \u0111i\u1ec1u \u0111\u00f3 g\u00e2y phi\u1ec1n h\u00e0 cho m\u00ecnh v\u00e0 mu\u1ed1n t\u00ecm c\u00e1ch n\u00e0o \u0111\u00f3 \u0111\u1ec3 t\u1eaft \u0111i. Ta s\u1ebd l\u00e0m nh\u01b0 sau:<\/p>\n

B\u1ea1n v\u00e0o Query Options. N\u1ebfu b\u1ea1n d\u00f9ng Office 365 th\u00ec m\u1ee5c \u0111\u00f3 s\u1ebd n\u1eb1m \u1edf \u0111\u00e2y.<\/p>\n

\n

Data -> Get Data -> Query Options<\/strong><\/p>\n

\"Power-Query-Editor-2\"<\/p>\n<\/blockquote>\n

H\u1ed9p tho\u1ea1i Query Options<\/strong>\u00a0xu\u1ea5t hi\u1ec7n, b\u1ea1n t\u00ecm t\u1edbi m\u1ee5c Data Load<\/strong> trong nh\u00f3m Current Workbook.<\/strong><\/p>\n

T\u1ea1i ph\u1ea7n Type Detection<\/strong> b\u1ea1n b\u1ecf ch\u1ecdn Automatically detect column types and headers for unstructured sources.<\/em><\/p>\n

Power Query l\u00e0 g\u00ec? t\u1ea1i sao c\u1ea7n h\u1ecdc Power Query?<\/strong><\/em><\/a><\/p>\n

\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n
\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n

L\u1ea7n t\u1edbi khi b\u1ea1n t\u1ea1o truy v\u1ea5n, hay th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc bi\u1ebfn \u0111\u1ed5i d\u1eef li\u1ec7u trong Power Query Editor b\u1ea1n s\u1ebd kh\u00f4ng c\u00f2n th\u1ea5y b\u01b0\u1edbc\u00a0Changed Type<\/strong> t\u1ef1 \u0111\u1ed9ng n\u1eefa.<\/p>\n

\"Power-Query-Editor-3\"<\/p>\n

C\u0169ng t\u01b0\u01a1ng t\u1ef1 nh\u01b0 c\u1eeda s\u1ed5 Power Querry Editor trong Power BI. B\u1ea1n c\u0169ng v\u00e0o Options v\u00e0 t\u1eaft n\u00f3 \u0111i.\u00a0C\u1eeda s\u1ed5 Power Query Editor trong Power Query v\u00e0 Power BI s\u1ebd c\u00f3 m\u1ee5c \u0111\u00f3 gi\u1ed1ng nhau.<\/p>\n

Ch\u00fac b\u1ea1n th\u00e0nh c\u00f4ng!<\/strong><\/em><\/p>\n

Tham kh\u1ea3o c\u00e1c b\u00e0i vi\u1ebft kh\u00e1c li\u00ean quan<\/p>\n

\n

H\u01b0\u1edbng d\u1eabn c\u00e1ch c\u00e0i \u0111\u1eb7t power query trong excel 2010, 2013, 2016<\/a><\/strong><\/em><\/p>\n

H\u01b0\u1edbng d\u1eabn c\u00e1ch d\u00f9ng power query \u0111\u1ec3 l\u00e0m b\u00e1o c\u00e1o nh\u1eadp xu\u1ea5t t\u1ed3n kho tr\u00ean excel<\/a><\/strong><\/em><\/p>\n

H\u01b0\u1edbng d\u1eabn c\u00e1ch d\u00f9ng power query \u0111\u1ec3 t\u00e1i c\u1ea5u tr\u00fac d\u1eef li\u1ec7u kho<\/a><\/strong><\/em><\/p>\n

Chu\u1ea9n ho\u00e1 ki\u1ec3u d\u1eef li\u1ec7u \u201ckh\u00f3 \u0111\u1ee1\u201d v\u1edbi c\u00f4ng c\u1ee5 power query trong excel<\/a><\/strong><\/em><\/p>\n<\/div>\n

\n

Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n

T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0\ud83d\udcd6<\/span><\/a><\/p>\n

H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n

HKD H\u1ecdc Excel Online
S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n

\n

\u00a9 document.currentScript.insertAdjacentHTML(‘afterend’, ” + new Intl.DateTimeFormat(document.documentElement.lang, {year: ‘numeric’}).format() + ”); H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

\n
\n
\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":3777,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-3776","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3776","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=3776"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3776\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/3777"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=3776"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=3776"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=3776"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}