Category: Power Query

9 hidden gems about On-Object Editing in Power BI

Posted on by Annie D

On-Object editing in Power BI has had a ton of updates! Adam walks through 9 hidden gems you probably didn’t know about using it. You definitely want to see the last one!

Power BI December 2023 Feature Summary
https://powerbi.microsoft.com/en-us/blog/power-bi-december-2023-feature-summary/

Use on-object interaction with visuals in your report (preview)
https://learn.microsoft.com/power-bi/create-reports/power-bi-on-object-interaction

📢 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
— <a href="http://twitter.com/patrickdba" Continue reading “9 hidden gems about On-Object Editing in Power BI” →

Thinking about your DAX Queries like a SQL Query in Power BI

Posted on by Annie D

Coming to Power BI with SQL experience? Trying to learn DAX? Patrick shows you how to think about your DAX Queries like a SQL Query in Power BI. We hope this helps you to create DAX Queries that are much more accurate and effective!

📢 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 Continue reading “Thinking about your DAX Queries like a SQL Query in Power BI” →

Create a measure from a filtered visual in Power BI? Of Course, you can!

Posted on by Annie D

A live stream question asked if you could create a DAX measure from a filtered visual in a Power BI report. Of course, you can! Patrick uses the new DAX Query view in Power BI Desktop to show you how.

📢 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/
— <a Continue reading “Create a measure from a filtered visual in Power BI? Of Course, you can!” →

Exploring Custom Spark Pools in Microsoft Fabric Lakehouses

Posted on by Annie D

With Microsoft Fabric Lakehouses you begin with a starter pool for Spark. Patrick shows how you can create custom pools and have those as the default for your workspace.

Configuring starter pools in Microsoft Fabric
https://learn.microsoft.com/fabric/data-engineering/configure-starter-pools

How to create custom Spark pools in Microsoft Fabric
https://learn.microsoft.com/fabric/data-engineering/create-custom-spark-pools

📢 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 Continue reading “Exploring Custom Spark Pools in Microsoft Fabric Lakehouses” →

Boost your productivity with DAX Query View in Power BI Desktop!

Posted on by Annie D

Discover the latest INSANE AMAZING announcement in Power BI Desktop – the new DAX Query View! Join Patrick as he shares his excitement about this feature that allows you to run DAX queries directly in Power BI. Although he still loves DAX Studio and Tableau Editor, Patrick explains why the DAX Query View is a game-changer. Don’t forget to subscribe for more Power BI updates!

Work with DAX query view
https://learn.microsoft.com/en-us/power-bi/transform-model/dax-query-view

Power BI November 2023 Feature Summary
https://powerbi.microsoft.com/en-us/blog/power-bi-november-2023-feature-summary/#post-25061-_Toc150157949

Deep dive into DAX query view and writing DAX queries
https://powerbi.microsoft.com/en-us/blog/deep-dive-into-dax-query-view-and-writing-dax-queries/

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

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

Want Continue reading “Boost your productivity with DAX Query View in Power BI Desktop!” →

Let’s look at using some PySpark in your first Microsoft Fabric Notebook

Posted on by Annie D

Not sure about Notebooks or PySpark in Microsoft Fabric? Simon Whitely joins us to help get you started and to demystify what it’s all about. He uses some SQL also!

How to use Microsoft Fabric notebooks
https://learn.microsoft.com/fabric/data-engineering/how-to-use-notebook

Use a notebook to load data into your Lakehouse
https://learn.microsoft.com/fabric/data-engineering/lakehouse-notebook-load-data

Simon Whiteley
https://www.advancinganalytics.co.uk/
https://www.youtube.com/@AdvancingAnalytics
https://twitter.com/MrSiWhiteley
https://www.linkedin.com/in/simon-whiteley-uk/

📢 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 “Let’s look at using some PySpark in your first Microsoft Fabric Notebook” →

Excel Publish Any Excel Logic As Web App Using Sheetcast While Protecting Your IP – Episode 2635

Posted on by Annie D

Microsoft Excel Tutorial: Embed any Excel Logic in a Web App Using Sheetcast.com.

Try this web app now to search my videos: https://c07.sheetcast.com/view/c79f93d2-0dcf-441f-97ac-b0c100f02a4f/~/d174333f-e3fe-4b14-a13b-ef6e384af5bb?embed=True&expand=true&showTitle=true

