Month: August 2022

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

Its Back The Flattened Pivot Table – 2504

Posted on by Annie D

Laura from Nashville is looking for a way to make sure that all future pivot tables default to having No Subtotals. This *was* a feature in the PowerPivot Add-in back in Excel 2010, but then was removed. However, thanks to Pivot Table Defaults, you can force all future pivot tables into a flat pivot table that is ready for re-use.

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

Exploring Excel IMAGE Function – 2500

Posted on by Annie D

Display pictures on your Excel Dashboard using an Excel IMAGE formula. This episode has a deeper dive into the function and how to use it.

(0:00) Welcome
(0:24) Finding Image Address
(0:54) Building Image URL
(1:30) Using IMAGE function
(1:52) Hover for Pop-out Image
(2:30) Pivot Table
(2:55) Formula to Display All Images
(3:04) FILTER to convert to array
(3:15) IMAGE function
(3:20) TRANSPOSE for 2501 Bug
(3:35) WRAPROWS function
(3:45) Excel MVP by Country
(4:10) Caption under picture but how?
(5:19) Caching images #BUSY! error
(5:57) Insiders beta now

Keep Leading Zeroes When Opening CSV – 2502

Posted on by Annie D

D on YouTube asks: How do I stop Excel from removing leading zeros when opening a file?
Changing a column from general to text does not work for me, as the “0” has already been removed.
09805 becomes 9805, for example.
The files I’m opening does not make it clear that the zero has been removed.
I’m working in spreadsheets with 200k rows.
So stopping Excel from removing them in the first place, would be preferable

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