Blog

🔴 Microsoft Fabric / Power BI Q&A – LIVE (April 6, 2024) (Member Chat 2nd Half)

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

Connect with Brad Schacht:
https://twitter.com/bradleyschacht
rel=”nofollow”>https://www.linkedin.com/in/bradleyschacht/
https://bradleyschacht.com/

Connect with Scott Sewell:
https://twitter.com/scottsewell
https://www.youtube.com/@MSFT_ScottSewell
https://www.linkedin.com/in/mscottsewell/

📢 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 – https://guyinacube.com/tools/

#MicrosoftFabric #PowerBI #GuyInACube

Boost DAX Performance in Power BI with Dual Mode

Don’t ignore Dual Mode! If you are leveraging DirectQuery and Import in your Power BI semantic model, you could have some performance problems you aren’t aware of. Patrick shows you what’s going on!

📢 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 “Boost DAX Performance in Power BI with Dual Mode”

Wait!?! It’s the same data source! What’s going on???

Think you are using the same data source in Power BI? Maybe you aren’t? Patrick shows you how this can affect DAX Query performance and how to correct 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 out my Tools page – <a href="https://guyinacube.com/tools/" Continue reading “Wait!?! It’s the same data source! What’s going on???”

Create Beautiful Report Templates with PowerPoint

Build a minimalistic report in PBI with PowerPoint template and icons.

Details of what you will learn during this video:
– Learn basic tips & tricks to handle different shapes in PowerPoint. 
– Apply artistic effects to images to create glasmorphism style effects. 
– Use almost any background image to create beautiful templates. 
– Build a minimalistic report in PBI with PowerPoint template and icons. 
– Explore best custom theme generator to speed up Power BI development.

***** Learning with Enterprise DNA *****
FREE Courses – https://bit.ly/45fu3tw
FREE Resources – https://bit.ly/455Hw6O
Enterprise DNA On-Demand – https://app.enterprisedna.co/app
Enterprise DNA Subscriptions – <a Continue reading “Create Beautiful Report Templates with PowerPoint”

Copilot for Power BI: Your Ultimate Copilot Guide

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

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”

CALCULATE Deep Dive

Understand the difference between table functions and CALCULATE modifiers and how to use them correctly

Details of what you will learn during this video:
– Learn how to establish an order of evaluation in CALCULATE parameters
– Understand the difference between table functions and CALCULATE modifiers and how to use them correctly
– Evaluate a table expression in the context of a FILTER/CALCULATETABLE
– Observe how context transition is performed by operating the CALCULATE and CALCULATETABLE functions
– Discover how large data sets are transformed by nested CALCULATE functions and generate unexpected results

***** Learning with Enterprise DNA *****
FREE Courses – https://bit.ly/45fu3tw
FREE Resources Continue reading “CALCULATE Deep Dive”

Exploring Dynamic Subscriptions for Power BI reports

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

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”