Welcome to episode 2635 of the MrExcel podcast! It’s been 25 years since I started sharing my Excel tips and tricks with all of you, and I couldn’t be more grateful for your support. Today, I have something truly amazing to show you – how to publish any Excel logic as a web app using Sheetcast while protecting your intellectual property. Plus, I’ll also be sharing how you can search through 25 years of MrExcel content Continue reading “Excel Publish Any Excel Logic As Web App Using Sheetcast While Protecting Your IP – Episode 2635” →

Excel – Review 2400 YouTube Thumbnails Using 2 New Excel Functions – Episode 2634

Posted on by Annie D

Microsoft Excel Tutorial: Quickly download YouTube Thumbnails into Excel.

TubeBuddy Link: https://www.Tubebuddy.com/pricing?a=mrexcel

Formula for Edit Hyperlink: =HYPERLINK(“https://studio.youtube.com/video/“&B2&”/edit”,”Edit”)
Formula to Wrap Thumbnails into 9 columns: =WRAPROWS(FILTER(F2:F2417,G2:G2417=1),9)

Welcome to episode 2634 of MrExcel’s Net Cast! In this video, we will be exploring two new Excel functions that will help us quickly review over 2400 YouTube thumbnails. As we approach the 25th anniversary of MrExcel, I am grateful for the opportunity to connect with friends and followers from around the world through 67 books, thousands of articles, over 5 million posts on our message board, and 2400 videos on YouTube. If Continue reading “Excel – Review 2400 YouTube Thumbnails Using 2 New Excel Functions – Episode 2634” →

Digging deeper into Data Activator in Microsoft Fabric

Posted on by Annie D

We look deeper at Data Activator in Microsoft Fabric with Will Thompson. He shows us how to work with real time data and also how you can leverage Power Automate from Power Platform to take action.

What is Data Activator?
https://learn.microsoft.com/fabric/data-activator/data-activator-introduction

Assign data to objects in Data Activator
https://learn.microsoft.com/fabric/data-activator/data-activator-assign-data-objects

Use Custom Actions to trigger Power Automate Flows
https://learn.microsoft.com/fabric/data-activator/data-activator-trigger-power-automate-flows

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

— Continue reading “Digging deeper into Data Activator in Microsoft Fabric” →

Leverage OneLake with Azure Databricks

Posted on by Annie D

Want to start using Azure Databricks with OneLake in Microsoft Fabric? Patrick walks you through how to get this working! Storing the data in OneLake opens up a lot of other possibilities.

Using Azure Databricks with Microsoft Fabric and OneLake
https://blog.fabric.microsoft.com/blog/using-azure-databricks-with-microsoft-fabric-and-onelake

Integrate OneLake with Azure Databricks
https://learn.microsoft.com/fabric/onelake/onelake-azure-databricks

📢 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 “Leverage OneLake with Azure Databricks” →

Excel – First Look at Amazing GroupBy PivotBy PercentOf Functions in Excel – Episode 2633

Posted on by Annie D

Microsoft Excel Tutorial: Three New Functions Debut in Excel: GROUPBY, PIVOTBY, and PERCENTOF.

To download the workbook from today: https://www.mrexcel.com/youtube/6jP7DflN4sw/

Read the Microsoft Announcement: https://techcommunity.microsoft.com/t5/excel-blog/new-aggregation-functions-groupby-and-pivotby/ba-p/3965765

Welcome to episode 2633 of MrExcel’s netcast, where we explore the latest and greatest features of Microsoft Excel. In this episode, we will take a first look at three new functions: GROUPBY, PIVOTBY, and PERCENT OF. These functions are incredibly simple to use, yet offer deep options for data analysis. So let’s dive in and see what they can do!

First up, we have GROUPBY. This function allows us to group data by Continue reading “Excel – First Look at Amazing GroupBy PivotBy PercentOf Functions in Excel – Episode 2633” →

Excel New Check Performance To Reduce Excel File Size – Episode 2632

Posted on by Annie D

Microsoft Excel Tutorial: A new Check Performance Feature debuts in Excel to clean excess cell formatting that can cause large file sizes.

Welcome to episode 2632 of MrExcel’s Net Cast! In this video, we’ll be discussing a new feature in the Windows version of Excel that has been available in Excel online for some time now. It’s called Check Performance and it can help you clean up unwanted cell formats and reduce file sizes. This feature can be found on the Review tab and is definitely worth checking out for any workbook that you’ve been using for years.

Now, before you go Continue reading “Excel New Check Performance To Reduce Excel File Size – Episode 2632” →