Category: Power Query

Let Copilot Fly Your Power Query in Microsoft Fabric

Posted on by Annie D

Let’s dive into how Copilot supercharges your Power Query experience in Microsoft Fabric, helping you transform data faster than ever. Alex Powers shows us some great examples! Remember—you’re the pilot, so let’s get in there and let Copilot do the heavy lifting!

Alex Powers:
https://bsky.app/profile/itsnotaboutthecell.com
https://www.linkedin.com/in/alexmpowers/

Engage in the Reddit community!
https://www.reddit.com/r/MicrosoftFabric/
https://www.reddit.com/r/PowerBI/

📢 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="https://bsky.app/profile/guyinacube.bsky.social" Continue reading “Let Copilot Fly Your Power Query in Microsoft Fabric” →

No Copilot? No Problem: Power Query’s AI to the Rescue!

Posted on by Annie D

If you’re missing Copilot in Microsoft Fabric, don’t sweat it! Power Query is packed with AI features that can still supercharge your data game. In this video, Alex Powers explores how to leverage these tools to keep your workflow smooth and powerful, no Copilot required!

Alex Powers:
https://bsky.app/profile/itsnotaboutthecell.com
https://www.linkedin.com/in/alexmpowers/

Engage in the Reddit community!
https://www.reddit.com/r/MicrosoftFabric/
https://www.reddit.com/r/PowerBI/

📢 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 Continue reading “No Copilot? No Problem: Power Query’s AI to the Rescue!” →

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

Watch Me Build Microsoft Purview From SCRATCH

Posted on by Annie D

Need governance? Of course you do! Marthe is pumped to show you how to spin up Microsoft Purview in just a few clicks. This is your ticket to data governance that cuts through chaos and puts you in the driver’s seat. Strap in, and let’s transform your data estate together!

Create a Microsoft Purview account
https://learn.microsoft.com/purview/legacy/create-microsoft-purview-portal

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

— https://bsky.app/profile/guyinacube.bsky.social
— Continue reading “Watch Me Build Microsoft Purview From SCRATCH” →

Harvesting Insights, Block by Block (Minecraft + Microsoft Fabric)

Posted on by Annie D

Join Simon Nuss on a thrilling Minecraft adventure where a Microsoft Fabric telemetry block breathes new life into every harvested pixel. Watch as your farm data is instantly streamed and visualized in Power BI, showcasing the raw power of real-time intelligence. Brace yourself for an unforgettable glimpse into the magic of Microsoft Fabric.

Simon Nuss:
https://www.linkedin.com/in/simon-nuss/

Subreddits
https://www.reddit.com/r/MicrosoftFabric/
https://www.reddit.com/r/PowerBI/

📢 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: <a href="https://guyinacu.be/courses" target="_blank" Continue reading “Harvesting Insights, Block by Block (Minecraft + Microsoft Fabric)” →

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

Connection woes using Power BI Direct Lake and an App???

Posted on by Annie D

Stop the hassle of interrupted connections in Power BI when using Direct Lake. Marthe guides you through setting up a fixed identity so your published apps can be leveraged without giving direct access to OneLake.

Specify a fixed identity for a Direct Lake semantic model
https://learn.microsoft.com/fabric/fundamentals/direct-lake-fixed-identity

Setting up RLS on a Direct Lake semantic model
https://www.datazoe.blog/post/setting-up-rls-on-a-direct-lake-semantic-model

📢 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" target="_blank" Continue reading “Connection woes using Power BI Direct Lake and an App???” →

Now’s the Moment: Move from Power BI Premium to Microsoft Fabric

Posted on by Annie D

Ready to unlock new possibilities in your analytics journey? Adam talks about how to migrate your capacity from P SKU to F SKU and some things to be aware of. If you still just want to use Power BI only, you still can!

Important update coming to Power BI Premium licensing
https://powerbi.microsoft.com/en-us/blog/important-update-coming-to-power-bi-premium-licensing/

Microsoft Fabric Pricing Page
https://azure.microsoft.com/pricing/details/microsoft-fabric/

Microsoft Fabric Features by SKU type
https://learn.microsoft.com/fabric/enterprise/fabric-features

Automate your migration to Microsoft Fabric capacities
https://www.microsoft.com/microsoft-fabric/blog/2024/12/02/automate-your-migration-to-microsoft-fabric-capacities/
https://github.com/microsoft/semantic-link-labs/blob/main/notebooks/Capacity%20Migration.ipynb

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

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

Want to take your Power BI skills to the next level? We have training Continue reading “Now’s the Moment: Move from Power BI Premium to Microsoft Fabric” →

Excel Pivot Table Number Format Copied From Source Data Episode 2674

Posted on by Annie D

🚀 *Unbelievable Excel Update!* 🚀

Pivot Table numeric formatting is now automatically coming from the grid! 🎉 Microsoft didn’t announce this (that I’ve seen), but it just *worked* this morning. No more manually formatting numbers in your Pivot Tables—Excel is pulling it straight from the source data.

✅ Thousands separator? ✔️
✅ Currency symbols? ✔️
✅ No extra steps? ✔️

Watch as I demo this game-changing update with a quick dataset. This small but mighty improvement is a *huge* win for efficiency!

💡 Have you seen this in your version of Excel yet? Let Continue reading “Excel Pivot Table Number Format Copied From Source Data Episode 2674” →

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

Unleash Data Governance with Microsoft Purview & Microsoft Fabric

Posted on by Annie D

Discover how Microsoft Purview and Microsoft Fabric work together to strengthen data governance, streamline cataloging, and enhance analytics. Marthe gives a look at some ways that Purview can help in your Microsoft Fabric and Power BI journey.

Purview overview
https://learn.microsoft.com/purview/purview

Learn about Microsoft Purview Unified Catalog
https://learn.microsoft.com/purview/unified-catalog

📢 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 “Unleash Data Governance with Microsoft Purview & Microsoft Fabric” →

What about relationships with Multiple facts in Power BI?

Posted on by Annie D

Now relationships are causing a problem with multiple facts in Power BI! Patrick looks at another way to avoid a circular dependency by way of relationships.

Demo Files:
https://github.com/guyinacube/demo-files/blob/master/video%20demos/PBIX/2025/20250305%20-%20Multiple%20Facts%20pt3.zip

📢 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 Continue reading “What about relationships with Multiple facts in Power BI?” →