Category: Power Query

Copilot for Power BI: Your Ultimate Copilot Guide

Posted on by Annie D

Have you used Copilot for Power BI? Do you know there are different copilots within Power BI? Carly joins us for the ultimate Copilot for Power BI guide!

Overview of Copilot for Power BI (preview)
https://learn.microsoft.com/power-bi/create-reports/copilot-introduction

Create report pages with Copilot for the Power BI service
https://learn.microsoft.com/power-bi/create-reports/copilot-create-report

Create a narrative with Copilot for Power BI
https://learn.microsoft.com/power-bi/create-reports/copilot-create-narrative?tabs=powerbi-service

Summarize a report page in the Copilot pane
https://learn.microsoft.com/power-bi/create-reports/copilot-pane-summarize-content

Use Copilot to create measure descriptions (preview)
https://learn.microsoft.com/power-bi/transform-model/desktop-measure-copilot-descriptions?toc=%2Fpower-bi%2Fcreate-reports%2FTOC.json&bc=%2Fpower-bi%2Fcreate-reports%2Fbreadcrumb%2Ftoc.json

Connect with Carly Newsome
https://www.linkedin.com/in/carlylanders/

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

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

Want to take your Power BI skills to the Continue reading “Copilot for Power BI: Your Ultimate Copilot Guide” →

Excel – Export to PDF with Gridlines and Row & Column Labels

Posted on by Annie D

Microsoft Excel Tutorial: How to export a PDF file from Excel including the gridlines, row headers, and column headers.

In this Excel tutorial, we solve Angela’s problem: her exported PDF is missing grid lines! 📊 Don’t worry, we’ve got you covered. Learn step-by-step how to ensure your PDF exports retain grid lines, row numbers, and column labels. It’s all about mastering those Page Layout and Page Setup settings. Join us as we dive into the nitty-gritty of Excel’s Sheet tab and unleash the power of the dialog launcher. By the end of this video, you’ll be exporting polished PDFs like a Continue reading “Excel – Export to PDF with Gridlines and Row & Column Labels” →

Exploring Dynamic Subscriptions for Power BI reports

Posted on by Annie D

First, we had dynamic subscriptions for Power BI Paginated reports. Now they are available for Power BI reports! Patrick walks you through how to take advantage of them!

Dynamic per recipient subscriptions for reports (Preview)
https://learn.microsoft.com/power-bi/collaborate-share/power-bi-dynamic-report-subscriptions

📢 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***
🛠 Continue reading “Exploring Dynamic Subscriptions for Power BI reports” →

Excel – How to Run a Macro from an Icon on the QAT #excelfansonly

Posted on by Annie D

Microsoft Excel Tutorial: How to run a macro from an icon on the Quick Access Toolbar.

Running your Excel macros just got a whole lot easier! Forget the hassle of navigating through menus. In this tutorial, learn how to add your macros to the Quick Access Toolbar for quick and convenient access.

Simply right-click, customize the Quick Access Toolbar, select Macros, and add your desired macro, specifying it’s for This Workbook. Choose an icon that represents your macro’s function, click OK, and voila!

Now you can effortlessly run your macro directly from the Quick Access Toolbar.

Discover more time-saving tips like Continue reading “Excel – How to Run a Macro from an Icon on the QAT #excelfansonly” →

Excel – How to Run a Macro From a Button in the Excel Grid #excelfansonly

Posted on by Annie D

Microsoft Excel Tutorial – Easy Way to Add a Macro button to your spreadsheet.

Tired of the hassle of running your Excel macros? In this video, learn a quick and easy way to streamline the process. Say goodbye to pressing Alt+F8 and clicking through menus.

Simply head over to the Insert tab, choose a shape, like a rounded rectangle, and type “Run!” while the shape is selected.

Customize it with your macro’s name and formatting preferences. Then, right-click the shape, assign your macro, and you’re done! With just a click, your macro runs smoothly.

Plus, discover more time-saving tips like this Continue reading “Excel – How to Run a Macro From a Button in the Excel Grid #excelfansonly” →

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

How to connect to Microsoft Fabric Items from Power BI Desktop?

Posted on by Annie D

If you’re in Power BI Desktop, how do you actually connect to Microsoft Fabric items like a lakehouse or warehouse? Adam walks you through different options and how this relates to various connectors.

📢 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 Continue reading “How to connect to Microsoft Fabric Items from Power BI Desktop?” →

Decoding Direct Lake: The Truth Behind DirectQuery Fallback

Posted on by Annie D

Direct Lake in Power BI could possibly fall back to DirectQuery. Do you understand why this would happen and when? Patrick walks you though what you need to know when leveraging data from OneLake in Microsoft Fabric.

Direct Lake
https://learn.microsoft.com/power-bi/enterprise/directlake-overview

📢 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/
— Continue reading “Decoding Direct Lake: The Truth Behind DirectQuery Fallback” →

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

Include in Refresh can trip you up within Power Query

Posted on by Annie D

You disabled Include In Refresh in Power Query, but it’s still being used? And you still need to provide credentials for your Power BI Semantic Mode? What?!? Adam breaks down what’s going on.

Managing query refresh in Power BI
https://learn.microsoft.com/power-bi/connect-data/refresh-include-in-report-refresh

📢 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/
— Continue reading “Include in Refresh can trip you up within Power Query” →

Free Excel Webinar March 20 2024 from MrExcel #ExcelWebinar #Free

Posted on by Annie D

Hey Excel enthusiasts! 📊 Join me, Bill Jelen, from MrExcel, for an epic free Excel webinar on Wednesday, March 20th, 2024, starting at noon Eastern time in the US. 🚀 Excited to unveil my latest book, “Mr. Excel 2024: Igniting Excel,” packed with 33 new topics! 🔥 Tune in to my YouTube channel as I dive into some of my favorite highlights. Let’s excel together! Don’t miss out, mark your calendars! 📅 #ExcelWebinar #MrExcel2024 #IgnitingExcel
Watch the Webinar here on YouTube: https://www.youtube.com/watch?v=1LXvuSt2D5I

Dive into Microsoft Fabric’s Power BI Direct Lake

Posted on by Annie D

Let’s break down Power BI Direct Lake in Microsoft Fabric and explain how you can leverage one copy of the data from OneLake. Patrick explains!

Direct Lake
https://learn.microsoft.com/power-bi/enterprise/directlake-overview

📢 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 – Continue reading “Dive into Microsoft Fabric’s Power BI Direct Lake” →