🔴 Microsoft Fabric / Power BI Q&A – LIVE (Mar 16, 2024) (Member Chat 2nd Half)

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 (Mar 16, 2024) (Member Chat 2nd Half)”

Include in Refresh can trip you up within Power Query

You disabled Include In Refresh in Power Query, but it’s still being used? And you still need to provide credentials for your Power BI Semantic Mode? What?!? Adam breaks down what’s going on.

Managing query refresh in Power BI
https://learn.microsoft.com/power-bi/connect-data/refresh-include-in-report-refresh

📢 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/
Continue reading “Include in Refresh can trip you up within Power Query”

Free Excel Webinar March 20 2024 from MrExcel #ExcelWebinar #Free

Hey Excel enthusiasts! 📊 Join me, Bill Jelen, from MrExcel, for an epic free Excel webinar on Wednesday, March 20th, 2024, starting at noon Eastern time in the US. 🚀 Excited to unveil my latest book, “Mr. Excel 2024: Igniting Excel,” packed with 33 new topics! 🔥 Tune in to my YouTube channel as I dive into some of my favorite highlights. Let’s excel together! Don’t miss out, mark your calendars! 📅 #ExcelWebinar #MrExcel2024 #IgnitingExcel
Watch the Webinar here on YouTube: https://www.youtube.com/watch?v=1LXvuSt2D5I

Dive into Microsoft Fabric’s Power BI Direct Lake

Let’s break down Power BI Direct Lake in Microsoft Fabric and explain how you can leverage one copy of the data from OneLake. Patrick explains!

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

📢 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 “Dive into Microsoft Fabric’s Power BI Direct Lake”

Getting started with Visual Calcs in Power BI

It’s been a long time coming but Visual Calculations within Power BI are here!!! Jay joins us to get us started on using Visual Calcs within our reports.

Share your thoughts on visual calculations (preview)
https://aka.ms/visual-calculations-feedback

Using visual calculations (preview)
https://learn.microsoft.com/power-bi/transform-model/desktop-visual-calculations-overview

Jeroen (Jay) ter Heerdt
https://twitter.com/JayPowerBI
https://www.linkedin.com/in/jeroenterheerdt/
https://www.dutchdatadude.com/

📢 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
— <a href="http://twitter.com/awsaxton" Continue reading “Getting started with Visual Calcs in Power BI”

Uncovering OneLake’s Secrets with Delta Analyzer in Microsoft Fabric

You need to make sure your delta files in OneLake are healthy! Phil has you covered with a Delta Analyzer notebook that you can use within Microsoft Fabric to check on things.

Delta Analyzer
https://aka.ms/deltaanalyzer

Phil Seamark
https://twitter.com/PhilSeamark
https://www.linkedin.com/in/seamark/
https://dax.tips

📢 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 #GuyInACube

🔴 Microsoft Fabric / Power BI Q&A – LIVE (Mar 2, 2024) (Member Chat 2nd Half)

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 (Mar 2, 2024) (Member Chat 2nd Half)”

All Code!!! Extract ZIP files with Notebooks in Microsoft Fabric

Who needs NOCODE? Patrick takes you on a journey where you can extract ZIP files within a Notebook in Microsoft Fabric. Also found a very cool feature in Notebooks!

📢 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 – <a href="https://guyinacube.com/tools/" Continue reading “All Code!!! Extract ZIP files with Notebooks in Microsoft Fabric”

NO CODE extract ZIP files with Pipelines in Microsoft Fabric

Need to extract ZIP files and don’t want to write code? Adam walks you through how you can do this with Pipelines and dataflows within Microsoft Fabric. A NO CODE approach!

📢 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 “NO CODE extract ZIP files with Pipelines in Microsoft Fabric”

Excel Formulas to convert to Upper, Lower, or Proper Case #excel

Microsoft Excel Tutorial: Upper, Lower, Proper Case with a Formula in Excel.

In this tutorial, learn how to effortlessly convert text to upper, lower, or proper case using Excel formulas. Discover three essential functions that streamline the case conversion process. Whether you’re transforming text to lowercase with LOWER(A2), uppercase with UPPER(B2), or proper case with PROPER(C2), these functions have you covered. But beware of nuances – even PROPER doesn’t always nail the interior ‘C’ in McCartney, necessitating manual adjustments.
But what about real-world scenarios where your data extends beyond the conversion zone? Fear not! We’ll guide you through inserting a temporary column Continue reading “Excel Formulas to convert to Upper, Lower, or Proper Case #excel”

Excel Number of Days To End of Year for Reaching a Goal

Microsoft Excel Tutorial: Calculate Number of Days to End of Year for Reaching a Goal.

Thanks to Kikas for this idea!

Unlock the secrets of Excel productivity with our latest tutorial! In this comprehensive guide, we unravel the complexities of Excel calculations to streamline your task management process. Are you struggling to determine the number of items you need to complete daily to meet your year-end goals? Look no further! Speaker 1 expertly guides you through the process, breaking down intricate formulas into simple, actionable steps.

Discover how to calculate the precise number of items you need to tackle each day to ensure Continue reading “Excel Number of Days To End of Year for Reaching a Goal”