SQL Server in Microsoft Fabric? Use CETaS to move data!

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 SQL, Data Virtualization and Microsoft Fabric (Slides)
https://aka.ms/sqlfabricdemo

Bob Ward:
https://twitter.com/bobwardms
https://www.linkedin.com/in/bobwardms/

πŸ“’ Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your Continue reading “SQL Server in Microsoft Fabric? Use CETaS to move data!”

πŸ”΄ Microsoft Fabric/Power BI Q&A – LIVE (June 24, 2023) (Member Chat 2nd Half)

Join us live as we answer your questions about Microsoft Fabric (including Power BI)!

πŸ’₯ 30 minutes: Open Q&A (Public)
πŸ’₯ Then… Members Only Chat (Public can watch & Super Chat for Questions)

πŸ“’ RULES FOR Q&A: πŸ“’

πŸ‘‰ Put a “Q:” in front of your comment to help us identify questions!
πŸ‘‰ Super chats take priority
πŸ‘‰ Do NOT re-post your questions! We’ll get to as many questions as we can.
πŸ‘‰ If you SPAM your question, you will be put in timeout

πŸ“’ Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available Continue reading “πŸ”΄ Microsoft Fabric/Power BI Q&A – LIVE (June 24, 2023) (Member Chat 2nd Half)”

Digging into DYNAMIC format strings for DAX Measures in Power BI

DYNAMIC format strings recently were made available for DAX Measures in Power BI Desktop! Zoe walks us through how you can use these to enhance your reports!

Create dynamic format strings for measures
https://learn.microsoft.com/power-bi/create-reports/desktop-dynamic-format-strings

Zoe Douglas
https://www.linkedin.com/in/zoedouglas-data/
https://twitter.com/DataZoePowerBI

πŸ“’ Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

πŸŽ“ Guy in a Cube courses: https://guyinacu.be/courses

*******************
LET’S CONNECT!
*******************

http://twitter.com/guyinacube
http://twitter.com/awsaxton
http://twitter.com/patrickdba
http://www.facebook.com/guyinacube
rel=”nofollow”>https://www.instagram.com/guyinacube/
https://guyinacube.com

***Gear***
πŸ›  Check out my Tools page – https://guyinacube.com/tools/

#PowerBI #MicrosoftFabric #GuyInACube

Supercharge Your Power BI Workflow: A Guide to Using ChatGPT

Join Sam in this enlightening video as he shares his personal journey with OpenAI’s ChatGPT, a revolutionary language model that’s transforming the way we work with Power BI. Discover how the AI is assisting him at every step of his Power BI development journey, from understanding the Power BI interface to handling complex DAX formulas.

In this video, Sam explains how ChatGPT enhances his work by aiding in tasks such as understanding the query editor, aiding with formulas, brainstorming visualization ideas, and even evaluating data. He delves into practical examples, showcasing the immense possibilities that this AI opens up for your Continue reading “Supercharge Your Power BI Workflow: A Guide to Using ChatGPT”

Get the most as a Data Scientist with Microsoft Fabric (Public Preview)

Going down the DATA SCIENCE path can be hard when trying to get all the right data. Microsoft Fabric breaks down barriers and allows for easy reuse of data with OneLake. Nellie joins to talk about how data scientists can take advantage!

What is Data Science in Microsoft Fabric?
https://learn.microsoft.com/fabric/data-science/data-science-overview

Develop, execute, and manage Microsoft Fabric notebooks
https://learn.microsoft.com/fabric/data-engineering/author-execute-notebook?toc=%2Ffabric%2Fdata-science%2Ftoc.json&bc=%2Ffabric%2Fdata-science%2Fbreadcrumb%2Ftoc.json

How to accelerate data prep with Data Wrangler in Microsoft Fabric
https://learn.microsoft.com/fabric/data-science/data-wrangler

Nellie Gustafsson
https://twitter.com/nelliegson
https://www.linkedin.com/in/nelliegustafsson/

πŸ“’ Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have Continue reading “Get the most as a Data Scientist with Microsoft Fabric (Public Preview)”

Your data is in the Lakehouse, but now what? | Microsoft Fabric (Public Preview)

You’ve got your data into OneLake and a Lakehouse, but now what? What can you do with that data after you’ve landed it in Microsoft Fabric? Justyna walks us through different areas where you can leverage your data throughout fabric. From data warehouses to even Power BI!

What is Data engineering in Microsoft Fabric?
https://learn.microsoft.com/fabric/data-engineering/data-engineering-overview

What is Spark compute in Microsoft Fabric?
https://learn.microsoft.com/fabric/data-engineering/spark-compute

Develop, execute, and manage Microsoft Fabric notebooks
https://learn.microsoft.com/fabric/data-engineering/author-execute-notebook

OneLake shortcuts
https://learn.microsoft.com/fabric/onelake/onelake-shortcuts

Justyna Lucznik
https://twitter.com/JustynaLucznik
https://www.linkedin.com/in/justyna-lucznik/

πŸ“’ Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to Continue reading “Your data is in the Lakehouse, but now what? | Microsoft Fabric (Public Preview)”

