Category: Power Query

Using Microsoft Fabric Workspaces (Power BI and more!)

Posted on by Annie D

Workspaces are a way to organize and manage content within Microsoft Fabric. This includes Power BI content. Adam walks you through what Workspaces are all about and different options available.

Workspaces
https://learn.microsoft.com/fabric/get-started/workspaces

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

Workspaces in Power BI
https://learn.microsoft.com/power-bi/collaborate-share/service-new-workspaces

📢 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 href="http://www.facebook.com/guyinacube" Continue reading “Using Microsoft Fabric Workspaces (Power BI and more!)” →

Excel Adds Python Editor 27 Days After Python Debuts – Episode 2625

Posted on by Annie D

Microsoft Excel Tutorial: Microsoft Labs in Cambridge releases a great Python editor for Excel.

Just 27 days after Python preview appears in Excel, Microsoft has added a dramatically better Python editor.

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

This new editor in the task pane offers AutoComplete, Intellisense, and automatic code coloring. Take a walkthrough the editor in today’s video.

#excel
#microsoft
#microsoftlabs
#microsoftexcel
#exceltricks
#excelpython
#microsoft365
#walkthrough

Buy Bill Jelen’s latest Excel book: https://www.mrexcel.com/products/latest/

Table of Contents
(0:00) Python Editor Added to Excel
(0:10) Free Silo Photos
(0:20) Theories on backstory
(0:59) Get Add-Ins moving from Insert to Home tab
(1:22) Update Excel Labs add-in twice
(1:49) Open Excel Labs & Continue reading “Excel Adds Python Editor 27 Days After Python Debuts – Episode 2625” →

Excel – Oracle Sending Dates as Text MMM-YY Episode 2624 #excel #pivot_table #excelhacks

Posted on by Annie D

Microsoft Excel Tutorial: Sorting months in a pivot table when they are alphabetic.

I met people who are downloading data from Oracle through Analysis Services. Their dates are coming in as text in the format of Sep-20 for September 2020. When they create pivot tables, the months are alphabetic instead of sequential.

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

There are two ways to solve it:
1) A convolunted method from Sam Radakovitz that you only have to do once
2) A simple method that you will have to do 1000 times a year.

In this episode, I show Sam Rad’s method of Continue reading “Excel – Oracle Sending Dates as Text MMM-YY Episode 2624 #excel #pivot_table #excelhacks” →

Excel Hack Use Filter Search Box to Remove Items from Filter! – Episode 2623 #excel #excelhacks

Posted on by Annie D

Microsoft Excel Tutorial: How to use Excel’s Filter Search Box to remove items from Filter.

Melvin from Orlando shared a great Excel trick with me during yesterday’s live Power Excel seminar in Daytona Beach.

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

We all know you can use the Filter drop-down Search Box to find all cells that contain Apple. But what if you want everything that does not contain Apple? Rather than use the old Text Filters for Does Not Contain, you can use this great trick from Melvin:
1. Search for Apple
2. Uncheck Select All Items
3. Check Add Current Continue reading “Excel Hack Use Filter Search Box to Remove Items from Filter! – Episode 2623 #excel #excelhacks” →

Excel Sum Across Sheets When Rows Do Not Line Up – Episode 2622

Posted on by Annie D

Microsoft Excel Tutorial: Sum across worksheets when rows do not line up?

Today’s question from Rebaz on podcast 1984 – Excel Sum Across Worksheets: “if we have different cell in different sheet, how can I Sum?”

Download the workbook from today: https://www.mrexcel.com/youtube/UO11Ase1_Ys/

This video shows you an easy way to build a 3-D reference in Excel, also known as a spearing formula. Excel functions include SUM, XLOOKUP, FILTER, SUMIFS, TEXTJOIN, TEXTSPLIT, SUMPRODUCT, Helper Arrays, LET, Python in Excel, and VSTACK.

Table of Contents
(0:00) Problem: Adding Across Sheets that are not lined up
(0:43) How to build a 3-D Reference
(1:19) Does XLOOKUP work Continue reading “Excel Sum Across Sheets When Rows Do Not Line Up – Episode 2622” →

No more Report Builder for Power BI Paginated Reports???

