Blog

Why not a date and time table in Power BI instead?

We had a video talking about creating a Date and Time table in your Microsoft Fabric Warehouse. There were some comments centered around “why”??? Why not do that in Power BI? Patrick shows you!

📢 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 Continue reading “Why not a date and time table in Power BI instead?”

A Few Ways GENERATE_SERIES Will Revolutionize Your Microsoft Fabric Warehouse Experience

Want to create a series of data within a Microsoft Fabric Warehouse? Patrick looks at how GENERATE_SERIES can help you instead of doing INSERT after INSERT which doesn’t perform well.

Scripts: https://github.com/guyinacube/demo-files/blob/master/video%20demos/Fabric/20241017%20-%20Generate%20Series.zip

GENERATE_SERIES (Transact-SQL)
https://learn.microsoft.com/sql/t-sql/functions/generate-series-transact-sql?view=sql-server-ver16

GENERATESERIES – DAX Function
https://dax.guide/generateseries/

Brad Schacht
https://x.com/BradleySchacht
https://www.linkedin.com/in/bradleyschacht/

📢 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 “A Few Ways GENERATE_SERIES Will Revolutionize Your Microsoft Fabric Warehouse Experience”

Reframe your Power BI Direct Lake Semantic Model

Want to know how to make sure you see the latest data when using Direct Lake in your Power BI semantic models? Patrick shows you two options you have and looks at the concept of reframing.

Direct Lake
https://learn.microsoft.com/fabric/get-started/direct-lake-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/
— <a Continue reading “Reframe your Power BI Direct Lake Semantic Model”

REPLAY Microsoft Fabric / Power BI Q&A – LIVE (June 29, 2024)

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 “REPLAY Microsoft Fabric / Power BI Q&A – LIVE (June 29, 2024)”

Unlock Data Factory Power with Existing Connections

Minimize the clicks you take when setting up connections within Data Factory pipelines to get data QUICKLY! Patrick shows you different ways you can leverage existing connections that you’ve already set up within Pipelines in Microsoft Fabric.

📢 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 “Unlock Data Factory Power with Existing Connections”

Leverage Power Query Parameters with Power BI Paginated reports

You’ve seen how you can use Power Query within Power BI Paginated reports. Now Patrick shows you how you can leverage parameters to drive interactivity!

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

#PowerBI #Paginated #GuyInACube

How to create a slick way to adjust your Power BI visual

Create a slick way to adjust your visual by way of bookmarks leveraging the Navigation button. Adam shows you how to set this approach up to get a nice look and feel.

📢 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 “How to create a slick way to adjust your Power BI visual”

Excel Introduces TRANSLATE and DETECTLANGUAGE Functions – Episode 2645

Microsoft Excel Tutorial: Excel Introduces TRANSLATE and DETECTLANGUAGE Functions.

Unlock the Power of Excel’s New Functions: TRANSLATE and DETECTLANGUAGE

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

Hey Excel enthusiasts! If you found this video helpful, don’t forget to click Like down below. It helps more people discover this content. In this video, we’re diving into two amazing new Excel functions: TRANSLATE and DETECTLANGUAGE. These functions are game-changers, making it easier than ever to work with different languages in Excel.

First up, the TRANSLATE function. This powerful tool allows you to translate any text from one language to another effortlessly. Just enter Continue reading “Excel Introduces TRANSLATE and DETECTLANGUAGE Functions – Episode 2645”

Microsoft Revokes excelisfun MVP Status!

Today, July 10, 2024, I got a letter from Microsoft that says I am no longer an Excel MVP. I posted about the same number of videos, files and free classes as the year before. I just passed 1,00,000 subscribers. I give everything away for free. But Microsoft says: NO MVP for excelisfun. So be it. I will keep making Excel and Power BI videos because it is fun!!!

Amazing XLOOKUP Formula with Lookup Value From Within Description: Excel Magic Trick 1860

Download Excel File: https://excelisfun.net/files/EMT1860.xlsx
Learn how to extract a lookup value from a description and use it to lookup a value without getting an error.
Topics:
1. (00:00) Introduction
2. () Use lookup value from description to lookup a value. MID function and XLOOKUP with Plus Zero.
3. () Summary
4. (02:32) Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftexcel #microsoftmvp #xlookup #exceltips

UNIQUE-SORT, not SORT-UNIQUE: Killer Array Formula Trick That Everyone Should Know. EMT 1861

Download Excel File: https://excelisfun.net/files/EMT1861.xlsx
Download Timing Test file: https://excelisfun.net/files/EMT1861TestResults.xlsx
When extracting a sorted unique list with a formula, it is more efficient to use UNIQUE-SORT, rather than SORT-UNIQUE.
Topics:
1. (00:00) Introduction
2. SORT-UNIQUE combination tends to calculate slowly.
3. UNIQUE-SORT tends to calculate quickly.
4. () Summary
5. (02:32) Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftexcel #microsoftmvp #sort #unique #arrayformulas #excelarrys #dynamicspilled arrays