Blog

Bonbon's Guide To Data & Tech > Blog

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

Take over an Unmanaged Tenant in Microsoft Entra ID

Posted on by Annie D

You have an unmanaged tenant that you created by signing up for Microsoft Fabric and now you want to declare an administrator. Adam walks through how to take over an unmanaged tenant in Microsoft Entra ID.

📢 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 “Take over an Unmanaged Tenant in Microsoft Entra ID” →

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” →

MS 365 Excel Basics #3.5: Spill Rectangle Range of Weekly Commission Paid Amounts: #Short EMT 34

Posted on by Annie D

See how to use a formula to spill a rectangle Range of Weekly Commission Paid Amounts. Microsoft 365 Excel makes life easy! Download Excel file: https://people.highline.edu/mgirvin/AllClasses/218M365/Content/ExcelShort34.xlsx

Learn #excel #excelformulas #excelfunctions