Posted on by Annie D

Not a fan of Power BI Report Builder? Still want to use Paginated reports? Patrick shows the new Paginated authoring experience within the service! It’s BANANAS!

Low code authoring of paginated reports
https://powerbi.microsoft.com/blog/low-code-authoring-of-paginated-reports/

Create paginated reports that you can export in the Power BI service
https://learn.microsoft.com/power-bi/paginated-reports/web-authoring/paginated-formatted-table

📢 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 “No more Report Builder for Power BI Paginated Reports???” →

Landing data with Dataflows Gen2 in Microsoft Fabric

Posted on by Annie D

Pipelines are cool in Microsoft Fabric, but how could we use Dataflows to get data into our Data Warehouse? Patrick shows another way to move your data with just a few clicks!

📢 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 “Landing data with Dataflows Gen2 in Microsoft Fabric” →

Creating your first Data Warehouse in Microsoft Fabric

Posted on by Annie D

It’s time to show the Data Warehouse within Microsoft Fabric some love! Patrick walks you through how you can get started with your first Data Warehouse using Data Pipelines.

What is data warehousing in Microsoft Fabric?
https://learn.microsoft.com/fabric/data-warehouse/data-warehousing

Microsoft Fabric decision guide: data warehouse or lakehouse
https://learn.microsoft.com/fabric/get-started/decision-guide-warehouse-lakehouse?toc=%2Ffabric%2Fdata-warehouse%2Ftoc.json&bc=%2Ffabric%2Fdata-warehouse%2Ftoc.json

Data warehouse tutorial introduction
https://learn.microsoft.com/fabric/data-warehouse/tutorial-introduction

Ingest data into the Warehouse
https://learn.microsoft.com/fabric/data-warehouse/ingest-data

📢 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 “Creating your first Data Warehouse in Microsoft Fabric” →

Excel Python Appending Data Frames From Multiple Worksheets – Episode 2621

Posted on by Annie D

Microsoft Excel Tutorial: Appending data from multiple worksheets using Python in Excel

To download today’s workbook: https://www.mrexcel.com/youtube/3rAJPcjO6Ok/

Today, a question about creating a Python data frame from multiple Excel sheets. I use the CONCAT function in Python but then realize that the headings are repeated.
So I show how to use .tail(-1) to remove the top row from each data frame except the first.

Table of Contents
(0:00) Problem Statement
(0:29) Defining 3 data frames
(1:32) Python CONCAT function
(2:20) Python Tail Function
(3:10) Wrap-up

A quirky Bookmark scenario with Filters in Power BI. Pay Attention!

Posted on by Annie D

A question came up about why bookmarks weren’t working and how to solve a particular scenario regarding filters in Power BI. Adam shows how to solve this and uses a little DAX to do 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 Continue reading “A quirky Bookmark scenario with Filters in Power BI. Pay Attention!” →

Excel Python 3D Scatterplot – Episode 2620

Posted on by Annie D

Microsoft Excel Tutorial – Drawing a 3D Scatterplot using Python in Excel

Download the workbook: https://www.mrexcel.com/youtube/TMyAAxbUU7s/

How to plot a circle in an Excel XY Chart
Converting degrees to radians in Excel
Building X, Y, Z values for a series of circles in Excel
Using Chat-GPT for Python Code for a 3D Scatter Plot
Adapting the copied code
Marker choices for Python Charts

Table of Contents
(0:00) Problem Statement – 3D Scatterplot in Python
(0:14) Excel formulas to plot a circle in Excel
(0:45) Convert degrees to Radians in Excel
(1:15) Formulas to Create a 3D Spiral in Excel
(2:45) Finding Python code from Chat-GPT
(3:10) Adapting Python code for Excel
(4:45) Continue reading “Excel Python 3D Scatterplot – Episode 2620” →

Wait! We can use Databricks data with Microsoft Fabric???

Posted on by Annie D

Ready to learn how you can use Databricks with Microsoft Fabric? Patrick shows you how you can integrate the data and enable the MAGIC of Fabric while leveraging your existing Databricks implementation.

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

📢 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/

#MicrosoftFabric #Databricks #GuyInACube