Category: Power Query

Excel Fastest Way to Copy Formula to All Rows #excel

Posted on by Annie D

Microsoft Excel Tutorial: Fastest Way to Copy Formula to All Rows.

Check out this tutorial on Excel’s Fast Way to Copy Formula to All Rows!

Are you tired of dragging your formulas down to thousands of rows? Say goodbye to that tedious process! In this video, we’ll show you a quick and efficient method to copy your formulas across multiple rows without the hassle.

Most people start by creating their formula in the first row, then painstakingly drag it down, row by row. It’s slow, it’s frustrating, and it’s not efficient. But fear not! We have a solution that will save you time Continue reading “Excel Fastest Way to Copy Formula to All Rows #excel” →

🔴 Microsoft Fabric / Power BI Q&A – LIVE (Feb 17, 2023) (Member Chat 2nd Half)

Posted on by Annie D

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 (Feb 17, 2023) (Member Chat 2nd Half)” →

Excel Keeps Inserting Old Formula – How to Fix It! – Episode 2640

Posted on by Annie D

Microsoft Excel Tutorial: Excel Keeps Inserting Old Formula – How to Fix It!

Every time that Tori adds a new row to her Excel table, four columns auto-fill formulas from years ago.

Oh my gosh. Ever had a crazy frustrating problem with Excel? In this video, we tackle Tori’s Excel nightmare head-on. Tori’s adding new rows to her table, only to find four columns haunted by formulas from three years ago! What gives?

Hey there! If you’re facing Excel woes like Tori, hit that Like button below to help more folks find this solution-packed video – thanks for the support!

Picture this: Tori’s table Continue reading “Excel Keeps Inserting Old Formula – How to Fix It! – Episode 2640” →

The secret whereabouts of Adam & Patrick revealed!

Posted on by Annie D

Conference season is in full swing, and you have an opportunity to come meet Adam and Patrick in person! From Microsoft Power Platform Conference, to dataMinds Connect, PASS Data Community Summit and the Microsoft Data & AI conferences, now is a great time to take part in the community.

We will be bringing Microsoft Fabric and Power BI to the community!

Microsoft Power Platform Conference
https://powerplatformconf.com/

dataMinds Connect
https://datamindsconnect.be/

PASS Data Community Summit
https://passdatacommunitysummit.com/
Pre-Con: https://passdatacommunitysummit.com/sessions/1970

Microsoft Data & AI Conferenct
https://msdataaiconf.com/
Pre-Con: https://msdataaiconf.com/#!/workshop/Power%20BI%20Hidden%20Gems/6191

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

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

Want to Continue reading “The secret whereabouts of Adam & Patrick revealed!” →

REPLAY Microsoft Fabric/Power BI Q&A – LIVE (Sept 2, 2023)

Posted on by Annie D

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 “REPLAY Microsoft Fabric/Power BI Q&A – LIVE (Sept 2, 2023)” →

REPLAY Microsoft Fabric / Power BI Q&A – LIVE (Oct 14, 2023)

Posted on by Annie D

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 “REPLAY Microsoft Fabric / Power BI Q&A – LIVE (Oct 14, 2023)” →

Why can’t I edit my Power BI semantic model?

Posted on by Annie D

Wait!?! I need to adjust some properties in my Power BI semantic model, but I can’t edit it? What’s going on? Patrick shows you what you need to know!

📢 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 “Why can’t I edit my Power BI semantic model?” →

Control ACCESS to your Microsoft Fabric Lakehouse or Warehouse

Posted on by Annie D

Want to secure your data in Microsoft Fabric? Adam walks you through different options and layers to control access and prevent people from looking at data they shouldn’t for your lakehouse or warehouse!

Roles in workspaces in Microsoft Fabric
https://learn.microsoft.com/fabric/get-started/roles-workspaces

Row-level security in Fabric data warehousing
https://learn.microsoft.com/fabric/data-warehouse/row-level-security

Row-level security
https://learn.microsoft.com/sql/relational-databases/security/row-level-security?view=sql-server-ver16

Column-level security in Fabric data warehousing
https://learn.microsoft.com/fabric/data-warehouse/column-level-security

How lakehouse sharing works
https://learn.microsoft.com/fabric/data-engineering/lakehouse-sharing

Share your warehouse and manage permissions
https://learn.microsoft.com/fabric/data-warehouse/share-warehouse-manage-permissions

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

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

Want to take your Power BI skills to the next level? We have training courses available to Continue reading “Control ACCESS to your Microsoft Fabric Lakehouse or Warehouse” →

REPLAY Microsoft Fabric / Power BI Q&A – LIVE (Dec 2, 2023)

Posted on by Annie D

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 “REPLAY Microsoft Fabric / Power BI Q&A – LIVE (Dec 2, 2023)” →

REPLAY Microsoft Fabric / Power BI Q&A w/ Marco Russo LIVE (October 28, 2023)

Posted on by Annie D

Prioritizing questions around DAX Studio 3, optimization, performance, DAX, data modeling, processing, etc…

📢 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

Connect with SQLBI:
Website: https://sqlbi.com
YouTube: https://www.youtube.com/sqlbi
Marco Russo: https://twitter.com/marcorus
Alberto Ferrari: https://twitter.com/FerrariAlberto

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

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

Want to take your Power BI skills to the next level? We have training Continue reading “REPLAY Microsoft Fabric / Power BI Q&A w/ Marco Russo LIVE (October 28, 2023)” →

REPLAY Microsoft Fabric / Power BI Q&A – LIVE (Oct 21, 2023)

Posted on by Annie D

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 “REPLAY Microsoft Fabric / Power BI Q&A – LIVE (Oct 21, 2023)” →

Excel – First Look At Copilot AI For Excel – Episode 2636

Posted on by Annie D

Microsoft Excel Tutorial: Preview of AI Copilot for Excel.

Welcome to episode 2636 of Mr. Excel’s netcast! In this video, we will be taking a first look at Copilot AI for Excel, a new feature from Microsoft that has been generating a lot of buzz. I was lucky enough to get a sneak peek at this feature, even though it was initially only available for enterprises with over 100 customers. But now, I have access to it and I’m excited to share it with you.

In this video, we will be exploring the Copilot feature and its capabilities. We will be working Continue reading “Excel – First Look At Copilot AI For Excel – Episode 2636” →