{"id":3064,"date":"2024-12-02T09:58:05","date_gmt":"2024-12-02T09:58:05","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/power-query-nhap-du-lieu-tu-web\/"},"modified":"2024-12-02T09:58:05","modified_gmt":"2024-12-02T09:58:05","slug":"power-query-nhap-du-lieu-tu-web","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/power-query-nhap-du-lieu-tu-web\/","title":{"rendered":"Power Query \u2013 Nh\u1eadp d\u1eef li\u1ec7u t\u1eeb Web"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-h4k0Fa0I#1\">\n<p><span style=\"font-weight: 400\"><em>Web l\u00e0 m\u1ed9t kho ch\u1ee9a th\u00f4ng tin c\u1ef1c k\u1ef3 \u0111\u1ed3 s\u1ed9. Tuy nhi\u00ean, vi\u1ec7c l\u1ea5y d\u1eef li\u1ec7u kh\u00f4ng ph\u1ea3i l\u00fac n\u00e0o c\u0169ng d\u1ec5 d\u00e0ng\u00a0 Trong b\u00e0i vi\u1ebft n\u00e0y,<a href=\"http:\/\/blog.ezworkapp.com\/\"><strong> H\u1ecdc Excel Online <\/strong><\/a>s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch ch\u00fang ta c\u00f3 th\u1ec3 <a href=\"http:\/\/blog.ezworkapp.com\/power-query-nhap-du-lieu-tu-web.html\"><strong>nh\u1eadp d\u1eef li\u1ec7u t\u1eeb web v\u00e0o Power Query.<\/strong><\/a><\/em> <\/span><\/p>\n<p><span style=\"font-weight: 400\">C\u00f3 th\u1ec3 b\u1ea1n s\u1ebd th\u1ea5y kh\u00e1 ph\u1ea5n kh\u00edch v\u1edbi \u00fd ngh\u0129 thu th\u1eadp d\u1eef li\u1ec7u t\u1eeb m\u1ecdi n\u01a1i ch\u1ec9 b\u1eb1ng m\u1ed9t c\u00fa nh\u1ea5p chu\u1ed9t, nh\u01b0ng th\u1ef1c s\u1ef1 th\u00ec kh\u00f4ng h\u1eb3n. <a href=\"http:\/\/blog.ezworkapp.com\/power-query-la-gi-tai-sao-can-hoc-power-query.html\"><strong>Power Query<\/strong><\/a> c\u00f3 th\u1ec3 l\u00e0m \u0111\u01b0\u1ee3c nhi\u1ec1u vi\u1ec7c, nh\u01b0ng trang web ph\u1ea3i \u1edf \u0111\u1ecbnh d\u1ea1ng h\u1ee3p l\u00fd m\u1edbi s\u1eed d\u1ee5ng \u0111\u01b0\u1ee3c.<\/span><\/p>\n<p><span style=\"font-weight: 400\">H\u00e3y b\u1eaft \u0111\u1ea7u nh\u1eadp m\u1ed9t s\u1ed1 d\u1eef li\u1ec7u t\u1eeb web.<\/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-674d84ac1c8f9\" 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-nhap-du-lieu-tu-web.html#Nhap_web_co_ban\" title=\"Nh\u1eadp web c\u01a1 b\u1ea3n\">Nh\u1eadp web c\u01a1 b\u1ea3n<\/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-nhap-du-lieu-tu-web.html#Chinh_sua_truy_van\" title=\"Ch\u1ec9nh s\u1eeda truy v\u1ea5n\">Ch\u1ec9nh s\u1eeda truy v\u1ea5n<\/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-nhap-du-lieu-tu-web.html#Su_dung_cac_tham_so_voi_truy_van_tu_web\" title=\"S\u1eed d\u1ee5ng c\u00e1c tham s\u1ed1 v\u1edbi truy v\u1ea5n t\u1eeb web\">S\u1eed d\u1ee5ng c\u00e1c tham s\u1ed1 v\u1edbi truy v\u1ea5n t\u1eeb web<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/power-query-nhap-du-lieu-tu-web.html#Su_dung_cong_thuc_tuy_chinhcustom_formulas\" title=\"S\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c t\u00f9y ch\u1ec9nh(custom formulas)\">S\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c t\u00f9y ch\u1ec9nh(custom formulas)<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/power-query-nhap-du-lieu-tu-web.html#Tao_chuc_nang\" title=\"T\u1ea1o ch\u1ee9c n\u0103ng\">T\u1ea1o ch\u1ee9c n\u0103ng<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/power-query-nhap-du-lieu-tu-web.html#Su_dung_chuc_nang\" title=\"S\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng\">S\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/power-query-nhap-du-lieu-tu-web.html#Nhap_nhieu_trang_web\" title=\"Nh\u1eadp nhi\u1ec1u trang web\">Nh\u1eadp nhi\u1ec1u trang web<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/power-query-nhap-du-lieu-tu-web.html#Mot_vai_canh_bao\" title=\"M\u1ed9t v\u00e0i c\u1ea3nh b\u00e1o\">M\u1ed9t v\u00e0i c\u1ea3nh b\u00e1o<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Nhap_web_co_ban\"><\/span><b>Nh\u1eadp web c\u01a1 b\u1ea3n<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">V\u1edbi m\u1ee5c \u0111\u00edch c\u1ee7a b\u00e0i vi\u1ebft, ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng https:\/\/www.xe.com \u0111\u1ec3 nh\u1eadp t\u1ef7 gi\u00e1 h\u1ed1i \u0111o\u00e1i (<\/span><span style=\"font-weight: 400\">exchange rates) <\/span><span style=\"font-weight: 400\">v\u00e0o Power Query.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Trang web n\u00e0y hi\u1ec3n th\u1ecb t\u1ef7 gi\u00e1 h\u1ed1i \u0111o\u00e1i cho b\u1ea5t k\u1ef3 lo\u1ea1i ti\u1ec1n t\u1ec7 n\u00e0o v\u00e0o b\u1ea5t k\u1ef3 ng\u00e0y n\u00e0o. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 t\u1ef7 gi\u00e1 USD cho ng\u00e0y 1 th\u00e1ng 7 n\u0103m 2019.<\/span><\/p>\n<figure id=\"attachment_34634\" aria-describedby=\"caption-attachment-34634\" style=\"width: 735px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34634 size-full\" title=\"1-power query - Nh\u1eadp d\u1eef li\u1ec7u t\u1eeb web\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h1-7.png\" alt=\"1-power query - Nh\u1eadp d\u1eef li\u1ec7u t\u1eeb web\" width=\"735\" height=\"666\"><figcaption id=\"caption-attachment-34634\" class=\"wp-caption-text\">1-power query \u2013 Nh\u1eadp d\u1eef li\u1ec7u t\u1eeb web<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Ph\u1ea7n \u0111\u00e1ng ch\u00fa \u00fd nh\u1ea5t trong \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh \u1edf tr\u00ean l\u00e0 URL. N\u1ebfu b\u1ea1n nh\u00ecn k\u1ef9, n\u00f3 ch\u1ee9a m\u00e3 ti\u1ec1n t\u1ec7 v\u00e0 ng\u00e0y th\u00e1ng trong URL. Hmmm\u2026 M\u00ecnh t\u1ef1 h\u1ecfi li\u1ec7u ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng n\u00f3 theo c\u00e1ch n\u00e2ng cao h\u01a1n kh\u00f4ng?<\/span><\/p>\n<p style=\"text-align: center\"><span style=\"font-weight: 400\">https:\/\/www.xe.com\/currencytables\/?from=<\/span><b>USD<\/b><span style=\"font-weight: 400\">&amp;date=<\/span><b>2019-07-01<\/b><\/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-232.gif\" title=\"ex101_92019-nho-232\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><span style=\"font-weight: 400\">Tuy nhi\u00ean tr\u01b0\u1edbc khi b\u1eaft \u0111\u1ea7u n\u00e2ng cao h\u01a1n, h\u00e3y b\u1eaft \u0111\u1ea7u t\u1eeb nh\u1eefng \u0111i\u1ec1u c\u01a1 b\u1ea3n. Sao ch\u00e9p URL, sau \u0111\u00f3 trong Excel nh\u1ea5p v\u00e0o <\/span><b>Data -&gt; Get Data -&gt; From Other Sources -&gt; From Web<\/b><\/p>\n<figure id=\"attachment_34635\" aria-describedby=\"caption-attachment-34635\" style=\"width: 774px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34635 size-full\" title=\"2-power query - Nh\u1eadp d\u1eef li\u1ec7u t\u1eeb web\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h2-6.png\" alt=\"2-power query - Nh\u1eadp d\u1eef li\u1ec7u t\u1eeb web\" width=\"774\" height=\"665\"><figcaption id=\"caption-attachment-34635\" class=\"wp-caption-text\">2-power query \u2013 Nh\u1eadp d\u1eef li\u1ec7u t\u1eeb web<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">C\u1eeda s\u1ed5 From Web s\u1ebd m\u1edf ra. D\u00e1n URL m\u00e0 ch\u00fang ta \u0111\u00e3 sao ch\u00e9p tr\u01b0\u1edbc \u0111\u00f3 v\u00e0o h\u1ed9p URL v\u00e0 nh\u1ea5p v\u00e0o OK.<\/span><\/p>\n<figure id=\"attachment_34636\" aria-describedby=\"caption-attachment-34636\" style=\"width: 705px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34636 size-full\" title=\"3-power query - Nh\u1eadp d\u1eef li\u1ec7u t\u1eeb web\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h3-6.png\" alt=\"3-power query - Nh\u1eadp d\u1eef li\u1ec7u t\u1eeb web\" width=\"705\" height=\"255\"><figcaption id=\"caption-attachment-34636\" class=\"wp-caption-text\">3-power query \u2013 Nh\u1eadp d\u1eef li\u1ec7u t\u1eeb web<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">C\u1eeda s\u1ed5 ti\u1ebfp theo xu\u1ea5t hi\u1ec7n s\u1ebd l\u00e0 c\u1eeda s\u1ed5 <\/span><b>Navigator<\/b><span style=\"font-weight: 400\">. V\u00ec c\u00e1c b\u1ea3ng t\u1eeb c\u00e1c trang web c\u00f3 th\u1ec3 c\u00f3 quy \u01b0\u1edbc \u0111\u1eb7t t\u00ean k\u00e9m, n\u00ean kh\u00f4ng ph\u1ea3i l\u00fac n\u00e0o ch\u00fang ta c\u0169ng nh\u1eadn bi\u1ebft \u0111\u01b0\u1ee3c b\u1ea3ng n\u00e0o. Ch\u00fang ta ph\u1ea3i nh\u1ea5p qua t\u1eebng c\u00e1i cho \u0111\u1ebfn khi t\u00ecm \u0111\u01b0\u1ee3c c\u00e1i m\u00e0 ch\u00fang ta mu\u1ed1n. Khi b\u1ea1n \u0111\u00e3 t\u00ecm th\u1ea5y b\u1ea3ng ph\u00f9 h\u1ee3p, h\u00e3y nh\u1ea5p v\u00e0o <\/span><b>Transform Data<\/b><span style=\"font-weight: 400\">.<\/span><\/p>\n<figure id=\"attachment_34637\" aria-describedby=\"caption-attachment-34637\" style=\"width: 811px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34637 size-full\" title=\"4-power query - Nh\u1eadp d\u1eef li\u1ec7u t\u1eeb web\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h4-7.png\" alt=\"4-power query - Nh\u1eadp d\u1eef li\u1ec7u t\u1eeb web\" width=\"811\" height=\"411\"><figcaption id=\"caption-attachment-34637\" class=\"wp-caption-text\">4-power query \u2013 Nh\u1eadp d\u1eef li\u1ec7u t\u1eeb web<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Khi t\u1ea3i Power Query Editor, n\u00f3 s\u1ebd ch\u1ee9a t\u1ea5t c\u1ea3 d\u1eef li\u1ec7u ti\u1ec1n t\u1ec7.<\/span><\/p>\n<figure id=\"attachment_34638\" aria-describedby=\"caption-attachment-34638\" style=\"width: 690px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34638 size-full\" title=\"5-power query - Nh\u1eadp d\u1eef li\u1ec7u t\u1eeb web\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h5-7.png\" alt=\"5-power query - Nh\u1eadp d\u1eef li\u1ec7u t\u1eeb web\" width=\"690\" height=\"246\"><figcaption id=\"caption-attachment-34638\" class=\"wp-caption-text\">5-power query \u2013 Nh\u1eadp d\u1eef li\u1ec7u t\u1eeb web<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Ti\u1ebfp theo h\u00e3y \u0111\u1eb7t t\u00ean h\u1eefu \u00edch cho truy v\u1ea5n, ch\u1eb3ng h\u1ea1n nh\u01b0 FXRates<\/span><\/p>\n<p><span style=\"font-weight: 400\">Nh\u1ea5p v\u00e0o <\/span><b>Home -&gt; Close and Load<\/b><span style=\"font-weight: 400\"> \u0111\u1ec3 \u0111\u1ea9y d\u1eef li\u1ec7u v\u00e0o Excel. Th\u1eadt d\u1ec5 d\u00e0ng \u0111\u00fang kh\u00f4ng?<\/span><\/p>\n<figure id=\"attachment_34639\" aria-describedby=\"caption-attachment-34639\" style=\"width: 655px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34639 size-full\" title=\"6-power query - Nh\u1eadp d\u1eef li\u1ec7u t\u1eeb web\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h6-7.png\" alt=\"6-power query - Nh\u1eadp d\u1eef li\u1ec7u t\u1eeb web\" width=\"655\" height=\"291\"><figcaption id=\"caption-attachment-34639\" class=\"wp-caption-text\">6-power query \u2013 Nh\u1eadp d\u1eef li\u1ec7u t\u1eeb web<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">N\u1ebfu trang web ch\u1ee9a d\u1eef li\u1ec7u tr\u1ef1c ti\u1ebfp, n\u00f3 s\u1ebd c\u1eadp nh\u1eadt truy v\u1ea5n v\u1edbi d\u1eef li\u1ec7u tr\u1ef1c ti\u1ebfp \u0111\u00f3 m\u1ed7i khi ch\u00fang ta nh\u1ea5p v\u00e0o l\u00e0m m\u1edbi. \u0110\u00f3 l\u00e0 c\u00f4ng c\u1ee5 kh\u00e1 m\u1ea1nh m\u1ebd.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Chinh_sua_truy_van\"><\/span><b>Ch\u1ec9nh s\u1eeda truy v\u1ea5n<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">B\u00e2y gi\u1edd ch\u00fang ta h\u00e3y ch\u1ec9nh s\u1eeda truy v\u1ea5n \u0111\u1ec3 s\u1eed d\u1ee5ng n\u00f3 cho c\u00e1c ng\u00e0y v\u00e0 \u0111\u01a1n v\u1ecb ti\u1ec1n t\u1ec7 kh\u00e1c nhau (khi th\u1ef1c hi\u1ec7n vi\u1ec7c n\u00e0y, ch\u00fang ta s\u1ebd g\u1eb7p l\u1ed7i c\u1ea7n s\u1eeda; m\u00ecnh s\u1ebd gi\u00fap b\u1ea1n x\u1eed l\u00fd n\u00f3).<\/span><\/p>\n<p><span style=\"font-weight: 400\">Trong Excel, b\u1ea5m <\/span><b>Data -&gt; Queries and Connections<\/b><\/p>\n<figure id=\"attachment_34640\" aria-describedby=\"caption-attachment-34640\" style=\"width: 775px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34640 size-full\" title=\"7- Nh\u1eadp d\u1eef li\u1ec7u power query\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h7-6.png\" alt=\"7- Nh\u1eadp d\u1eef li\u1ec7u power query\" width=\"775\" height=\"139\"><figcaption id=\"caption-attachment-34640\" class=\"wp-caption-text\">7- Nh\u1eadp d\u1eef li\u1ec7u power query<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">B\u1ea5m \u0111\u00fap v\u00e0o truy v\u1ea5n trong ng\u0103n Queries &amp; Connections \u0111\u1ec3 m\u1edf tr\u00ecnh so\u1ea1n th\u1ea3o Power Query.<\/span><\/p>\n<figure id=\"attachment_34641\" aria-describedby=\"caption-attachment-34641\" style=\"width: 380px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34641 size-full\" title=\"8- Nh\u1eadp d\u1eef li\u1ec7u power query\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h8-6.png\" alt=\"8- Nh\u1eadp d\u1eef li\u1ec7u power query\" width=\"380\" height=\"183\"><figcaption id=\"caption-attachment-34641\" class=\"wp-caption-text\">8- Nh\u1eadp d\u1eef li\u1ec7u power query<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Tr\u00ecnh ch\u1ec9nh s\u1eeda Power Query s\u1ebd m\u1edf l\u1ea1i, nh\u1ea5p v\u00e0o b\u01b0\u1edbc Source trong <\/span><i><span style=\"font-weight: 400\">Applied Steps<\/span><\/i><span style=\"font-weight: 400\">. URL \u0111\u01b0\u1ee3c m\u00e3 h\u00f3a v\u00e0o truy v\u1ea5n. L\u00fac n\u00e0y h\u00e3y ch\u1ec9nh s\u1eeda m\u00e3 M trong thanh c\u00f4ng th\u1ee9c, thay \u0111\u1ed5i truy v\u1ea5n \u0111\u1ec3 bao g\u1ed3m m\u1ed9t \u0111\u01a1n v\u1ecb ti\u1ec1n t\u1ec7 kh\u00e1c v\u00e0 m\u1ed9t ng\u00e0y kh\u00e1c. \u0110\u1ed1i v\u1edbi v\u00ed d\u1ee5 c\u1ee7a ch\u00fang ta, m\u00ecnh \u0111\u00e3 ch\u1ecdn EUR v\u00e0 ng\u00e0y 1 th\u00e1ng 1 n\u0103m 2019.<\/span><\/p>\n<p><span style=\"font-weight: 400\">M\u00e3 M sau:<\/span><\/p>\n<p><span style=\"font-weight: 400\">= Web.Page(Web.Contents(\u201chttps:\/\/www.xe.com\/currencytables\/?from=<\/span><b>USD<\/b><span style=\"font-weight: 400\">&amp;date=<\/span><b>2019-07-01<\/b><span style=\"font-weight: 400\">\u201c))<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u0111\u1ed5i th\u00e0nh<\/span><\/p>\n<p><span style=\"font-weight: 400\">= Web.Page(Web.Contents(\u201chttps:\/\/www.xe.com\/currencytables\/?from=<\/span><b>EUR<\/b><span style=\"font-weight: 400\">&amp;date=<\/span><b>2019-01-01<\/b><span style=\"font-weight: 400\">\u201c))<\/span><\/p>\n<p><span style=\"font-weight: 400\">Nh\u1ea5p qua c\u00e1c b\u01b0\u1edbc c\u00f2n l\u1ea1i c\u1ee7a truy v\u1ea5n. B\u01b0\u1edbc Thay \u0111\u1ed5i Lo\u1ea1i (<\/span><span style=\"font-weight: 400\">Changed Type step)<\/span><span style=\"font-weight: 400\"> s\u1ebd hi\u1ec3n th\u1ecb l\u1ed7i sau.<\/span><\/p>\n<figure id=\"attachment_34642\" aria-describedby=\"caption-attachment-34642\" style=\"width: 710px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34642 size-full\" title=\"9- Nh\u1eadp d\u1eef li\u1ec7u power query\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h9-5.png\" alt=\"9- Nh\u1eadp d\u1eef li\u1ec7u power query\" width=\"710\" height=\"127\"><figcaption id=\"caption-attachment-34642\" class=\"wp-caption-text\">9- Nh\u1eadp d\u1eef li\u1ec7u power query<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Nh\u00ecn v\u00e0o m\u00e3 M trong Thanh C\u00f4ng th\u1ee9c b\u1ea1n s\u1ebd th\u1ea5y c\u00f3 c\u00e1c tham chi\u1ebfu c\u1ee5 th\u1ec3 \u0111\u1ebfn \u0111\u01a1n v\u1ecb ti\u1ec1n t\u1ec7 USD trong ti\u00eau \u0111\u1ec1 (xem c\u00e1c ph\u1ea7n \u0111\u01b0\u1ee3c \u0111\u00e1nh d\u1ea5u m\u00e0u \u0111\u1ecf b\u00ean d\u01b0\u1edbi).<\/span><\/p>\n<p><span style=\"font-weight: 400\">= Table.TransformColumnTypes(Data0,{{\u201cCurrency code \u25b2\u25bc\u201d, type text},\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">{\u201cCurrency name \u25b2\u25bc\u201d, type text}, {\u201c<\/span><b>Units per USD<\/b><span style=\"font-weight: 400\">\u201c, type number}, {\u201c<\/span><b>USD per Unit<\/b><span style=\"font-weight: 400\">\u201c, type number}})<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u01a1n v\u1ecb ti\u1ec1n t\u1ec7 \u0111\u00e3 ch\u1ecdn c\u1ee7a ch\u00fang ta hi\u1ec7n l\u00e0 EUR; ti\u00eau \u0111\u1ec1 c\u1ed9t s\u1ebd tr\u1edf th\u00e0nh <\/span><i><span style=\"font-weight: 400\">Units per EUR<\/span><\/i><span style=\"font-weight: 400\"> v\u00e0 <\/span><i><span style=\"font-weight: 400\">EUR per Unit.<\/span><\/i><\/p>\n<p><span style=\"font-weight: 400\">S\u1ef1 thay \u0111\u1ed5i trong ti\u00eau \u0111\u1ec1 c\u1ed9t \u0111\u1ebfn tr\u1ef1c ti\u1ebfp t\u1eeb trang web ngu\u1ed3n; do \u0111\u00f3 ch\u00fang ta kh\u00f4ng th\u1ec3 l\u00e0m g\u00ec \u0111\u1ec3 ng\u0103n ch\u1eb7n n\u00f3. Tuy nhi\u00ean, c\u00f3 nh\u1eefng \u0111i\u1ec1u ch\u00fang ta c\u00f3 th\u1ec3 gi\u1ea3i quy\u1ebft v\u1ea5n \u0111\u1ec1.<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">X\u00f3a b\u01b0\u1edbc <\/span><i><span style=\"font-weight: 400\">Change Type<\/span><\/i><span style=\"font-weight: 400\"> \u0111ang g\u00e2y ra l\u1ed7i.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Gi\u1ea3m h\u1ea1ng ti\u00eau \u0111\u1ec1 xu\u1ed1ng h\u00e0ng \u0111\u1ea7u ti\u00ean b\u1eb1ng c\u00e1ch nh\u1ea5p v\u00e0o <\/span><b>Transform -&gt; User First Row as Headers (dropdown) -&gt; Use Headers as First Row<\/b><span style=\"font-weight: 400\">.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">X\u00f3a h\u00e0ng tr\u00ean c\u00f9ng b\u1eb1ng c\u00e1ch nh\u1ea5p v\u00e0o <\/span><b>Home -&gt; Remove Rows -&gt; Remove Top Rows<\/b><span style=\"font-weight: 400\">. Nh\u1eadp 1 v\u00e0o h\u1ed9p Number, b\u1ea5m OK.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Nh\u1eadp c\u00e1c t\u00ean c\u1ed9t ph\u00f9 h\u1ee3p theo c\u00e1ch th\u1ee7 c\u00f4ng (Ta \u0111\u00e3 s\u1eed d\u1ee5ng <\/span><span style=\"font-weight: 400\">Code, Currency, Rate and Inverted Rate<\/span><span style=\"font-weight: 400\">).<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\u00c1p d\u1ee5ng c\u00e1c lo\u1ea1i d\u1eef li\u1ec7u ph\u00f9 h\u1ee3p cho t\u1eebng c\u1ed9t (Ta \u0111\u00e3 s\u1eed d\u1ee5ng <\/span><span style=\"font-weight: 400\">Text, Text, Decimal, Decimal)<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">C\u1eeda s\u1ed5 Xem tr\u01b0\u1edbc b\u00e2y gi\u1edd tr\u00f4ng gi\u1ed1ng nh\u01b0 sau:<\/span><\/p>\n<figure id=\"attachment_34643\" aria-describedby=\"caption-attachment-34643\" style=\"width: 587px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34643 size-full\" title=\"10- Nh\u1eadp d\u1eef li\u1ec7u power query\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h10-5.png\" alt=\"10- Nh\u1eadp d\u1eef li\u1ec7u power query\" width=\"587\" height=\"236\"><figcaption id=\"caption-attachment-34643\" class=\"wp-caption-text\">10- Nh\u1eadp d\u1eef li\u1ec7u power query<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">B\u1ea5m <\/span><b>Close &amp; Load<\/b><span style=\"font-weight: 400\"> \u0111\u1ec3 \u0111\u1ea9y truy v\u1ea5n v\u00e0o Excel. B\u00e2y gi\u1edd ch\u00fang ta c\u00f3 th\u1ec3 thay \u0111\u1ed5i \u0111\u01a1n v\u1ecb ti\u1ec1n t\u1ec7 v\u00e0 ng\u00e0y th\u00e1ng trong URL ngu\u1ed3n, ngh\u0129a l\u00e0 ch\u00fang ta c\u00f3 th\u1ec3 nh\u1eadn \u0111\u01b0\u1ee3c t\u1ef7 gi\u00e1 cho b\u1ea5t k\u1ef3 ng\u00e0y n\u00e0o ch\u00fang ta mu\u1ed1n.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Su_dung_cac_tham_so_voi_truy_van_tu_web\"><\/span><b>S\u1eed d\u1ee5ng c\u00e1c tham s\u1ed1 v\u1edbi truy v\u1ea5n t\u1eeb web<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">Vi\u1ec7c ch\u1ec9nh s\u1eeda m\u00e3 M m\u1ed7i khi ch\u00fang ta mu\u1ed1n nh\u1eadp c\u00e1c ng\u00e0y v\u00e0 t\u1ef7 l\u1ec7 kh\u00e1c nhau kh\u00f4ng ph\u1ea3i l\u00e0 l\u00fd t\u01b0\u1edfng hay. Vi\u1ec7c n\u00e0y t\u1ed1n kh\u00e1 nhi\u1ec1u th\u1eddi gian, ngo\u00e0i ra ch\u00fang ta kh\u00f4ng bi\u1ebft ch\u1eafc r\u1eb1ng nh\u1eefng ng\u01b0\u1eddi d\u00f9ng kh\u00e1c kh\u00f4ng bi\u1ebft g\u00ec v\u1ec1 Power Query c\u1eadp nh\u1eadt b\u01b0\u1edbc n\u00e0y c\u00f3 ch\u00ednh x\u00e1c hay kh\u00f4ng.<\/span><\/p>\n<p><span style=\"font-weight: 400\">N\u1ebfu b\u1ea1n \u0111ang theo d\u00f5i lo\u1ea1t b\u00e0i vi\u1ebft v\u1ec1 Power Query n\u00e0y, b\u1ea1n s\u1ebd nh\u1edb r\u1eb1ng tr\u01b0\u1edbc \u0111\u00e2y ch\u00fang ta \u0111\u00e3<strong><a href=\"http:\/\/blog.ezworkapp.com\/power-query-chuc-nang-tuy-chinh.html\"> t\u1ea1o c\u00e1c tham s\u1ed1 \u0111\u1ec3 qu\u1ea3n l\u00fd c\u00e1c bi\u1ebfn<\/a>.<\/strong> N\u1ebfu th\u1eed \u0111i\u1ec1u n\u00e0y v\u1edbi c\u00e1c truy v\u1ea5n web, ch\u00fang ta s\u1ebd g\u1eb7p m\u1ed9t l\u1ed7i l\u1ea1 (xem \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh b\u00ean d\u01b0\u1edbi).<\/span><\/p>\n<figure id=\"attachment_34644\" aria-describedby=\"caption-attachment-34644\" style=\"width: 787px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34644 size-full\" title=\"11- Nh\u1eadp d\u1eef li\u1ec7u power query\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h11-4.png\" alt=\"11- Nh\u1eadp d\u1eef li\u1ec7u power query\" width=\"787\" height=\"63\"><figcaption id=\"caption-attachment-34644\" class=\"wp-caption-text\">11- Nh\u1eadp d\u1eef li\u1ec7u power query<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Nh\u01b0ng \u0111\u1eebng lo l\u1eafng, v\u1eabn c\u00f2n m\u1ed9t c\u00e1ch kh\u00e1c \u0111\u1ec3 s\u1eed d\u1ee5ng c\u00e1c \u00f4 tr\u00ean b\u1ea3ng t\u00ednh \u0111\u1ec3 truy xu\u1ea5t th\u00f4ng tin ch\u00fang ta mu\u1ed1n.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Su_dung_cong_thuc_tuy_chinhcustom_formulas\"><\/span><b>S\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c t\u00f9y ch\u1ec9nh(<\/b><span style=\"font-weight: 400\">custom formulas)<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">Trong m\u1ed9t b\u00e0i vi\u1ebft tr\u01b0\u1edbc, ch\u00fang ta \u0111\u00e3 k\u1ebft h\u1ee3p t\u1ea5t c\u1ea3 c\u00e1c t\u1ec7p t\u1eeb m\u1ed9t th\u01b0 m\u1ee5c. \u0110\u1ec3 \u0111\u1ea1t \u0111\u01b0\u1ee3c \u0111i\u1ec1u n\u00e0y, ch\u00fang ta \u0111\u00e3 s\u1eed d\u1ee5ng h\u00e0m Excel.Workbook () \u0111\u1ec3 k\u1ebft h\u1ee3p b\u1ea5t k\u1ef3 t\u1ec7p n\u00e0o t\u00ecnh c\u1edd c\u00f3 trong th\u01b0 m\u1ee5c. Trong b\u00e0i n\u00e0y b\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o h\u00e0m c\u1ee7a ri\u00eang m\u00ecnh thay v\u00ec k\u1ebft h\u1ee3p c\u00e1c t\u1ec7p v\u00e0 s\u1ebd tr\u1ea3 v\u1ec1 c\u00e1c truy v\u1ea5n web d\u1ef1a tr\u00ean URL m\u00e0 ch\u00fang b\u1ea1n cung c\u1ea5p cho n\u00f3.<\/span><\/p>\n<p><span style=\"font-weight: 400\">H\u00e3y b\u1eaft \u0111\u1ea7u v\u1edbi m\u1ed9t b\u1ea3ng m\u1edbi (m\u00ecnh \u0111\u00e3 g\u1ecdi l\u00e0 b\u1ea3ng tblURLs). N\u00f3 ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb sau:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Code<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Date<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\"><span style=\"font-weight: 400\">URL<\/span><\/span>\n<p><figure id=\"attachment_34645\" aria-describedby=\"caption-attachment-34645\" style=\"width: 684px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34645 size-full\" title=\"12- Nh\u1eadp d\u1eef li\u1ec7u power query\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h12-3.png\" alt=\"12- Nh\u1eadp d\u1eef li\u1ec7u power query\" width=\"684\" height=\"78\"><figcaption id=\"caption-attachment-34645\" class=\"wp-caption-text\">12- Nh\u1eadp d\u1eef li\u1ec7u power query<\/figcaption><\/figure>\n<\/p>\n<\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">C\u00f4ng th\u1ee9c trong \u00d4 C2 \u0111\u01b0\u1ee3c x\u00e2y d\u1ef1ng b\u1eb1ng c\u00e1ch gh\u00e9p m\u00e3 \u0111\u01a1n v\u1ecb ti\u1ec1n t\u1ec7 v\u00e0 ng\u00e0y th\u00e1ng v\u00e0o c\u1ea5u tr\u00fac URL.<\/span><\/p>\n<p><span style=\"font-weight: 400\">=\u201dhttps:\/\/www.xe.com\/currencytables\/?from=\u201d&amp;[@Code]&amp;\u201d&amp;date=\u201d&amp;TEXT([@Date],\u201dyyyy-mm-dd\u201d)<\/span><\/p>\n<p><span style=\"font-weight: 400\">Ti\u1ebfp theo, h\u00e3y th\u00eam b\u1ea3ng n\u00e0y v\u00e0o Power Query. Ch\u1ecdn m\u1ed9t \u00f4 b\u1ea5t k\u00ec b\u00ean trong b\u1ea3ng, sau \u0111\u00f3 ch\u1ecdn <\/span><b>Data -&gt; From Table\/Range<\/b><span style=\"font-weight: 400\">.<\/span><\/p>\n<p><span style=\"font-weight: 400\">B\u00e2y gi\u1edd t\u1ea5t c\u1ea3 \u0111\u00e3 s\u1eb5n s\u00e0ng \u0111\u1ec3 t\u1ea1o m\u1ed9t ch\u1ee9c n\u0103ng t\u00f9y ch\u1ec9nh.(<\/span><span style=\"font-weight: 400\">custom function)<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Tao_chuc_nang\"><\/span><span style=\"font-weight: 400\">T\u1ea1o ch\u1ee9c n\u0103ng<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">H\u00e3y quay l\u1ea1i truy v\u1ea5n ban \u0111\u1ea7u b\u1eb1ng c\u00e1ch nh\u1ea5p v\u00e0o truy v\u1ea5n FXRates t\u1eeb danh s\u00e1ch truy v\u1ea5n.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Ch\u00fang ta s\u1ebd thay \u0111\u1ed5i truy v\u1ea5n n\u00e0y th\u00e0nh m\u1ed9t ch\u1ee9c n\u0103ng c\u00f3 th\u1ec3 t\u00f9y ch\u1ec9nh, nh\u1ea5p v\u00e0o <\/span><b>Home -&gt; Advanced Editor<\/b><span style=\"font-weight: 400\"> \u0111\u1ec3 hi\u1ec3n th\u1ecb M\u00e3 M.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Thay \u0111\u1ed5i m\u00e3 M nh\u01b0 sau:<\/span><\/p>\n<p><span style=\"font-weight: 400\">(1) Th\u00eam m\u00e3 sau v\u00e0o \u0111\u1ea7u truy v\u1ea5n:<\/span><\/p>\n<p style=\"text-align: center\"><span style=\"font-weight: 400\">(URL) as table =&gt;\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">(2) Thay \u0111\u1ed5i URL ngu\u1ed3n trong m\u00e3 th\u00e0nh URL ch\u1eef c\u00e1i, l\u00e0 bi\u1ebfn m\u00e0 ch\u00fang ta \u0111\u00e3 t\u1ea1o \u1edf tr\u00ean.<\/span><\/p>\n<p><span style=\"font-weight: 400\">M\u00e3 M b\u00e2y gi\u1edd s\u1ebd nh\u01b0 sau (nh\u1eefng ph\u1ea7n \u0111\u01b0\u1ee3c \u0111\u00e1nh d\u1ea5u l\u00e0 nh\u1eefng ph\u1ea7n ch\u00fang ta \u0111\u00e3 thay \u0111\u1ed5i).<\/span><\/p>\n<p><b>(URL) as table =&gt;<\/b><\/p>\n<p><span style=\"font-weight: 400\">let<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u00a0\u00a0\u00a0\u00a0Source = Web.Page(Web.Contents(<\/span><b>URL<\/b><span style=\"font-weight: 400\">)),<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u00a0\u00a0\u00a0\u00a0Data0 = Source{0}[Data],<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u00a0\u00a0\u00a0\u00a0#\u201dDemoted Headers\u201d = Table.DemoteHeaders(Data0),<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u00a0\u00a0\u00a0\u00a0#\u201dChanged Type\u201d = Table.TransformColumnTypes(#\u201dDemoted Headers\u201d,{{\u201cColumn1\u201d, type text}, {\u201cColumn2\u201d, type text}, {\u201cColumn3\u201d, type text}, {\u201cColumn4\u201d, type text}}),<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u00a0\u00a0\u00a0\u00a0#\u201dRemoved Top Rows\u201d = Table.Skip(#\u201dChanged Type\u201d,1),<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u00a0\u00a0\u00a0\u00a0#\u201dRenamed Columns\u201d = Table.RenameColumns(#\u201dRemoved Top Rows\u201d,{{\u201cColumn1\u201d, \u201cCode\u201d}, {\u201cColumn2\u201d, \u201cCurrency\u201d}, {\u201cColumn3\u201d, \u201cRate\u201d}, {\u201cColumn4\u201d, \u201cInverted Rate\u201d}}),<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u00a0\u00a0\u00a0\u00a0#\u201dChanged Type1\u2033 = Table.TransformColumnTypes(#\u201dRenamed Columns\u201d,{{\u201cRate\u201d, type number}, {\u201cInverted Rate\u201d, type number}, {\u201cCode\u201d, type text}, {\u201cCurrency\u201d, type text}})<\/span><\/p>\n<p><span style=\"font-weight: 400\">in<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u00a0\u00a0\u00a0\u00a0#\u201dChanged Type1\u2033<\/span><\/p>\n<p><span style=\"font-weight: 400\">Nh\u1ea5p v\u00e0o Done trong c\u1eeda s\u1ed5 <\/span><span style=\"font-weight: 400\">Advanced Editor<\/span><span style=\"font-weight: 400\"> \u0111\u1ec3 ch\u1ea5p nh\u1eadn c\u00e1c thay \u0111\u1ed5i.<\/span><\/p>\n<p><span style=\"font-weight: 400\">C\u1eeda s\u1ed5 Power Query s\u1ebd thay \u0111\u1ed5i th\u00e0nh nh\u01b0 sau:<\/span><\/p>\n<figure id=\"attachment_34646\" aria-describedby=\"caption-attachment-34646\" style=\"width: 512px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34646 size-full\" title=\"13- Nh\u1eadp d\u1eef li\u1ec7u power query\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h13-3.png\" alt=\"13- Nh\u1eadp d\u1eef li\u1ec7u power query\" width=\"512\" height=\"237\"><figcaption id=\"caption-attachment-34646\" class=\"wp-caption-text\">13- Nh\u1eadp d\u1eef li\u1ec7u power query<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Trong danh s\u00e1ch c\u00e1c truy v\u1ea5n, n\u00f3 hi\u1ec3n th\u1ecb truy v\u1ea5n FX Rate m\u00e0 ch\u00fang ta v\u1eeba thay \u0111\u1ed5i v\u1edbi m\u1ed9t fx b\u00ean c\u1ea1nh n\u00f3, \u0111i\u1ec1u n\u00e0y c\u00f3 ngh\u0129a l\u00e0 n\u00f3 l\u00e0 m\u1ed9t h\u00e0m.<\/span><\/p>\n<figure id=\"attachment_34647\" aria-describedby=\"caption-attachment-34647\" style=\"width: 230px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34647 size-full\" title=\"14- Nh\u1eadp d\u1eef li\u1ec7u power query\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h14-2.png\" alt=\"14- Nh\u1eadp d\u1eef li\u1ec7u power query\" width=\"230\" height=\"93\"><figcaption id=\"caption-attachment-34647\" class=\"wp-caption-text\">14- Nh\u1eadp d\u1eef li\u1ec7u power query<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_chuc_nang\"><\/span><span style=\"font-weight: 400\">S\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">M\u1edf truy v\u1ea5n tblURLs.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Nh\u1ea5p v\u00e0o <\/span><b>Add Column -&gt; Custom Column<\/b><\/p>\n<p><span style=\"font-weight: 400\">Trong c\u1eeda s\u1ed5 <\/span><span style=\"font-weight: 400\">Custom Column<\/span><span style=\"font-weight: 400\">, nh\u1eadp th\u00f4ng tin sau:<\/span><\/p>\n<p><span style=\"font-weight: 400\">T\u00ean c\u1ed9t m\u1edbi: <\/span><span style=\"font-weight: 400\">Imported FX Rates<\/span><\/p>\n<p><span style=\"font-weight: 400\">C\u00f4ng th\u1ee9c c\u1ed9t t\u00f9y ch\u1ec9nh: <\/span><span style=\"font-weight: 400\">=FXRate([URL])<\/span><\/p>\n<p><span style=\"font-weight: 400\">Sau \u0111\u00f3 b\u1ea5m OK.<\/span><\/p>\n<figure id=\"attachment_34648\" aria-describedby=\"caption-attachment-34648\" style=\"width: 792px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34648 size-full\" title=\"15- Nh\u1eadp d\u1eef li\u1ec7u power query\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h15-3.png\" alt=\"15- Nh\u1eadp d\u1eef li\u1ec7u power query\" width=\"792\" height=\"430\"><figcaption id=\"caption-attachment-34648\" class=\"wp-caption-text\">15- Nh\u1eadp d\u1eef li\u1ec7u power query<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Nh\u1ea5p v\u00e0o <\/span><b>Continue<\/b><span style=\"font-weight: 400\"> tr\u00ean c\u1ea3nh b\u00e1o quy\u1ec1n ri\u00eang t\u01b0.<\/span><\/p>\n<figure id=\"attachment_34649\" aria-describedby=\"caption-attachment-34649\" style=\"width: 596px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34649 size-full\" title=\"16- Nh\u1eadp d\u1eef li\u1ec7u power query\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h16-3.png\" alt=\"16- Nh\u1eadp d\u1eef li\u1ec7u power query\" width=\"596\" height=\"39\"><figcaption id=\"caption-attachment-34649\" class=\"wp-caption-text\">16- Nh\u1eadp d\u1eef li\u1ec7u power query<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Tr\u00ean c\u1eeda s\u1ed5 <\/span><span style=\"font-weight: 400\">Privacy Levels<\/span><span style=\"font-weight: 400\">, ch\u1ecdn <\/span><span style=\"font-weight: 400\">\u00a0<\/span><i><span style=\"font-weight: 400\">Ignore Privacy Levels<\/span><\/i><span style=\"font-weight: 400\">, sau \u0111\u00f3 b\u1ea5m Save.<\/span><\/p>\n<figure id=\"attachment_34650\" aria-describedby=\"caption-attachment-34650\" style=\"width: 723px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34650 size-full\" title=\"17- Nh\u1eadp d\u1eef li\u1ec7u power query\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h17-3.png\" alt=\"17- Nh\u1eadp d\u1eef li\u1ec7u power query\" width=\"723\" height=\"351\"><figcaption id=\"caption-attachment-34650\" class=\"wp-caption-text\">17- Nh\u1eadp d\u1eef li\u1ec7u power query<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Nh\u1ea5p v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng m\u1edf r\u1ed9ng \u1edf \u0111\u1ea7u c\u1ed9t <\/span><span style=\"font-weight: 400\">Imported FX Rates<\/span><span style=\"font-weight: 400\"> (c\u1ed9t m\u1edbi ch\u00fang ta v\u1eeba th\u00eam). B\u1ecf ch\u1ecdn h\u1ed9p <\/span><b>Use original column name as prefix box<\/b><span style=\"font-weight: 400\">, sau \u0111\u00f3 b\u1ea5m OK.<\/span><\/p>\n<figure id=\"attachment_34651\" aria-describedby=\"caption-attachment-34651\" style=\"width: 769px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34651 size-full\" title=\"18- Nh\u1eadp d\u1eef li\u1ec7u power query\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h18-2.png\" alt=\"18- Nh\u1eadp d\u1eef li\u1ec7u power query\" width=\"769\" height=\"311\"><figcaption id=\"caption-attachment-34651\" class=\"wp-caption-text\">18- Nh\u1eadp d\u1eef li\u1ec7u power query<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">D\u1eef li\u1ec7u t\u1eeb XE.com \u0111\u00e3 \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o truy v\u1ea5n<\/span><\/p>\n<figure id=\"attachment_34652\" aria-describedby=\"caption-attachment-34652\" style=\"width: 762px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34652 size-full\" title=\"19- Nh\u1eadp d\u1eef li\u1ec7u power query\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h19-3.png\" alt=\"19- Nh\u1eadp d\u1eef li\u1ec7u power query\" width=\"762\" height=\"265\"><figcaption id=\"caption-attachment-34652\" class=\"wp-caption-text\">19- Nh\u1eadp d\u1eef li\u1ec7u power query<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Thu g\u1ecdn truy v\u1ea5n b\u1eb1ng c\u00e1ch:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Thay \u0111\u1ed5i ki\u1ec3u d\u1eef li\u1ec7u c\u1ee7a t\u1eebng c\u1ed9t<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">X\u00f3a c\u00e1c c\u1ed9t ch\u00fang ta kh\u00f4ng c\u1ea7n<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">Nh\u1ea5p v\u00e0o <\/span><b>Close &amp; Load<\/b><span style=\"font-weight: 400\"> \u0111\u1ec3 \u0111\u1ea9y th\u00f4ng tin v\u00e0o Excel.<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u00e3 \u0111\u1ebfn l\u00fac ki\u1ec3m tra \u0111i\u1ec1u n\u00e0y \u0111\u1ec3 ch\u1ee9ng minh r\u1eb1ng ch\u00fang ta c\u00f3 th\u1ec3 nh\u1eadn \u0111\u01b0\u1ee3c t\u1ef7 gi\u00e1 h\u1ed1i \u0111o\u00e1i cho b\u1ea5t k\u1ef3 lo\u1ea1i ti\u1ec1n t\u1ec7 n\u00e0o v\u00e0 b\u1ea5t k\u1ef3 ng\u00e0y n\u00e0o. Trong Excel, c\u00f3 th\u1ec3 thay \u0111\u1ed5i ng\u00e0y ho\u1eb7c m\u00e3 \u0111\u01a1n v\u1ecb ti\u1ec1n t\u1ec7 trong B\u1ea3ng tblURL. Nh\u1ea5p v\u00e0o <\/span><span style=\"font-weight: 400\">\u00a0<\/span><b>Data -&gt; Refresh All<\/b><span style=\"font-weight: 400\">, t\u1ef7 gi\u00e1 h\u1ed1i \u0111o\u00e1i t\u1eeb truy v\u1ea5n b\u00e2y gi\u1edd s\u1ebd \u0111\u01b0\u1ee3c l\u00e0m m\u1edbi. Th\u1eadt tuy\u1ec7t ph\u1ea3i kh\u00f4ng?<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Nhap_nhieu_trang_web\"><\/span><b>Nh\u1eadp nhi\u1ec1u trang web<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">T\u1eeb \u0111\u1ea7u \u0111\u1ebfn gi\u1edd ch\u00fang ta ch\u1ec9 nh\u1eadp d\u1eef li\u1ec7u t\u1eeb m\u1ed9t trang web duy nh\u1ea5t. Nh\u01b0ng n\u1ebfu ch\u00fang ta mu\u1ed1n nh\u1eadp nhi\u1ec1u trang web th\u00ec sao? N\u1ebfu Ch\u1ee9c n\u0103ng t\u00f9y ch\u1ec9nh(Custom) \u0111ang ho\u1ea1t \u0111\u1ed9ng th\u00ec \u0111i\u1ec1u n\u00e0y s\u1ebd tr\u1edf n\u00ean d\u1ec5 d\u00e0ng.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Th\u00eam m\u1ed9t s\u1ed1 h\u00e0ng d\u1eef li\u1ec7u kh\u00e1c v\u00e0o b\u1ea3ng tblURL.<\/span><\/p>\n<figure id=\"attachment_34653\" aria-describedby=\"caption-attachment-34653\" style=\"width: 512px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34653 size-full\" title=\"20- Nh\u1eadp d\u1eef li\u1ec7u power query\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h20-3.png\" alt=\"20- Nh\u1eadp d\u1eef li\u1ec7u power query\" width=\"512\" height=\"106\"><figcaption id=\"caption-attachment-34653\" class=\"wp-caption-text\">20- Nh\u1eadp d\u1eef li\u1ec7u power query<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Nh\u1ea5p v\u00e0o <\/span><b>Data -&gt; Refresh All<\/b><\/p>\n<p><span style=\"font-weight: 400\">Ki\u1ec3m tra b\u1ea3ng t\u1ef7 gi\u00e1 h\u1ed1i \u0111o\u00e1i\u2026\u1ed2 Wowwww, Power Query \u0111\u00e3 nh\u1eadp t\u1ea5t c\u1ea3 c\u00e1c ng\u00e0y v\u00e0 t\u1ef7 l\u1ec7 c\u00f3 trong b\u1ea3ng c\u1ee7a tblURL. Ch\u00fang ta c\u00f3 th\u1ec3 nh\u1eadn \u0111\u01b0\u1ee3c t\u1ea5t c\u1ea3 t\u1ef7 gi\u00e1 FX cho b\u1ea5t k\u1ef3 ng\u00e0y n\u00e0o \u0111\u1ed1i v\u1edbi b\u1ea5t k\u1ef3 lo\u1ea1i ti\u1ec1n t\u1ec7 c\u01a1 s\u1edf n\u00e0o.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Mot_vai_canh_bao\"><\/span><b>M\u1ed9t v\u00e0i c\u1ea3nh b\u00e1o<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">\u0110\u00e2y th\u1ef1c s\u1ef1 l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd. Nh\u01b0ng c\u00f3 m\u1ed9t s\u1ed1 \u0111i\u1ec1u b\u1ea1n c\u1ea7n l\u01b0u \u00fd:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">N\u1ebfu b\u1ea1n g\u1ecdi qu\u00e1 nhi\u1ec1u URL, truy v\u1ea5n c\u00f3 th\u1ec3 l\u00e0m m\u1edbi ch\u1eadm.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">N\u1ebfu xe.com thay \u0111\u1ed5i trang web c\u1ee7a h\u1ecd, truy v\u1ea5n c\u00f3 th\u1ec3 s\u1ebd kh\u00f4ng c\u00f2n \u0111\u00fang n\u1eefa.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Ch\u00fang ta kh\u00f4ng th\u1ec3 l\u1ea5y d\u1eef li\u1ec7u t\u1eeb m\u1ecdi trang web v\u00ec c\u00f3 m\u1ed9t s\u1ed1 trang web kh\u00f4ng \u0111\u01b0\u1ee3c c\u1ea5u tr\u00fac theo \u0111\u00fang c\u00e1ch.<\/span><\/li>\n<\/ul>\n<p><em>C\u00e1c b\u1ea1n th\u1ea5y \u0111\u00f3 vi\u1ec7c nh\u1eadp d\u1eef li\u1ec7u t\u1eeb web v\u00e0o trong Power Query c\u0169ng \u0111\u01a1n gi\u1ea3n th\u00f4i \u0111\u00fang kh\u00f4ng n\u00e0o? <strong>H\u1ecdc Excel Online<\/strong> s\u1ebd ti\u1ebfp t\u1ee5c \u0111\u1ed3ng h\u00e0nh c\u00f9ng c\u00e1c b\u1ea1n trong vi\u1ec7c chinh ph\u1ee5c <strong>Power Query<\/strong>. Xin ch\u00e0o v\u00e0 h\u1eb9n g\u1eb7p l\u1ea1i!\u00a0<\/em><\/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-232.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":3065,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-3064","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3064","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=3064"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3064\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/3065"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=3064"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=3064"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=3064"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}