Category: Power Query

🔴 Microsoft Fabric / Power BI Q&A – LIVE (Jan 27, 2023) (Member Chat 2nd Half)

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 “🔴 Microsoft Fabric / Power BI Q&A – LIVE (Jan 27, 2023) (Member Chat 2nd Half)” →

Can you use Field Parameters with Direct Lake in Power BI?

Posted on by Annie D

We got the question if you could use Field Parameters with Direct Lake in Power BI. The answer is yes? However… Patrick tells more!

Let report readers use field parameters to change visuals (preview)
https://learn.microsoft.com/power-bi/create-reports/power-bi-field-parameters

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

Tabular Editor
https://tabulareditor.com/

Tabular Editor Script
https://github.com/tabulareditor/Tabulareditor3/issues/541

📢 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
— Continue reading “Can you use Field Parameters with Direct Lake in Power BI?” →

Join us at the Microsoft Fabric Community Conference! Get $100 OFF!

Posted on by Annie D

We’d love to see you at the Microsoft Fabric Community Conference! From the Power Hour to great workshops and tons of sessions, we want you to soak up all the knowledge. Also make connections with folks to grow your network. And, of course, come say HI (or better yet – YOOO) to Patrick and me!

Register today with discount code CUBE100 at https://fabricconf.com

Power BI Hidden Gems
https://fabricconf.com/#!/session/Power%20BI%20Hidden%20Gems/6320

Power Hour…After Dark!
https://fabricconf.com/#!/session/Power%20Hour…%20After%20Dark!/6379

Jason Himmelstein
https://twitter.com/jasehimm
https://www.linkedin.com/in/jasonhimmelstein/

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

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

Want to take your Power BI skills to the next Continue reading “Join us at the Microsoft Fabric Community Conference! Get $100 OFF!” →

Excel Customers Paying Less Than Average – Episode 2639

Posted on by Annie D

Microsoft Excel Tutorial: Create an Excel Pivot Table to Identify Which Customers Are Paying Less than Average for a Product.

To download the workbook from today: https://www.mrexcel.com/youtube/4XrKZhiBB-k/

Hey Excel enthusiasts! 👋 In this MrExcel netcast, we tackle a fascinating question from Glenn, who joined our recent Nashville IMA webinar. Ever wondered which customers are paying less than the average? 🧐 We’ve got you covered!

🔍 Using a special pivot table based on the Data Model, we delve into the powerful DAX function CALCULATE. Follow along as we transform our data into a table named “Sales” and explore 12,000 rows of Continue reading “Excel Customers Paying Less Than Average – Episode 2639” →

🔴 Microsoft Fabric / Power BI Q&A – LIVE (Jan 20, 2023) (Member Chat 2nd Half)

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 “🔴 Microsoft Fabric / Power BI Q&A – LIVE (Jan 20, 2023) (Member Chat 2nd Half)” →

Power BI Tutorial for Beginners (2024)

Posted on by Annie D

Learn how to use Power BI with this beginner tutorial! Get started on creating visualizations, building reports, and analyzing data with this powerful tool. Get a head start on using Power BI!

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

***Gear***
🛠 Check out my Tools page Continue reading “Power BI Tutorial for Beginners (2024)” →

Get Your DP-600 the Smart Way: Microsoft Fabric Career Hub

Posted on by Annie D

Discover the best way to get your Microsoft DP-600 certification with the new Career Hub on Microsoft Fabric. Access resources, practice tests, and expert advice to help you ace the exam and advance your career in data engineering & analytics. Don’t miss out on this valuable tool for your professional development! Did we also say discounts?

Microsoft Fabric Career Hub
https://aka.ms/fabriccareerhub

Validate your skills with our new certification for Microsoft Fabric Analytics Engineers
https://techcommunity.microsoft.com/t5/microsoft-learn-blog/validate-your-skills-with-our-new-certification-for-microsoft/ba-p/3500872

Study guide for Exam DP-600: Implementing Analytics Solutions Using Microsoft Fabric
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-600

Microsoft Fabric Learn Together
https://learn.microsoft.com/en-us/shows/learn-live/microsoft-fabric-wave-1/?WT.mc_id=academic-114764-leestott

📢 Become a member: <a href="https://guyinacu.be/membership" Continue reading “Get Your DP-600 the Smart Way: Microsoft Fabric Career Hub” →

🔴 Let’s talk Microsoft Fabric – LIVE w/ Matthew Roche (Jan 13, 2024) (Member Chat 2nd Half)

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.

Connect with Matthew:
Mastodon: https://techhub.social/@SQLAllFather
YouTube: https://www.youtube.com/channel/UCpsilPn-2qFlrYYuvyFkpPQ
Website: https://ssbipolar.com/

💥 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, Continue reading “🔴 Let’s talk Microsoft Fabric – LIVE w/ Matthew Roche (Jan 13, 2024) (Member Chat 2nd Half)” →

Excel Show Details In Excel Pivot Table – Episode 2638

Posted on by Annie D

Microsoft Excel Tutorial: Microsoft improves the Show Details feature in a pivot table and adds new entry points.

To download the workbook from today: https://www.mrexcel.com/youtube/d8kKJlZIr_g/

Unlock New Insights with Excel Pivot Tables! 🚀 In this tutorial, we dive into the latest updates from the Excel team. Discover the new Show Details feature, making data analysis smoother than ever! 📊💡

🔍 Show Details Icon: Spot the new icon on the Pivot Table Analyze tab – it’s a game-changer! Similar to the classic double-click, it opens a new sheet to the left with detailed information. Now, with a handy title indicating the Continue reading “Excel Show Details In Excel Pivot Table – Episode 2638” →

What happens to the incremental data???

Posted on by Annie D

We talked about incremental data using an integer within your Synapse Data Warehouse in Microsoft Fabric. But Patrick forgot to go through what you do after staging. Well, here you go!

📢 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 “What happens to the incremental data???” →

Incremental Refresh with your Warehouse without a date in Microsoft Fabric

Posted on by Annie D

Want to incrementally refresh your data without using a date for your Synapse Data Warehouse in Microsoft Fabric? Patrick gives you a pattern you can leverage!

Alex Powers’ Blog

CHANGE (IN THE HOUSE OF LAKES)
https://itsnotaboutthecell.com/2023/10/16/change-in-the-house-of-lakes/

📢 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 Continue reading “Incremental Refresh with your Warehouse without a date in Microsoft Fabric” →

Excel Shortest Route To 148 Locations Around The Supernatural World Using Excel – Episode 2637

Posted on by Annie D

Microsoft Excel Tutorial: Finding best routing for a trip with 148 locations.

Hey Excel fam! 🚀 Bill Jelen here with an epic Excel challenge. 🏋️‍♂️ Joined forces with the Supernatural workout community to optimize a 148-location quest using Excel magic. 🌍 Check out the journey, from Tahiti to Antarctica, and witness the distance-cutting madness unfold. 🌐

💡 First attempt started in Tahiti, but the route was a rollercoaster. 🔄 Tried a radical pivot, starting in Antarctica. 🏔️ Improved the distance to 90,253 miles, but still seeking perfection.

🤔 Experimented with K-Means clustering, exploring different strategies. 🧩 Finally settled on a plan starting in Continue reading “Excel Shortest Route To 148 Locations Around The Supernatural World Using Excel – Episode 2637” →