People have been asking “What about SQL Server?” with regards to Microsoft Fabric. Bob Ward joins us to show a way you can get your SQL data into Fabric with CETaS and the power of shortcuts in OneLake. And, then use that data in Power BI!<\/p>\n

CREATE EXTERNAL TABLE AS SELECT (CETAS) (Transact-SQL)
\nhttps:\/\/learn.microsoft.com\/sql\/t-sql\/statements\/create-external-table-as-select-transact-sql?view=sql-server-ver16&tabs=powershell<\/a><\/p>\n

Microsoft SQL, Data Virtualization and Microsoft Fabric (Slides)
\nhttps:\/\/aka.ms\/sqlfabricdemo<\/a><\/p>\n

Bob Ward:
\nhttps:\/\/twitter.com\/bobwardms<\/a>
\nhttps:\/\/www.linkedin.com\/in\/bobwardms\/<\/a><\/p>\n

\ud83d\udce2 Become a member: https:\/\/guyinacu.be\/membership<\/a> <\/p>\n

*******************<\/p>\n

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.<\/p>\n

\ud83c\udf93 Guy in a Cube courses: https:\/\/guyinacu.be\/courses<\/a><\/p>\n

*******************
\nLET’S CONNECT!
\n*******************<\/p>\n

— http:\/\/twitter.com\/guyinacube<\/a>
\n— http:\/\/twitter.com\/awsaxton<\/a>
\n— http:\/\/twitter.com\/patrickdba<\/a>
\n— http:\/\/www.facebook.com\/guyinacube<\/a>
\n— https:\/\/www.instagram.com\/guyinacube\/<\/a>
\n— https:\/\/guyinacube.com<\/a><\/p>\n

***Gear***
\n\ud83d\udee0 Check out my Tools page – https:\/\/guyinacube.com\/tools\/<\/a><\/p>\n

#MicrosoftFabric #SQLServer #GuyInACube<\/p>\n","protected":false},"excerpt":{"rendered":"

People have been asking “What about SQL Server?” with regards to Microsoft Fabric. Bob Ward joins us to show a way you can get your SQL data into Fabric with CETaS and the power of shortcuts in OneLake. And, then use that data in Power BI! CREATE EXTERNAL TABLE AS SELECT (CETAS) (Transact-SQL) https:\/\/learn.microsoft.com\/sql\/t-sql\/statements\/create-external-table-as-select-transact-sql?view=sql-server-ver16&tabs=powershell Microsoft […]<\/p>\n","protected":false},"author":3,"featured_media":5929,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[137,138],"tags":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/bonbonsguide.com\/wp\/wp-content\/uploads\/2023\/06\/DB8zujLjzVo.jpg?fit=1280%2C720&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p7QB1z-1xC","_links":{"self":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts\/5928"}],"collection":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/comments?post=5928"}],"version-history":[{"count":0,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts\/5928\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/media\/5929"}],"wp:attachment":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/media?parent=5928"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/categories?post=5928"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/tags?post=5928"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}