Import vs. DirectQuery vs. Live connection. Which do you choose and why in Power BI? Adam looks at the three options when creating reports in Power BI Desktop.<\/p>\n
DirectQuery in SQL Server 2016 Analysis Services Whitepaper
\nhttps:\/\/blogs.msdn.microsoft.com\/analysisservices\/2017\/04\/06\/directquery-in-sql-server-2016-analysis-services-whitepaper\/<\/p>\n
Data sources supported by DirectQuery in Power BI
\nhttps:\/\/docs.microsoft.com\/power-bi\/desktop-directquery-data-sources<\/p>\n
********
\nLET’S CONNECT!
\n********<\/p>\n
— http:\/\/twitter.com\/guyinacube
\n— http:\/\/twitter.com\/awsaxton
\n— http:\/\/twitter.com\/patrickdba
\n— http:\/\/www.facebook.com\/guyinacube
\n— https:\/\/www.instagram.com\/guyinacube\/
\n— https:\/\/guyinacube.com<\/p>\n
***Gear***
\nCheck out my Tools page – https:\/\/guyinacube.com\/tools\/<\/p>\n","protected":false},"excerpt":{"rendered":"
Import vs. DirectQuery vs. Live connection. Which do you choose and why in Power BI? Adam looks at the three options when creating reports in Power BI Desktop. DirectQuery in SQL Server 2016 Analysis...<\/p>\n","protected":false},"author":1,"featured_media":3288,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"video","meta":[],"categories":[547,583],"tags":[589,609,613,614,615],"youtube_video":{"channel_id":"UCFp1vaKzpfvoGai0vE5VJ0w","channel_title":"Guy in a Cube","title":"Power BI Get Data: Import vs. DirectQuery vs. Live","description":"Import vs. DirectQuery vs. Live connection. Which do you choose and why in Power BI? Adam looks at the three options when creating reports in Power BI Desktop.\r\n\r\n\r\nDirectQuery in SQL Server 2016 Analysis Services Whitepaper\r\nhttps:\/\/blogs.msdn.microsoft.com\/analysisservices\/2017\/04\/06\/directquery-in-sql-server-2016-analysis-services-whitepaper\/\r\n\r\nData sources supported by DirectQuery in Power BI\r\nhttps:\/\/docs.microsoft.com\/power-bi\/desktop-directquery-data-sources\r\n\r\n\r\n********\r\nLET'S CONNECT!\r\n********\r\n\r\n-- http:\/\/twitter.com\/guyinacube\r\n-- http:\/\/twitter.com\/awsaxton\r\n-- http:\/\/twitter.com\/patrickdba\r\n-- http:\/\/www.facebook.com\/guyinacube\r\n-- https:\/\/www.instagram.com\/guyinacube\/\r\n-- https:\/\/guyinacube.com\r\n\r\n***Gear***\r\nCheck out my Tools page - https:\/\/guyinacube.com\/tools\/","category_id":"28","category":"Science & Technology","tags":["power bi","power bi desktop","power bi desktop direct query","power bi desktop directquery","power bi desktop training","power bi desktop tutorial","power bi desktop tutorial for beginners","power bi direct query","power bi direct query vs import","power bi direct query vs live connection","power bi for beginners","power bi import","power bi import data","power bi import vs directquery","power bi live","power bi training","power bi tutorial","power bi tutorial for beginners","bi","powerbi"],"duration":652,"iso_duration":"PT10M52S","human_duration":"10:52","definition":"hd","thumbnails":{"default":{"url":"https:\/\/i.ytimg.com\/vi\/y4S-k34qmnw\/default.jpg","width":120,"height":90},"medium":{"url":"https:\/\/i.ytimg.com\/vi\/y4S-k34qmnw\/mqdefault.jpg","width":320,"height":180},"high":{"url":"https:\/\/i.ytimg.com\/vi\/y4S-k34qmnw\/hqdefault.jpg","width":480,"height":360},"standard":{"url":"https:\/\/i.ytimg.com\/vi\/y4S-k34qmnw\/sddefault.jpg","width":640,"height":480},"maxres":{"url":"https:\/\/i.ytimg.com\/vi\/y4S-k34qmnw\/maxresdefault.jpg","width":1280,"height":720}},"video_id":"y4S-k34qmnw","published":"2019-04-18T15:00:12Z","stats":{"comments":"208","views":"105651","likes":"2294","dislikes":"25","favourite":"0"},"privacy":{"status":"public","embeddable":true,"license":"youtube"}},"_links":{"self":[{"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/posts\/3287"}],"collection":[{"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3287"}],"version-history":[{"count":0,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/posts\/3287\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/media\/3288"}],"wp:attachment":[{"href":"https:\/\/www.extradrm.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3287"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3287"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3287"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}