Category: Power Query

Excel Which Products Contain Both Of These Items – Episode 2661

Posted on by Annie D

Microsoft Excel Tutorial: Which Products Contain Both Of These Items?

Today, an odd data problem. I have a solution, but I suspect there are much easier ways to do this. I have a list of songs in workouts from Supernatural VR. Over 500 workouts are Quick Hits with just two songs. Each Quick Hits workout should be a subset of a longer workout. Given the two lists, how can you use Excel to find the parent workout?

My solution involves an XLOOKUP with a concatenated key and a concatenated lookup vector. This gives me a list of the Workout IDs that contain Continue reading “Excel Which Products Contain Both Of These Items – Episode 2661” →

Edit your Direct Lake models directly in Power BI Desktop!

Posted on by Annie D

Creating Power BI Direct Lake models? You can now edit your Direct Lake semantic models right in Power BI Desktop! Patrick walks you through how!

Live edit of Direct Lake models in Power BI Desktop
https://powerbi.microsoft.com/en-us/blog/live-edit-of-direct-lake-models-in-power-bi-desktop/

Direct Lake in Power BI Desktop (preview)
https://learn.microsoft.com/fabric/get-started/direct-lake-power-bi-desktop

📢 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
— rel=”nofollow”>http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— https://guyinacube.com

***Gear***
🛠 Check out my Tools page – https://guyinacube.com/tools/

#PowerBI #DirectLake #GuyInACube

REPLAY Microsoft Fabric / Power BI Q&A – LIVE (May 18, 2024)

Posted on by Annie D

Join us live as we answer your questions about Microsoft Fabric (including Power BI)! Get your questions in the chat early as we don’t get to all of them.

💥 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 Continue reading “REPLAY Microsoft Fabric / Power BI Q&A – LIVE (May 18, 2024)” →

REPLAY Let’s talk Microsoft Fabric – LIVE w/ Josh Caplan (May 11, 2024)

Posted on by Annie D

Join us live as we answer your questions about Microsoft Fabric (including Power BI)! Get your questions in the chat early as we don’t get to all of them.

💥 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

Connect with Josh:
Twitter: https://twitter.com/JoshCaplan1984
LinkedIn: <a href="https://www.linkedin.com/in/josh-caplan-2139a3a6/" Continue reading “REPLAY Let’s talk Microsoft Fabric – LIVE w/ Josh Caplan (May 11, 2024)” →

REPLAY Microsoft Fabric / Power BI Q&A w/ Kasper de Jonge (April 27, 2024)

Posted on by Annie D

Join us live as we answer your questions about Microsoft Fabric & Power BI! With special guest, Kasper de Jonge!

📢 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

Connect with Kasper:
Website: https://www.kasperonbi.com/
YouTube: https://www.youtube.com/@KasperOnBI
Twitter: https://twitter.com/kjonge

📢 Become a member: https://guyinacu.be/membership

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

Want to take your Power BI skills to the next level? We have Continue reading “REPLAY Microsoft Fabric / Power BI Q&A w/ Kasper de Jonge (April 27, 2024)” →

Excel Easy Fake Data From Python In Excel – Episode 2660

Posted on by Annie D

Microsoft Excel Tutorial: Excel Fake Data From Python In Excel

Creating fake data with Python in Excel has never been easier! In this video, I walk you through generating random data directly in Excel using Python’s powerful capabilities. We start from a completely blank workbook, search for Python, and dive into some exciting new options like the QR code generator and random data generator. This process is amazing for anyone who needs quick, randomized data sets without leaving Excel. Just a few clicks, and you can have it all right at your fingertips!

We’ll start by setting up Python to generate a Continue reading “Excel Easy Fake Data From Python In Excel – Episode 2660” →

Excel Draw Perfect Shapes With Draw And Hold Gesture – Episode 2659

Posted on by Annie D

Microsoft Excel Tutorial: Draw Perfect Shapes With Draw And Hold Gesture
In this video, I’m diving into a new feature in Microsoft Excel: the Draw and Hold Gesture!
If you’ve ever wanted to create shapes in Excel without struggling with awkward mouse drawing, this update is for you. While the feature has been available in OneNote for a while, it’s finally made its way to Excel and PowerPoint—at least for those on the Insider’s channel. I’ll walk you through how to activate this new tool and show you what it can do!

First, if you don’t see the Draw tab in Continue reading “Excel Draw Perfect Shapes With Draw And Hold Gesture – Episode 2659” →

Power BI Desktop Gets a DARK MODE Makeover!

Posted on by Annie D

We’ve been waiting a long time to get DARK MODE in Power BI Desktop! It’s finally here. Harleen Kaur joins us to show everything you need to know to start using it.

By Popular Demand: Dark mode is now available in Power BI Desktop!
https://powerbi.microsoft.com/blog/by-popular-demand-dark-mode-is-now-available-in-power-bi-desktop/

Create Power BI reports in dark mode
https://learn.microsoft.com/power-bi/create-reports/power-bi-dark-mode

Connect with Harleen Kaur
https://www.linkedin.com/in/-harleen-kaur/
https://x.com/sharlkaur

📢 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: <a href="https://guyinacu.be/courses" Continue reading “Power BI Desktop Gets a DARK MODE Makeover!” →

Why not a date and time table in Power BI instead?

Posted on by Annie D

We had a video talking about creating a Date and Time table in your Microsoft Fabric Warehouse. There were some comments centered around “why”??? Why not do that in Power BI? Patrick shows you!

📢 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
— https://www.instagram.com/guyinacube/
— https://guyinacube.com

***Gear***
🛠 Check out my Continue reading “Why not a date and time table in Power BI instead?” →

A Few Ways GENERATE_SERIES Will Revolutionize Your Microsoft Fabric Warehouse Experience

Posted on by Annie D

Want to create a series of data within a Microsoft Fabric Warehouse? Patrick looks at how GENERATE_SERIES can help you instead of doing INSERT after INSERT which doesn’t perform well.

Scripts: https://github.com/guyinacube/demo-files/blob/master/video%20demos/Fabric/20241017%20-%20Generate%20Series.zip

GENERATE_SERIES (Transact-SQL)
https://learn.microsoft.com/sql/t-sql/functions/generate-series-transact-sql?view=sql-server-ver16

GENERATESERIES – DAX Function
https://dax.guide/generateseries/

Brad Schacht
https://x.com/BradleySchacht
https://www.linkedin.com/in/bradleyschacht/

📢 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
— <a href="http://twitter.com/patrickdba" Continue reading “A Few Ways GENERATE_SERIES Will Revolutionize Your Microsoft Fabric Warehouse Experience” →

How to create a slick way to adjust your Power BI visual

Posted on by Annie D

Create a slick way to adjust your visual by way of bookmarks leveraging the Navigation button. Adam shows you how to set this approach up to get a nice look and feel.

📢 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
— https://www.instagram.com/guyinacube/
— https://guyinacube.com

***Gear***
🛠 Check out my Tools page Continue reading “How to create a slick way to adjust your Power BI visual” →

Leverage Power Query Parameters with Power BI Paginated reports

Posted on by Annie D

You’ve seen how you can use Power Query within Power BI Paginated reports. Now Patrick shows you how you can leverage parameters to drive interactivity!

📢 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
— https://www.instagram.com/guyinacube/
— https://guyinacube.com

***Gear***
🛠 Check out my Tools page – https://guyinacube.com/tools/

#PowerBI #Paginated #GuyInACube