Ask questions and engage in the Microsoft Fabric & Power BI Community over at https://aka.ms/fabriccommunity!
#MicrosoftFabric #PowerBI
Category: Power Query
🔴 Microsoft Power BI / Fabric Q&A – LIVE (Jan 25, 2025) (Member Chat 2nd Half)
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
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
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
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”
Get involved in the Microsoft Fabric Community!
Ask questions and engage in the Microsoft Fabric Community over at https://aka.ms/fabriccommunity!
#MicrosoftFabric
🔴 Microsoft Power BI / Fabric Q&A – LIVE (Jan 18, 2025) (Member Chat 2nd Half)
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?
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?”
Be a Microsoft Fabric Super User #MicrosoftFabric
Are you a Microsoft Fabric Super User? David Zenisek is! Join him over at https://aka.ms/fabriccommunity to help others out.
What is an Unmanaged Tenant in Entra ID with Microsoft Fabric / Power BI
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
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)
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)”