Category: Power Query

Leveraging OneLake Explorer – The OneDrive of Data! (Microsoft Fabric)

Posted on by Annie D

It’s been said that OneLake is the OneDrive of data in Microsoft Fabric! OneLake Explorer makes that even more so. Patrick walks you through how this works and how you can leverage it today!

OneLake File Explorer
https://learn.microsoft.com/fabric/onelake/onelake-file-explorer

📢 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 href="https://guyinacube.com" Continue reading “Leveraging OneLake Explorer – The OneDrive of Data! (Microsoft Fabric)” →

Embedding Excel Range in a Word Document – Strategic Finance Magazine July 2023

Posted on by Annie D

How to create a live link from an Excel workbook to a Word document.
This video is to accompany the article in the July 2023 issue of Strategic Finance Magazine: https://www.sfmagazine.com/articles/2023/july/excel-embedding-a-range-in-a-word-document

Excel Improvements To Picture In Cell – 2608

Posted on by Annie D

Microsoft Excel Tutorial: Adding Filterable Text to a Picture in Cell

The new Picture in Cell feature would not work with the Filter drop-downs. A new feature allows you to add text to each picture using the Alt Text panel. This Alt Text will appear in the Filter drop-downs, in XLOOKUP results, in the Pivot Table Filter, and in Pivot Table Slicers.

To download this workbook: https://www.mrexcel.com/youtube/xZxKhm9_Xkk/

Table of Contents
(0:00) Problem Statement: Filtering by Picture
(0:53) Use Alt Text to add Text to Picture in cell
(1:17) Alt Text appears in Filter drop-down
(1:44) Getting Picture from XLOOKUP
(2:15) Use Image in Continue reading “Excel Improvements To Picture In Cell – 2608” →

Create MEANINGFUL data labels with measures in Power BI

Posted on by Annie D

Tired of the usual text data labels that only have one value? Looking for something different? Patrick shows you how to customize your data labels using DAX in your Power BI reports!

📢 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 “Create MEANINGFUL data labels with measures in Power BI” →

Can you use Power Query Dynamic M Parameters for multi-select?

Posted on by Annie D

Dynamic M parameters in Power Query isn’t anything new. However, Patrick was challenged with using them to allow for multi-select and “select all” with a slicer in a Power BI report. Will he succeed?

Dynamic M query parameters in Power BI Desktop
https://learn.microsoft.com/power-bi/connect-data/desktop-dynamic-m-query-parameters

📢 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
— Continue reading “Can you use Power Query Dynamic M Parameters for multi-select?” →

SQL Server in Microsoft Fabric? Use CETaS to move data!

Posted on by Annie D

People have been asking “What about SQL Server?” with regards to Microsoft Fabric. Bob Ward joins us to show a way you can get your SQL data into Fabric with CETaS and the power of shortcuts in OneLake. And, then use that data in Power BI!

CREATE EXTERNAL TABLE AS SELECT (CETAS) (Transact-SQL)
https://learn.microsoft.com/sql/t-sql/statements/create-external-table-as-select-transact-sql?view=sql-server-ver16&tabs=powershell

Microsoft SQL, Data Virtualization and Microsoft Fabric (Slides)
https://aka.ms/sqlfabricdemo

Bob Ward:
https://twitter.com/bobwardms
https://www.linkedin.com/in/bobwardms/

📢 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 Continue reading “SQL Server in Microsoft Fabric? Use CETaS to move data!” →

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

Posted on by Annie D

Join us live as we answer your questions about Microsoft Fabric (including Power BI)!

💥 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 to take your Power BI skills to the next level? We have training courses available Continue reading “🔴 Microsoft Fabric/Power BI Q&A – LIVE (June 24, 2023) (Member Chat 2nd Half)” →

Digging into DYNAMIC format strings for DAX Measures in Power BI

Posted on by Annie D

DYNAMIC format strings recently were made available for DAX Measures in Power BI Desktop! Zoe walks us through how you can use these to enhance your reports!

Create dynamic format strings for measures
https://learn.microsoft.com/power-bi/create-reports/desktop-dynamic-format-strings

Zoe Douglas
https://www.linkedin.com/in/zoedouglas-data/
https://twitter.com/DataZoePowerBI

📢 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
— rel=”nofollow”>https://www.instagram.com/guyinacube/
— https://guyinacube.com

***Gear***
🛠 Check out my Tools page – https://guyinacube.com/tools/

#PowerBI #MicrosoftFabric #GuyInACube

Get the most as a Data Scientist with Microsoft Fabric (Public Preview)

Posted on by Annie D

Going down the DATA SCIENCE path can be hard when trying to get all the right data. Microsoft Fabric breaks down barriers and allows for easy reuse of data with OneLake. Nellie joins to talk about how data scientists can take advantage!

What is Data Science in Microsoft Fabric?
https://learn.microsoft.com/fabric/data-science/data-science-overview

Develop, execute, and manage Microsoft Fabric notebooks
https://learn.microsoft.com/fabric/data-engineering/author-execute-notebook?toc=%2Ffabric%2Fdata-science%2Ftoc.json&bc=%2Ffabric%2Fdata-science%2Fbreadcrumb%2Ftoc.json

How to accelerate data prep with Data Wrangler in Microsoft Fabric
https://learn.microsoft.com/fabric/data-science/data-wrangler

Nellie Gustafsson
https://twitter.com/nelliegson
https://www.linkedin.com/in/nelliegustafsson/

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

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

Want to take your Power BI skills to the next level? We have Continue reading “Get the most as a Data Scientist with Microsoft Fabric (Public Preview)” →

Your data is in the Lakehouse, but now what? | Microsoft Fabric (Public Preview)

Posted on by Annie D

You’ve got your data into OneLake and a Lakehouse, but now what? What can you do with that data after you’ve landed it in Microsoft Fabric? Justyna walks us through different areas where you can leverage your data throughout fabric. From data warehouses to even Power BI!

What is Data engineering in Microsoft Fabric?
https://learn.microsoft.com/fabric/data-engineering/data-engineering-overview

What is Spark compute in Microsoft Fabric?
https://learn.microsoft.com/fabric/data-engineering/spark-compute

Develop, execute, and manage Microsoft Fabric notebooks
https://learn.microsoft.com/fabric/data-engineering/author-execute-notebook

OneLake shortcuts
https://learn.microsoft.com/fabric/onelake/onelake-shortcuts

Justyna Lucznik
https://twitter.com/JustynaLucznik
https://www.linkedin.com/in/justyna-lucznik/

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

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

Want to take your Power BI skills to Continue reading “Your data is in the Lakehouse, but now what? | Microsoft Fabric (Public Preview)” →

Excel For The Infection Preventionist – Preview of APIC Pre-Conference

Posted on by Annie D

The Association for Professionals in Infection Control and Epidemiology is holding their annual conference in Orlando June 26-28, 2023. I will be presenting a half-day pre-conference session on Sunday June 25, 2023 from 8 AM to 1 PM.

My goal in the session is to make you more comfortable with Microsoft Excel. In this preview, I download data from the CDC, do some simple clean-up. I use a few Excel formulas to add some useful metrics. I then display the results on a Map in Microsoft Excel.

Everyone who attends my session receives a copy of my book, MrExcel 2021 – Unmasking Continue reading “Excel For The Infection Preventionist – Preview of APIC Pre-Conference” →

🔴 Microsoft Fabric/Power BI Q&A – LIVE (June 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)!

💥 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 to take your Power BI skills to the next level? We have training courses available Continue reading “🔴 Microsoft Fabric/Power BI Q&A – LIVE (June 17, 2023) (Member Chat 2nd Half)” →