Category: Power BI

How To Use Natural Language Query (Q&A) In Power BI – Detailed Review [2022 Update]

Posted on by Annie D

The Natural Language Query (Q&A) feature is an incredible evolution in data analytics and its functionality within Power BI is amazing.

In this video, Sam showcases what you can achieve and how you can practically use Q&A within your organizations. The Q&A feature is the real deal and is not just some marketing hype. All it takes is developing great Power BI models and then knowing how to effectively use it.

***** Video Details *****
00:00 Introduction
04:12 Working with measure tables
05:15 Using selections in combination with Q&A
06:20 Recreating reports with advanced DAX formulas
08:57 Using Q&A to get information quickly

***** Learning Power BI? ***** Continue reading “How To Use Natural Language Query (Q&A) In Power BI – Detailed Review [2022 Update]” →

How To Add Comments To A Power Automate Desktop Flow

Posted on by Annie D

In today’s tutorial, Jarrett shows how you can add comments to a Power Automate Desktop flow. It might be a simple concept but here is a little bit of a process in order to do this because there’s no feature in how Power Automate is currently setup that enables you to add comments to your flow steps. This technique is going to come in handy when you need to leave an audit trail for a smooth onboarding or transition in case you need to turnover the flow to someone else in your organization.

***** Video Details *****
00:00 Introduction
01:23 Example scenarios
03:30 Flow Continue reading “How To Add Comments To A Power Automate Desktop Flow” →

Taking On Excel BI’s Alphabets To Columns Power Query Challenge

Posted on by Annie D

In this video, Melissa shares her solution for the Excel BI’s Alphabets to Columns Challenge. The task is to turn the single column table into a table where each letter has its own column, and is repeated as many times as it’s present in the source table as well.

Excel BI Power Query Challenge 3: https://bit.ly/3NeKw8y

***** Video Details *****
00:00 Introduction
01:33 Creating variables
05:15 Bill’s solution

***** 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 “Taking On Excel BI’s Alphabets To Columns Power Query Challenge” →

🔴 Power BI tips from the Pros – LIVE (Oct 29, 2022) (Member Chat 2nd Half)

Posted on by Annie D

Join us live as we answer your questions about 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 to help you Continue reading “🔴 Power BI tips from the Pros – LIVE (Oct 29, 2022) (Member Chat 2nd Half)” →

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]” →