Category: Power BI

How To Do Multiple Exact Match Text Replacements In Power Query

Posted on by Annie D

In this tutorial, Melissa will demonstrate a method on how to perform multiple exact text match replacements. If you’ve ever had this requirement, there’s a fair chance that you’ve performed a series of replace value steps. There are multiple ways to achieve this result, but Melissa will particularly show how to use the M function Record.FieldOrDefault for this specific use case.

***** Video Details *****
00:00 Introduction
00:49 Data set
01:00 Replacements
01:39 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 Continue reading “How To Do Multiple Exact Match Text Replacements In Power Query” →

Conditional Formatting with Field Parameters in Power BI???

Posted on by Annie D

You are excited about Field Parameters in Power BI, but then realize you can’t use conditional formatting with them. What the french toast! Don’t despair! Patrick and Adam have some ways to get this working.

Matthias K. Question
https://youtu.be/ksmNfa_K8GQ?t=1011

Let report readers use field parameters to change visuals (preview)
https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters

Apply conditional formatting in tables and matrixes
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting

📢 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 “Conditional Formatting with Field Parameters in Power BI???” →

The Tale of Two Caches

Posted on by Annie D

Want to optimize performance in Power BI? Of course, you do! In order to do that, you need to understand the two caches that are at play and how they affect your optimization efforts. Marco Russo helps explain!

DAX Studio 3
https://daxstudio.org

Connect with SQLBI:
Website: https://sqlbi.com
YouTube: https://www.youtube.com/sqlbi
Marco Russo: https://twitter.com/marcorus
Alberto Ferrari: https://twitter.com/FerrariAlberto

📢 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: rel=”nofollow”>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 #Performance #GuyInACube

Get More Productive In Power BI With These Speed Development Techniques

Posted on by Annie D

In this video, Sam is going to demonstrate what he thinks are the most efficient productivity techniques that can be readily applied in Power BI that can speed up your report development by up to 200-300%! He’ll tackle embedding custom backgrounds and using a totally customized theme.

***** Video Details *****
00:00 Introduction
01:20 Embedding a background
05:40 Custom theme

***** 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 Continue reading “Get More Productive In Power BI With These Speed Development Techniques” →

Merging your data in a modern lakehouse data warehouse

Posted on by Annie D

Learn how you can move your data through different tiers using MERGE either with pySpark or SQL in Azure Synapse Analytics. Stijn Wynants walks you through the different steps.

Stijn Wynants
https://twitter.com/SQLStijn

pyspark.sql.SparkSession.createDataFrame
https://spark.apache.org/docs/latest/api/python/reference/pyspark.sql/api/pyspark.sql.SparkSession.createDataFrame.html

Table deletes, updates, and merges
https://docs.delta.io/latest/delta-update.html#language-python

Delta Lake Documentation
https://docs.delta.io/latest/delta-intro.html

📢 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 “Merging your data in a modern lakehouse data warehouse” →

How To Quickly Add Dynamic SVG Visuals To Your Power BI Report

Posted on by Annie D

Brian shares a few tools and tricks that you can use to create excellent visualization in no time flat. In this video, he will focus on SVG visuals — these are typically difficult to create from scratch, but Brian shows how you can create these quickly and easily.

***** Video Details *****
00:00 Introduction
01:18 Data set
01:44 Data model
02:02 Monitor flag
02:24 Temperature flag
02:55 Gauge visual
04:55 Blinking dot
06:01 Flat line

***** 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 Quickly Add Dynamic SVG Visuals To Your Power BI Report” →

Get Inspired By These Excellent Power BI Examples — Innovative Techniques And Cool Features!

Posted on by Annie D

In this video, Sam showcases some reports with innovative techniques and nifty features that have recently been added in our Power BI Showcase gallery, which we hope can give you inspiration and ideas for your next Power BI report.

These showcases are definitely some of the most ingenious reports you’ll probably encounter — they’re compelling, well-designed, show great analyses & insights, and are simply impressive!

Check out more of our Power BI Showcases here: www.enterprisedna.co/power-bi-showcase

***** 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 Continue reading “Get Inspired By These Excellent Power BI Examples — Innovative Techniques And Cool Features!” →

DAX Counterculture: Alternative Perspectives on DAX | Business Intelligence Summit Session 23

Posted on by Annie D

Session 23: DAX Counterculture: Alternative Perspectives on DAX

When is it?
August 25th – 4pm Los Angeles (PDT), 7pm New York (EDT)
August 26th – 12am London (BST), 9am Sydney (AEST), 11am Auckland (NZST)

How long is it?
Session will run for approximately 1 hour

Where is it?
Join in from your laptop, desktop or connected device

Who’s doing it?
Presented by Greg Deckler (MVP), VP at Fusion Alliance

During This Free Event, You Will Learn:

• Showcase effective ways when and when not to use CALCULATE
• Determine when not to use Time Intelligence functions (always)
• Learn how to loop in DAX efficiently
• See how to use the greatly maligned EARLIER Continue reading “DAX Counterculture: Alternative Perspectives on DAX | Business Intelligence Summit Session 23” →

Slicers vs. Slicer Pane vs. Filter Pane! Which is faster?

Posted on by Annie D

You have different options in Power BI when it comes to slicers and filters. Just put the slicer on the report, use a slicer panel or have them in the filter pane. But which one is faster??? Patrick explores a few scenarios to think about!

Should you hide the filter pane in Power BI?
https://greyskullanalytics.com/should-you-hide-the-filter-pane-in-power-bi/

📢 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
— <a Continue reading “Slicers vs. Slicer Pane vs. Filter Pane! Which is faster?” →

The Ultimate Power BI Freestyle Session | Business Intelligence Summit Session 24

Posted on by Annie D

Session 24: The Ultimate Power BI Freestyle Session

When is it?
August 25th – 8pm Los Angeles (PDT), 11pm New York (EDT)
August 26th -4am London (BST), 1pm Sydney (AEST), 3pm Auckland (NZST)

How long is it?
Session will run for approximately 1 hour

Where is it?
Join in from your laptop, desktop or connected device

Who’s doing it?
Presented by Sam McKay, Founder & CEO of Enterprise DNA

During This Free Event, You Will Learn:

• Build a comprehensive and compelling Power BI report within an hour from scratch!
• Learn how to use our automation tools and techniques in your own workflow
• See how much easier Power BI can be Continue reading “The Ultimate Power BI Freestyle Session | Business Intelligence Summit Session 24” →

Advanced Data Modeling & DAX Techniques | Business Intelligence Summit Session 21

Posted on by Annie D

Session 21: Advanced Data Modeling & DAX Techniques

When is it?
August 25th – 8am Los Angeles (PDT), 11am New York (EDT), 4pm London (BST)
August 26th – 1am Sydney (AEST), 3am Auckland (NZST)

How long is it?
Session will run for approximately 1 hour

Where is it?
Join in from your laptop, desktop or connected device

Who’s doing it?
Presented by Thomas Martens (MVP), Solution Architect – Munich Re

During This Free Event, You Will Learn:

• Learn how to answer questions faster that come with the event-in-progress and the previous value challenge
• Discover advanced data modeling and DAX techniques to speed up DAX query execution
• Know how the vertipaq Continue reading “Advanced Data Modeling & DAX Techniques | Business Intelligence Summit Session 21” →