{"id":1684,"date":"2024-12-02T05:49:18","date_gmt":"2024-12-02T05:49:18","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/power-query-thay-doi-vi-tri-du-lieu-nguon\/"},"modified":"2024-12-02T05:49:18","modified_gmt":"2024-12-02T05:49:18","slug":"power-query-thay-doi-vi-tri-du-lieu-nguon","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/power-query-thay-doi-vi-tri-du-lieu-nguon\/","title":{"rendered":"Power Query \u2013 Thay \u0111\u1ed5i v\u1ecb tr\u00ed d\u1eef li\u1ec7u Ngu\u1ed3n"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-h4k0Fa0I#1\">\n<p><em><span style=\"font-weight: 400\">L\u00e0m th\u1ebf n\u00e0o b\u1ea1n c\u00f3 th\u1ec3 <a href=\"http:\/\/blog.ezworkapp.com\/power-query-thay-doi-vi-tri-du-lieu-nguon.html\"><strong>thay \u0111\u1ed5i c\u00e1c truy v\u1ea5n d\u1eef li\u1ec7u<\/strong><\/a> \u0111\u1ec3 tr\u1ecf \u0111\u1ebfn ngu\u1ed3n tr\u1ef1c ti\u1ebfp, thay v\u00ec d\u1eef li\u1ec7u m\u1eabu? Trong b\u00e0i vi\u1ebft n\u00e0y, <strong>H\u1ecdc Excel Online<\/strong> s\u1ebd c\u00f9ng b\u1ea1n tr\u1ea3 l\u1eddi c\u00e2u h\u1ecfi tr\u00ean b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/power-query-la-gi-tai-sao-can-hoc-power-query.html\"><strong>Power Query<\/strong><\/a><\/span><\/em><\/p>\n<p><span style=\"font-weight: 400\">Gi\u1ed1ng nh\u01b0 h\u1ea7u h\u1ebft m\u1ecdi th\u1ee9 trong Excel, \u0111\u1ec3 \u0111\u1ea1t \u0111\u01b0\u1ee3c \u0111i\u1ec1u n\u00e0y s\u1ebd c\u00f3 nhi\u1ec1u c\u00e1ch:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Thay \u0111\u1ed5i v\u1ecb tr\u00ed trong m\u00e3 M trong truy v\u1ea5n<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">S\u1eed d\u1ee5ng c\u00e0i \u0111\u1eb7t Ngu\u1ed3n d\u1eef li\u1ec7u(<\/span><span style=\"font-weight: 400\">Data source settings)<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">S\u1eed d\u1ee5ng c\u00e1c tham s\u1ed1<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">C\u00f2n ch\u1ea7n ch\u1edd g\u00ec n\u1eefa, b\u1eaft \u0111\u1ea7u th\u00f4i!<\/span><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-674d4a5dbb000\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/power-query-thay-doi-vi-tri-du-lieu-nguon.html#Thay_doi_vi_tri_nguon_trong_truy_van_du_lieu\" title=\"Thay \u0111\u1ed5i v\u1ecb tr\u00ed ngu\u1ed3n trong truy v\u1ea5n d\u1eef li\u1ec7u\">Thay \u0111\u1ed5i v\u1ecb tr\u00ed ngu\u1ed3n trong truy v\u1ea5n d\u1eef li\u1ec7u<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/power-query-thay-doi-vi-tri-du-lieu-nguon.html#Su_dung_Data_Source_settingscai_dat_nguon_du_lieu\" title=\"S\u1eed d\u1ee5ng Data Source settings(c\u00e0i \u0111\u1eb7t ngu\u1ed3n d\u1eef li\u1ec7u)\">S\u1eed d\u1ee5ng Data Source settings(c\u00e0i \u0111\u1eb7t ngu\u1ed3n d\u1eef li\u1ec7u)<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/power-query-thay-doi-vi-tri-du-lieu-nguon.html#Su_dung_cac_tham_so\" title=\"S\u1eed d\u1ee5ng c\u00e1c tham s\u1ed1\">S\u1eed d\u1ee5ng c\u00e1c tham s\u1ed1<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Thay_doi_vi_tri_nguon_trong_truy_van_du_lieu\"><\/span><b>Thay \u0111\u1ed5i v\u1ecb tr\u00ed ngu\u1ed3n trong truy v\u1ea5n d\u1eef li\u1ec7u<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">B\u01b0\u1edbc \u0111\u1ea7u ti\u00ean \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng trong h\u1ea7u h\u1ebft c\u00e1c truy v\u1ea5n d\u1eef li\u1ec7u l\u00e0 x\u00e1c \u0111\u1ecbnh d\u1eef li\u1ec7u ngu\u1ed3n. V\u1ec1 m\u1eb7t k\u1ef9 thu\u1eadt th\u00ec n\u00f3 kh\u00f4ng nh\u1ea5t thi\u1ebft ph\u1ea3i nh\u01b0 v\u1eady v\u00e0 n\u00f3 c\u0169ng kh\u00f4ng c\u1ea7n ph\u1ea3i \u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 Ngu\u1ed3n. Tuy nhi\u00ean, trong h\u1ea7u h\u1ebft c\u00e1c tr\u01b0\u1eddng h\u1ee3p th\u1ef1c t\u1ebf, n\u00f3 s\u1ebd ph\u1ea3i nh\u01b0 th\u1ebf. L\u00e0 th\u1ee9 \u0111\u1ea7u ti\u00ean l\u00e0m cho m\u00e3 M tr\u1edf n\u00ean d\u1ec5 t\u00ecm gi\u1ed1ng nh\u01b0 n\u00f3 lu\u00f4n \u1edf l\u00fac b\u1eaft \u0111\u1ea7u \ud83d\ude09<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u1ea2nh ch\u1ee5p m\u00e0n h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y cho th\u1ea5y b\u01b0\u1edbc \u0111\u1ea7u ti\u00ean trong truy v\u1ea5n d\u1eef li\u1ec7u v\u1edbi m\u00e3 M s\u1ebd \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb trong Thanh c\u00f4ng th\u1ee9c(<\/span><span style=\"font-weight: 400\">Formula Bar)<\/span><span style=\"font-weight: 400\">. N\u1ebfu Thanh C\u00f4ng th\u1ee9c kh\u00f4ng hi\u1ec3n th\u1ecb, b\u1ea1n c\u00f3 th\u1ec3 nh\u1ea5p v\u00e0o <\/span><b>View -&gt; Formula Bar<\/b><span style=\"font-weight: 400\"> trong menu Power Query.<\/span><\/p>\n<figure id=\"attachment_34606\" aria-describedby=\"caption-attachment-34606\" style=\"width: 899px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34606 size-full\" title=\"1- Thay \u0111\u1ed5i v\u1ecb tr\u00ed d\u1eef li\u1ec7u ngu\u1ed3n - power query\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h1-5.png\" alt=\"1- Thay \u0111\u1ed5i v\u1ecb tr\u00ed d\u1eef li\u1ec7u ngu\u1ed3n - power query\" width=\"899\" height=\"286\"><figcaption id=\"caption-attachment-34606\" class=\"wp-caption-text\">1- Thay \u0111\u1ed5i v\u1ecb tr\u00ed d\u1eef li\u1ec7u ngu\u1ed3n \u2013 power query<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Ch\u00fang ta c\u00f3 th\u1ec3 ch\u1ec9nh s\u1eeda m\u00e3 tr\u1ef1c ti\u1ebfp ngay trong Thanh c\u00f4ng th\u1ee9c, b\u1ea1n ch\u1ec9 c\u1ea7n cung c\u1ea5p v\u1ecb tr\u00ed t\u1ec7p m\u1edbi d\u01b0\u1edbi d\u1ea1ng chu\u1ed7i v\u0103n b\u1ea3n.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Ch\u00fang ta c\u0169ng c\u00f3 t\u00f9y ch\u1ecdn ch\u1ec9nh s\u1eeda m\u00e3 trong <\/span><span style=\"font-weight: 400\">Advanced Editor<\/span><span style=\"font-weight: 400\">, nh\u1ea5p v\u00e0o <\/span><b>Home -&gt; Advanced Editor<\/b><span style=\"font-weight: 400\"> ho\u1eb7c <\/span><b>View -&gt; Advanced Editor<\/b><span style=\"font-weight: 400\"> (xem \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh b\u00ean d\u01b0\u1edbi).<\/span><\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-122.gif\" title=\"ex101_92019-nho-122\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<figure id=\"attachment_34607\" aria-describedby=\"caption-attachment-34607\" style=\"width: 899px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34607 size-full\" title=\"2-power query - thay \u0111\u1ed5i v\u1ecb tr\u00ed d\u1eef li\u1ec7u ngu\u1ed3n\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h2-4.png\" alt=\"2-power query - thay \u0111\u1ed5i v\u1ecb tr\u00ed d\u1eef li\u1ec7u ngu\u1ed3n\" width=\"899\" height=\"414\"><figcaption id=\"caption-attachment-34607\" class=\"wp-caption-text\">2-power query \u2013 thay \u0111\u1ed5i v\u1ecb tr\u00ed d\u1eef li\u1ec7u ngu\u1ed3n<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Th\u1ee9 ba, nh\u1ea5p v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng b\u00e1nh r\u0103ng b\u00ean c\u1ea1nh b\u01b0\u1edbc <\/span><b>Source<\/b> <span style=\"font-weight: 400\">trong ng\u0103n <\/span><b>Applied Steps<\/b><span style=\"font-weight: 400\"> \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i ngu\u1ed3n. Trong v\u00ed d\u1ee5 n\u00e0y, S\u1ed5 l\u00e0m vi\u1ec7c Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng l\u00e0m ngu\u1ed3n, v\u00ec v\u1eady h\u00e3y b\u1ea5m <\/span><b>Browse <\/b><span style=\"font-weight: 400\">\u0111\u1ec3 \u0111i\u1ec1u h\u01b0\u1edbng \u0111\u1ebfn v\u1ecb tr\u00ed t\u1ec7p m\u1edbi, sau \u0111\u00f3 b\u1ea5m <\/span><b>OK<\/b><span style=\"font-weight: 400\">.<\/span><\/p>\n<figure id=\"attachment_34608\" aria-describedby=\"caption-attachment-34608\" style=\"width: 789px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34608 size-full\" title=\"3-power query - thay \u0111\u1ed5i v\u1ecb tr\u00ed d\u1eef li\u1ec7u ngu\u1ed3n\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h3-4.png\" alt=\"3-power query - thay \u0111\u1ed5i v\u1ecb tr\u00ed d\u1eef li\u1ec7u ngu\u1ed3n\" width=\"789\" height=\"291\"><figcaption id=\"caption-attachment-34608\" class=\"wp-caption-text\">3-power query \u2013 thay \u0111\u1ed5i v\u1ecb tr\u00ed d\u1eef li\u1ec7u ngu\u1ed3n<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">T\u00f9y thu\u1ed9c v\u00e0o lo\u1ea1i ngu\u1ed3n m\u00e0 h\u1ed9p tho\u1ea1i s\u1ebd thay \u0111\u1ed5i, nh\u01b0ng c\u00e1c nguy\u00ean t\u1eafc c\u01a1 b\u1ea3n \u0111\u1ec1u gi\u1ed1ng nhau.<\/span><\/p>\n<p><span style=\"font-weight: 400\">C\u00f3 l\u1ebd b\u1ea1n \u0111\u00e3 th\u1ea5y k\u1ef9 thu\u1eadt thay \u0111\u1ed5i Ngu\u1ed3n \u0111\u00e3 c\u00f3 trong tuy\u1ec3n t\u1eadp Power Query n\u00e0y, c\u1ee5 th\u1ec3 h\u01a1n l\u00e0 trong b\u00e0i <\/span><b><i>nh\u1eadp d\u1eef li\u1ec7u t\u1eeb Web<\/i><\/b><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Su_dung_Data_Source_settingscai_dat_nguon_du_lieu\"><\/span><b>S\u1eed d\u1ee5ng Data Source settings(c\u00e0i \u0111\u1eb7t ngu\u1ed3n d\u1eef li\u1ec7u)<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">Trong tr\u01b0\u1eddng h\u1ee3p c\u00f3 nhi\u1ec1u truy v\u1ea5n d\u1eef li\u1ec7u \u0111\u1ebfn t\u1eeb c\u00f9ng m\u1ed9t ngu\u1ed3n, c\u00f3 m\u1ed9t c\u00e1ch t\u1ed1t h\u01a1n \u0111\u1ec3 \u0111\u1eb7t l\u1ea1i d\u1eef li\u1ec7u ngu\u1ed3n \u0111\u00f3 l\u00e0 c\u00e0i \u0111\u1eb7t Ngu\u1ed3n d\u1eef li\u1ec7u. Trong th\u1ef1c t\u1ebf, \u0111\u00e2y c\u00f3 th\u1ec3 n\u00f3i l\u00e0 c\u00e1ch t\u1ed1t nh\u1ea5t.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Trong tr\u00ecnh so\u1ea1n th\u1ea3o Power Query, nh\u1ea5p v\u00e0o <\/span><b>Home -&gt; Data Source settings<\/b><\/p>\n<figure id=\"attachment_34609\" aria-describedby=\"caption-attachment-34609\" style=\"width: 901px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34609 size-full\" title=\"4-power query - thay \u0111\u1ed5i v\u1ecb tr\u00ed d\u1eef li\u1ec7u ngu\u1ed3n\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h4-5.png\" alt=\"4-power query - thay \u0111\u1ed5i v\u1ecb tr\u00ed d\u1eef li\u1ec7u ngu\u1ed3n\" width=\"901\" height=\"135\"><figcaption id=\"caption-attachment-34609\" class=\"wp-caption-text\">4-power query \u2013 thay \u0111\u1ed5i v\u1ecb tr\u00ed d\u1eef li\u1ec7u ngu\u1ed3n<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Trong c\u1eeda s\u1ed5 <\/span><span style=\"font-weight: 400\">Data Source settings<\/span><span style=\"font-weight: 400\"> (c\u00e0i \u0111\u1eb7t Ngu\u1ed3n d\u1eef li\u1ec7u), ch\u1ecdn ngu\u1ed3n m\u00e0 ch\u00fang ta mu\u1ed1n thay \u0111\u1ed5i, sau \u0111\u00f3 nh\u1ea5p v\u00e0o n\u00fat <\/span><b>Change Source<\/b><span style=\"font-weight: 400\"> \u2026<\/span><\/p>\n<figure id=\"attachment_34610\" aria-describedby=\"caption-attachment-34610\" style=\"width: 903px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34610 size-full\" title=\"5-power query - thay \u0111\u1ed5i v\u1ecb tr\u00ed d\u1eef li\u1ec7u ngu\u1ed3n\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h5-5.png\" alt=\"5-power query - thay \u0111\u1ed5i v\u1ecb tr\u00ed d\u1eef li\u1ec7u ngu\u1ed3n\" width=\"903\" height=\"422\"><figcaption id=\"caption-attachment-34610\" class=\"wp-caption-text\">5-power query \u2013 thay \u0111\u1ed5i v\u1ecb tr\u00ed d\u1eef li\u1ec7u ngu\u1ed3n<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Thao t\u00e1c n\u00e0y s\u1ebd hi\u1ec3n th\u1ecb c\u00f9ng m\u1ed9t c\u1eeda s\u1ed5 gi\u1ed1ng nh\u01b0 khi nh\u1ea5p v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng b\u00e1nh r\u0103ng (nh\u01b0 ch\u00fang ta \u0111\u00e3 th\u1ea5y tr\u01b0\u1edbc \u0111\u00f3).<\/span><\/p>\n<figure id=\"attachment_34611\" aria-describedby=\"caption-attachment-34611\" style=\"width: 789px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34611 size-full\" title=\"6-power query - thay \u0111\u1ed5i v\u1ecb tr\u00ed d\u1eef li\u1ec7u ngu\u1ed3n\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h6-5.png\" alt=\"6-power query - thay \u0111\u1ed5i v\u1ecb tr\u00ed d\u1eef li\u1ec7u ngu\u1ed3n\" width=\"789\" height=\"291\"><figcaption id=\"caption-attachment-34611\" class=\"wp-caption-text\">6-power query \u2013 thay \u0111\u1ed5i v\u1ecb tr\u00ed d\u1eef li\u1ec7u ngu\u1ed3n<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Tuy nhi\u00ean, c\u00f3 m\u1ed9t s\u1ef1 kh\u00e1c bi\u1ec7t quan tr\u1ecdng; thay v\u00ec thay \u0111\u1ed5i ngu\u1ed3n cho m\u1ed9t truy v\u1ea5n duy nh\u1ea5t, n\u00f3 c\u00f3 th\u1ec3 thay \u0111\u1ed5i ngu\u1ed3n cho t\u1ea5t c\u1ea3 c\u00e1c truy v\u1ea5n s\u1eed d\u1ee5ng ngu\u1ed3n \u0111\u00f3.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Data Source settings c\u00f2n<\/span><span style=\"font-weight: 400\"> c\u00f3 s\u1eb5n \u1edf c\u00e1c v\u1ecb tr\u00ed kh\u00e1c trong Excel v\u00e0 Power Query, nh\u01b0ng c\u00e1 nh\u00e2n m\u00ecnh th\u1ea5y \u0111\u00e2y l\u00e0 c\u00e0i \u0111\u1eb7t d\u1ec5 nh\u1edb nh\u1ea5t.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Su_dung_cac_tham_so\"><\/span><b>S\u1eed d\u1ee5ng c\u00e1c tham s\u1ed1<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">N\u1ebfu b\u1ea1n bi\u1ebft v\u1ecb tr\u00ed d\u1eef li\u1ec7u ngu\u1ed3n s\u1ebd thay \u0111\u1ed5i th\u00ec c\u00e1ch t\u1ed1t nh\u1ea5t l\u00fac n\u00e0y \u0111\u00f3 l\u00e0 t\u1ea1o m\u1ed9t Tham s\u1ed1. M\u1ed9t \u00f4 tr\u00ean trang t\u00ednh c\u00f3 th\u1ec3 ch\u1ee9a m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n v\u1edbi v\u1ecb tr\u00ed c\u1ee7a ngu\u1ed3n d\u1eef li\u1ec7u. Chu\u1ed7i v\u0103n b\u1ea3n n\u00e0y c\u00f3 th\u1ec3 l\u00e0 \u0111\u01b0\u1eddng d\u1eabn th\u01b0 m\u1ee5c, t\u00ean t\u1ec7p, t\u00ean b\u1ea3ng ho\u1eb7c \u0111\u1ecba ch\u1ec9 web SharePoint, v.v. \u0110\u1ec3 s\u1eafp x\u1ebfp l\u1ea1i truy v\u1ea5n, d\u1ec5 d\u00e0ng nh\u01b0 thay \u0111\u1ed5i chu\u1ed7i v\u0103n b\u1ea3n.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Ch\u00fang ta \u0111\u00e3 nhi\u1ec1u l\u1ea7n th\u1ea5y Power Query m\u00e3 h\u00f3a c\u00e1c gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n th\u00e0nh m\u00e3 M, v\u00ec v\u1eady s\u1eed d\u1ee5ng c\u00e1c tham s\u1ed1 l\u00e0 m\u1ed9t c\u00e1ch ti\u1ebfp c\u1eadn r\u1ea5t linh ho\u1ea1t. V\u00ec ch\u00fang ta \u0111\u00e3 tr\u00ecnh b\u00e0y <strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-dua-du-lieu-ve-dang-chuan-voi-power-query-trong-excel.html\">c\u00e1c th\u00f4ng s\u1ed1 Power Query<\/a><\/strong> trong m\u1ed9t b\u00e0i vi\u1ebft kh\u00e1c n\u00ean m\u00ecnh s\u1ebd kh\u00f4ng l\u1eb7p l\u1ea1i quy tr\u00ecnh \u1edf \u0111\u00e2y n\u1eefa.<br \/>\n<em>C\u00e1c b\u1ea1n th\u1ea5y \u0111\u1ea5y, <strong>Power Query<\/strong> \u0111\u00e3 t\u1ecf ra r\u1ea5t h\u1eefu \u00edch trong vi\u1ec7c truy v\u1ea5n d\u1eef li\u1ec7u tr\u1ecf \u0111\u1ebfn ngu\u1ed3n tr\u1ef1c ti\u1ebfp thay v\u00ec d\u1eef li\u1ec7u m\u1eabu. B\u00e0i h\u1ecdc h\u00f4m nay xin \u0111\u01b0\u1ee3c k\u1ebft th\u00fac t\u1ea1i \u0111\u00e2y. <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> xin ch\u00fac c\u00e1c b\u1ea1n th\u00e0nh th\u1ea1o Power Query cho m\u1ee5c \u0111\u00edch c\u1ee7a m\u00ecnh.\u00a0<\/em><\/span><\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-122.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":1685,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1684","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\/1684","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=1684"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/1684\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/1685"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=1684"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=1684"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=1684"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}