πŸ”΄ Microsoft Fabric/Power BI Q&A – LIVE (June 17, 2023) (Member Chat 2nd Half)

Join us live as we answer your questions about Microsoft Fabric (including Power BI)!

πŸ’₯ 30 minutes: Open Q&A (Public)
πŸ’₯ Then… Members Only Chat (Public can watch & Super Chat for Questions)

πŸ“’ RULES FOR Q&A: πŸ“’

πŸ‘‰ Put a “Q:” in front of your comment to help us identify questions!
πŸ‘‰ Super chats take priority
πŸ‘‰ Do NOT re-post your questions! We’ll get to as many questions as we can.
πŸ‘‰ If you SPAM your question, you will be put in timeout

πŸ“’ Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available Continue reading “πŸ”΄ Microsoft Fabric/Power BI Q&A – LIVE (June 17, 2023) (Member Chat 2nd Half)”

What does Microsoft Fabric mean for Power BI?

You’ve heard the news about Microsoft Fabric but what about Power BI? How does Power BI fit in? Do you need to migrate anything? Can you still do what you were doing? Adam tells you what you need to know!

Direct Lake (PREVIEW)
https://learn.microsoft.com/power-bi/enterprise/directlake-overview

Microsoft Fabric Build 2023 Day 1
https://youtu.be/5jlP0wdEsls

Microsoft Fabric Build 2023 Day 2
https://youtu.be/wdDx0-jvl7w

πŸ“’ Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

πŸŽ“ Guy in a Cube courses: https://guyinacu.be/courses

*******************
LET’S CONNECT!
*******************

Continue reading “What does Microsoft Fabric mean for Power BI?”

What Is ChatGPT & How Do You Use It

Get ready for an in-depth journey into the world of ChatGPT, a revolutionary AI engine changing industries and job roles across the globe.

In this video, Sam explores how ChatGPT, developed by the incredible minds at OpenAI, has attracted millions of users within its first 5 days. Discover how you can leverage ChatGPT’s Natural Language Processing abilities to simplify complex concepts, improve your professional workflows and amplify your learning experience.

Are you curious about how ChatGPT is enhancing programming? We dive into the nitty-gritty of how this amazing AI tool can offer detailed explanations to intricate coding problems, helping programmers Continue reading “What Is ChatGPT & How Do You Use It”

Understanding the TIMELINE in DAX Studio

We brought Marco in to help explain the TIMELINE update within DAX Studio. This can help you understand performance a bit deeper when optimizing your DAX and models. This is one to watch!

DAX Studio
https://daxstudio.org

Marco Russo
https://twitter.com/marcorus
https://www.linkedin.com/in/sqlbi/
https://sqlbi.com

Optimizing DAX Video Course
https://www.sqlbi.com/p/optimizing-dax-video-course/

πŸ“’ Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

πŸŽ“ Guy in a Cube courses: https://guyinacu.be/courses

*******************
LET’S CONNECT!
*******************

http://twitter.com/guyinacube
http://twitter.com/awsaxton
Continue reading “Understanding the TIMELINE in DAX Studio”

Create your FIRST Lakehouse in Microsoft Fabric

You started your journey into Microsoft Fabric. Ted wants to help you understand how to create your first Lakehouse and start getting data into OneLake!

What is a lakehouse in Microsoft Fabric?
https://learn.microsoft.com/fabric/data-engineering/lakehouse-overview

Create a lakehouse in Microsoft Fabric
https://learn.microsoft.com/fabric/data-engineering/create-lakehouse

Ted Vilutis
https://www.linkedin.com/in/tedvilutis/
https://twitter.com/tvilutis

πŸ“’ Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

πŸŽ“ Guy in a Cube courses: https://guyinacu.be/courses

*******************
LET’S CONNECT!
*******************

http://twitter.com/guyinacube
http://twitter.com/awsaxton
rel=”nofollow”>http://twitter.com/patrickdba
http://www.facebook.com/guyinacube
https://www.instagram.com/guyinacube/
https://guyinacube.com

***Gear***
πŸ›  Check out my Tools page – https://guyinacube.com/tools/

#MicrosoftFabric #Lakehouse #GuyInACube

πŸ”΄ Let’s talk Microsoft Fabric – LIVE w/ Amir Netz (June 10, 2023)

Join us live as we answer your questions about Microsoft Fabric including Power BI with out guest Amir Netz who is a Microsoft Technical Fellow and CTO/Visionary of Microsoft Fabric. You don’t want to miss this one!

Connect with Amir:
LinkedIn: https://www.linkedin.com/in/amirnetz/
Twitter: https://twitter.com/amirnetz

πŸ“’ RULES FOR Q&A: πŸ“’

πŸ‘‰ Put a “Q:” in front of your comment to help us identify questions!
πŸ‘‰ Super chats take priority
πŸ‘‰ Do NOT re-post your questions! We’ll get to as many questions as we can.
πŸ‘‰ If you SPAM your question, you will be put in timeout

πŸ“’ Become a member: https://guyinacu.be/membership Continue reading “πŸ”΄ Let’s talk Microsoft Fabric – LIVE w/ Amir Netz (June 10, 2023)”