Category: Power BI

Does it matter where your Power BI reports are deployed?

Posted on by Annie D

Where to deploy your Power BI Report? My Workspace? Regular Workspace? What about Apps? Adam breaks it down to help you make the right choice and understand why it matters!

📢 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 Continue reading “Does it matter where your Power BI reports are deployed?” →

How To Automatically Save Email Attachments To SharePoint With Power Automate

Posted on by Annie D

In this tutorial, Jarrett is going to demonstrate how to save email attachments directly to Sharepoint with Power Automate online. This trick will help save you the time and brain space from doing menial tasks such as manually downloading files files from numerous emails and uploading on Sharepoint.

***** Video Details *****
00:00 Introduction
03:51 Template
05:12 Overview
07:26 Creating a flow
07:42 When a new email arrives
08:40 Moving attachments
10:47 Deleting email

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – Power Continue reading “How To Automatically Save Email Attachments To SharePoint With Power Automate” →

Make Q&A more effective in Power BI

Posted on by Annie D

Most struggle with getting Q&A to be effective in Power BI. Usually this comes down to either model naming or synonyms. Patrick shows you how you can update these and also a nice feature to let you share them with others.

📢 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/
— Continue reading “Make Q&A more effective in Power BI” →

Using ALLSELECTED – DAX Formula Concepts In Power BI [2022 Update]

Posted on by Annie D

ALLSELECTED is a complex DAX function in Power BI. In this tutorial, Sam shows how to use this function when creating calculations in Power BI and get to understand the difference between the ALL and ALLSELECTED functions in DAX.

***** Video Details *****
00:00 Introduction
00:28 What is ALLSELECTED
00:46 Using ALLSELECTED in Cumulative Sales
01:59 Difference in context between ALLSELECTED and ALL
03:00 Visualization of ALLSELECTED vs ALL
04:24 Using ALLSELECTED in SUMX

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE Continue reading “Using ALLSELECTED – DAX Formula Concepts In Power BI [2022 Update]” →

Deneb Cheat Sheet For Power BI – FREE Download

Posted on by Annie D

Deneb is a pretty awesome visual tool for folks who want more visualization opportunities in Power BI aside from the native visuals.

As Deneb is code-based, familiarity will be a helpful thing. So to get the most out of Deneb and to make learning easier, our Deneb master, Greg Philps, has developed a cheat sheet that you can conveniently refer to. Watch as Greg gives an extensive demo on what you can expect from this cheat sheet.

The Deneb Cheat Sheet for is available for FREE to Enterprise DNA subscribers.

Download the Deneb Cheat Sheet here: https://www.enterprisedna.co/power-bi-resources

***** Learning Continue reading “Deneb Cheat Sheet For Power BI – FREE Download” →

Deneb Cheat Sheet For Power BI – FREE Download

Posted on by Annie D

Deneb is a pretty awesome visual tool for folks who want more visualization opportunities in Power BI aside from the native visuals.

As Deneb is code-based, familiarity will be a helpful thing. So to get the most out of Deneb and to make learning easier, our Deneb master, Greg Philps, has developed a cheat sheet that you can conveniently refer to. Watch as Greg gives an extensive demo on what you can expect from this cheat sheet.

The Deneb Cheat Sheet for is available for FREE to Enterprise DNA subscribers.

Download the Deneb Cheat Sheet here: https://www.enterprisedna.co/power-bi-resources

***** Learning Power Continue reading “Deneb Cheat Sheet For Power BI – FREE Download” →

How To Filter By A Specific First Letter Or Character In Power Query

Posted on by Annie D

In this video, Melissa demonstrates a couple of approaches in solving Excel BI’s Table Filter Challenge. The goal is to filter out names where the 2nd word starts with the letter “C”.

Excel BI’s Table Filter Challenge: https://bit.ly/3TohSEm

***** Video Details *****
00:00 Introduction
01:06 1st approach
03:01 2nd approach
03:44 Split words into a list

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – http://www.enterprisedna.co/power-bi-resources
FREE – 60 Page Continue reading “How To Filter By A Specific First Letter Or Character In Power Query” →

How To Compare Performance Using The ALL Function In Power BI [2022 Update]

Posted on by Annie D

There will come a time that you would want and need to compare performance by looking at a particular selection in your dataset versus the overall result. This is where the ALL function in DAX comes in. In this tutorial, Sam shows you how easily and effectively find differentials in your data by using the ALL function.

***** Video Details *****
00:00 Introduction
00:53 Getting the average order size
03:01 Comparing the average order size
04:12 Differentiating the average order size

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide Continue reading “How To Compare Performance Using The ALL Function In Power BI [2022 Update]” →

A better way to share Personal Bookmarks in Power BI

Posted on by Annie D

A while back Adam shared how you can share a personal bookmark with others. There is now a better way to share personal bookmarks in Power BI if your report is in a workspace. Learn how!

Share Power BI reports and dashboards with coworkers and others
https://learn.microsoft.com/power-bi/collaborate-share/service-share-dashboards

Alternative to sharing a Power BI Personal Bookmark
https://www.youtube.com/watch?v=-c1-VQ6RsrA

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

— rel=”nofollow”>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 #Bookmarks #GuyInACube

Why isn’t my Agg being hit in Power BI???

Posted on by Annie D

There are different reasons why your Agg isn’t being hit in Power BI. In this video, Patrick looks at a specific reason based on the DAX functions you are using. Gotta watch out!

📢 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 “Why isn’t my Agg being hit in Power BI???” →

How To Use ECDF Plots With Python And Power BI

Posted on by Annie D

In this video, Gaelim demonstrates how to use a Cumulative Distribution Plot also know as Empirical Cumulative Distribution Function (ECDF) Plot, and showcase the advantages of using this variation of plot over other plot types.

***** Video Details *****
00:00 Introduction
00:34 Kinds of distribution plots
04:34 Histogram plot code
06:07 KDE plot code
06:23 Box plot code
06:50 ECDF plot code
08:05 Styling plots

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – http://www.enterprisedna.co/power-bi-resources
FREE – Continue reading “How To Use ECDF Plots With Python And Power BI” →

Best Practice Tips For Using The Advanced Editor In Power BI [2022 Update]

Posted on by Annie D

In this tutorial, Sam runs through some of his best practice tips for using the query editor in Power BI. The query editor is undoubtedly important in Power BI, but it is so hidden away that those who are just starting out might not easily know that it exists. Power BI users will ultimately need to learn how to use it, and use it well. Check out Sam’s tips to help you navigate the query editor efficiently.

***** Video Details *****
00:00 Introduction
00:50 Using the query editor
04:14 Making changes in the editor
05:08 Fixing the error

***** Learning Power BI? *****
FREE COURSE – Continue reading “Best Practice Tips For Using The Advanced Editor In Power BI [2022 Update]” →