{"id":3720,"date":"2024-12-03T03:48:42","date_gmt":"2024-12-03T03:48:42","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/huong-dan-cach-ket-noi-toi-sql-sever-de-lay-du-lieu-vao-power-bi\/"},"modified":"2024-12-03T03:48:42","modified_gmt":"2024-12-03T03:48:42","slug":"huong-dan-cach-ket-noi-toi-sql-sever-de-lay-du-lieu-vao-power-bi","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/huong-dan-cach-ket-noi-toi-sql-sever-de-lay-du-lieu-vao-power-bi\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch k\u1ebft n\u1ed1i t\u1edbi SQL Sever \u0111\u1ec3 l\u1ea5y d\u1eef li\u1ec7u v\u00e0o Power BI"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<p>Trong b\u00e0i vi\u1ebft n\u00e0y, <a href=\"http:\/\/blog.ezworkapp.com\">H\u1ecdc Excel Online<\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch k\u1ebft n\u1ed1i \u0111\u1ec3 l\u1ea5y d\u1eef li\u1ec7u t\u1eeb SQL Sever v\u00e0o Power BI m\u1ed9t c\u00e1ch nhanh ch\u00f3ng v\u00e0 hi\u1ec7u qu\u1ea3.<\/p>\n<h1>C\u00e1ch k\u1ebft n\u1ed1i t\u1edbi SQL Sever \u0111\u1ec3 l\u1ea5y d\u1eef li\u1ec7u v\u00e0o Power BI<\/h1>\n<p>Sau khi m\u1edf Power BI l\u00ean, t\u1ea1i Table Home trong Power BI Desktop b\u1ea1n \u0111i t\u1edbi Get Data v\u00e0 s\u1ebd nh\u00ecn th\u1ea5y SQL Sever, ho\u1eb7c b\u1ea1n c\u00f3 th\u1ec3 v\u00e0o More\u2026v\u00e0 t\u00ecm t\u1edbi Database, trong n\u00e0y s\u1ebd cung c\u1ea5p cho b\u1ea1n k\u1ebft n\u1ed1i t\u1edbi SQL Sever \u0111\u1ec3 l\u1ea5y d\u1eef li\u1ec7u v\u00e0o Power BI. Tuy nhi\u00ean, n\u1ebfu nh\u01b0 b\u1ea1n \u0111\u00e3 c\u00f3 b\u1ea3n c\u1eadp nh\u1eadt m\u1edbi nh\u1ea5t cho Power BI th\u00ec ngay t\u1ea1i Tab Home b\u1ea1n s\u1ebd th\u1ea5y n\u00f3 lu\u00f4n.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-31266\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1-12.png\" width=\"284\" height=\"396\" title=\"1-12\"><\/p>\n<p>Sau khi ch\u1ecdn SQL Sever, m\u1ed9t h\u1ed9p tho\u1ea1i SQL Sever database hi\u1ec7n ra nh\u01b0 sau, v\u00e0 b\u1ea1n s\u1ebd \u0111\u01b0a v\u00e0o c\u00e1c th\u00f4ng tin nh\u01b0 Sever (Sever b\u1ea1n mu\u1ed1n k\u1ebft n\u1ed1i t\u1edbi l\u00e0 g\u00ec), th\u00f4ng tin v\u1ec1 Database b\u1ea1n mu\u1ed1n k\u1ebft n\u1ed1i t\u1edbi trong Sever \u0111\u00f3 (b\u1ea1n c\u00f3 th\u1ec3 b\u1ecf qua th\u00f4ng s\u1ed1 n\u00e0y, \u0111\u00e2y l\u00e0 th\u00f4ng s\u1ed1 tu\u1ef3 ch\u1ecdn)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-31267\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2-1024x968-1.png\" width=\"475\" height=\"449\" title=\"2-1024x968-1\"><\/p>\n<p>T\u1edbi ph\u1ea7n Data Connectivity mode (Ch\u1ebf \u0111\u1ed9 k\u1ebft n\u1ed1i Data)<\/p>\n<ul>\n<li><strong>Import:<\/strong> Tu\u1ef3 ch\u1ecdn n\u00e0y b\u1ea1n s\u1ebd Inport Data t\u1eeb trong SQL Sever v\u00e0o Power BI, b\u1ea1n s\u1ebd xem \u0111\u01b0\u1ee3c Data hi\u1ec3n th\u1ecb trong Power BI<\/li>\n<li><strong>DirectQuery:<\/strong> Tu\u1ef3 ch\u1ecdn n\u00e0y t\u1ee9c b\u1ea1n ch\u1ec9 k\u1ebft n\u1ed1i v\u1edbi Database trong Sever \u0111\u00f3, v\u00e0 b\u1ea1n s\u1ebd KH\u00d4NG th\u1ea5y \u0111\u01b0\u1ee3c Data trong Power BI<\/li>\n<\/ul>\n<p>Khi xem Data b\u1ea1n s\u1ebd th\u1ea5y nh\u01b0 sau:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/cach-ket-noi-toi-sql-sever-de-lay-du-lieu-vao-power-bi.html\/4-115\" rel=\"attachment wp-att-31269\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter  wp-image-31269\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/4-5.png\" width=\"419\" height=\"60\" title=\"4-5\"><\/a><\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-125.gif\" title=\"vba101_92019-nho-125\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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-290.gif\" title=\"ex101_92019-nho-290\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>\u0110\u1ed3ng \u00fd v\u1edbi thay \u0111\u1ed5i b\u1eb1ng c\u00e1ch \u1ea5n OK, b\u1ea1n s\u1ebd tr\u00f4ng Data c\u1ee7a m\u00ecnh l\u00fac n\u00e0y nh\u01b0 sau:<\/p>\n<ul>\n<li>\u1ea4n Load \u0111\u1ec3 th\u1ef1c hi\u1ec7n Load (k\u1ebft n\u1ed1i t\u1edbi SQL Sever)<\/li>\n<li>\u1ea4n Transform \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c bi\u1ebfn \u0111\u1ed5i kh\u00e1c, l\u1ef1a ch\u1ecdn n\u00e0y s\u1ebd \u0111\u01b0a b\u1ea1n t\u1edbi c\u1eeda s\u1ed5 Power Query Editor<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-31268\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/3-1024x768-1.png\" width=\"477\" height=\"358\" title=\"3-1024x768-1\"><\/p>\n<p>Ch\u1ec9 \u0111\u01a1n gi\u1ea3n nh\u01b0 th\u1ebf th\u00f4i l\u00e0 b\u1ea1n \u0111\u00e3 c\u00f3 th\u1ec3 k\u1ebft n\u1ed1i t\u1edbi SQL Sever \u0111\u1ec3 n\u1ea1p d\u1eef li\u1ec7u v\u00e0o Power BI, t\u1eeb \u0111\u00f3 ph\u1ee5c v\u1ee5 cho vi\u1ec7c t\u1ea1o ra c\u00e1c b\u00e1o c\u00e1o m\u1ed9t c\u00e1ch nhanh ch\u00f3ng v\u00e0 linh ho\u1ea1t.\u00a0<\/p>\n<p>Ch\u00fac b\u1ea1n th\u00e0nh c\u00f4ng v\u00e0 tham kh\u1ea3o c\u00e1c b\u00e0i vi\u1ebft kh\u00e1c ngay d\u01b0\u1edbi \u0111\u00e2y<\/p>\n<hr>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/vo-hieu-hoa-chuc-nang-tu-phat-hien-kieu-du-lieu-trong-power-query-editor.html\"><em><strong>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<\/strong><\/em><\/a><\/p>\n<p><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-cai-dat-power-query-trong-excel-2010-2013-2016.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch c\u00e0i \u0111\u1eb7t power query trong excel 2010, 2013, 2016<\/a><\/strong><\/em><\/p>\n<p><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-dung-power-query-de-lam-bao-cao-nhap-xuat-ton-kho-tren-excel.html\">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<\/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\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-125.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":3721,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-3720","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\/3720","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=3720"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3720\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/3721"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=3720"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=3720"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=3720"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}