Category: Power Query

How to add a Calc Column to Power BI Direct Lake models

Posted on by Annie D

Calculated Column is greyed out for Power BI Direct Lake Models. So, how do you add a column? Patrick shows you how to get a “calculated column” into your Power BI Direct Lake models within Microsoft Fabric.

Matthew Roche’s Maxim of Data Transformation: https://youtu.be/OAlys79j81Q

📢 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
— <a href="http://www.facebook.com/guyinacube" target="_blank" Continue reading “How to add a Calc Column to Power BI Direct Lake models” →

Excel – How to Quickly Convert Text URLs to Clickable Hyperlinks in Excel with VBA – Episode 2665

Posted on by Annie D

Microsoft Excel Tutorial: Jody needs a way to convert a column of text URLS into clickable hyperlinks in Excel.

Here is the macro:
Sub MakeSelectedHyperlinksHot()
For Each Cell In Selection
ActiveSheet.Hyperlinks.Add Anchor:=Cell, Address:=Cell.Value, TextToDisplay:=Cell.Value
Next Cell
End Sub

In this video, we tackle a common Excel issue: converting thousands of text strings that look like URLs into clickable hyperlinks. Jody reached out with a situation—5,000 rows of exported data in Excel, all containing text that resembles hyperlinks. The manual method of right-clicking each cell and creating hyperlinks one by one is tedious and inefficient. Is Continue reading “Excel – How to Quickly Convert Text URLs to Clickable Hyperlinks in Excel with VBA – Episode 2665” →

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

Posted on by Annie D

Join us live as we answer your questions about Power BI & Microsoft Fabric! 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 Power BI / Fabric Q&A – LIVE (Jan 18, 2025) (Member Chat 2nd Half)” →

Microsoft Fabric Pipeline Nightmare! What Went Wrong?

Posted on by Annie D

Got your Data Factory Pipeline set up to run Notebooks in Microsoft Fabric? When you run them, it fails! What happened? What step did you miss? Patrick goes through his scenario and how to fix it!

📢 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 “Microsoft Fabric Pipeline Nightmare! What Went Wrong?” →

What is an Unmanaged Tenant in Entra ID with Microsoft Fabric / Power BI

Posted on by Annie D

What happens when you sign up for Microsoft Fabric and you are the first for your organization? Adam dives into an unmanaged Entra ID tenant / directory so you can understand!

What is Microsoft Entra ID?
https://learn.microsoft.com/entra/fundamentals/whatis

Quickstart: Create a new tenant in Microsoft Entra ID
https://learn.microsoft.com/entra/fundamentals/create-new-tenant

What is self-service sign-up for Microsoft Entra ID?
https://learn.microsoft.com/entra/identity/users/directory-self-service-signup

📢 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!
*******************

— <a href="http://twitter.com/guyinacube" Continue reading “What is an Unmanaged Tenant in Entra ID with Microsoft Fabric / Power BI” →

Keep your secrets SAFE in Microsoft Fabric and Azure Key Vault

Posted on by Annie D

You don’t want to store your secrets in plain text! Patrick walks you through how you can store your secrets in Azure Key Vault and then leverage them within a Microsoft Fabric Notebook.

NotebookUtils (former MSSparkUtils) for Fabric – Credentials utilities
https://learn.microsoft.com/fabric/data-engineering/notebook-utilities#credentials-utilities

📢 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
— <a href="https://www.instagram.com/guyinacube/" Continue reading “Keep your secrets SAFE in Microsoft Fabric and Azure Key Vault” →

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

Posted on by Annie D

Join us live as we answer your questions about Power BI & Microsoft Fabric! 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 Power BI / Fabric Q&A – LIVE (Jan 11, 2025) (Member Chat 2nd Half)” →

Excel I Need A Once In A Lifetime Formula For 2025 – Episode 2665

Posted on by Annie D

Microsoft Excel Tutorial: Looking for a great formula to format 2025 cells.

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

Start 2025 with a bang by diving into an Excel adventure like no other! In this tutorial, we explore the fascinating concept of “square years”—numbers that are perfect squares of whole numbers—and why 2025 (45 squared) is truly a once-in-a-lifetime event. We’ll walk you through formulas and creative techniques to visualize this unique year in Excel, while tying it back to historical milestones like the California Gold Rush and the completion of the Hoover Dam.

Discover how to create Continue reading “Excel I Need A Once In A Lifetime Formula For 2025 – Episode 2665” →

Conquering Excel’s Formatting Quirks with Creative Hacks – Episode 2664

Posted on by Annie D

Microsoft Excel Tutorial: Can you mix formatting in an Excel cell that contains a formula?

How to Work Around Excel’s Formatting Limitations

Ever wondered if you could apply different formatting to parts of a cell populated by a formula in Excel? In today’s video, we dive into this intriguing question posed by Paul, a viewer who couldn’t find a solution to this common Excel conundrum. While Excel doesn’t allow partial formatting of a formula’s result, I’ve discovered a clever workaround using the **Paste Linked Picture** feature. Watch as I demonstrate this creative hack step-by-step!

We start with a fundamental Excel tip: Continue reading “Conquering Excel’s Formatting Quirks with Creative Hacks – Episode 2664” →

Your Microsoft Fabric Is a Mess Without DOMAINS!

Posted on by Annie D

Have you been using Domains? They are a great way to organize items within Microsoft Fabric and to allow delegation of tenant settings. Adam shows you what they are all about!

Fabric domains
https://learn.microsoft.com/fabric/governance/domains

Best practices for planning and creating domains in Microsoft Fabric
https://learn.microsoft.com/fabric/governance/domains-best-practices

📢 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
— <a href="http://www.facebook.com/guyinacube" Continue reading “Your Microsoft Fabric Is a Mess Without DOMAINS!” →