Category: Power BI

What happens when you miss a refresh day with Power BI Incremental Refresh?

Posted on by Annie D

You’ve set up Power BI Incremental Refresh and there is a day that is missed because schedule refresh failed or some other reason. What happens? Do you lose that data? Patrick digs in!

📢 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 “What happens when you miss a refresh day with Power BI Incremental Refresh?” →

How To Easily Create Data With Python Faker Library

Posted on by Annie D

Fake dataset is often used for testing and filling databases or maintaining user privacy by using some dummy data. Data analysts would know that manually creating fake data would be a daunting task! In this tutorial, Gaelim will demonstrate how you can easily create data using Python Faker.

*****Video Details*****
00:00 Introduction
01:28 Libraries needed
02:25 Locale
03:54 Types of data
05:11 Random element selector
05:58 Creating the dataset

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – www.enterprisedna.co/courses/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – www.enterprisedna.co/courses/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – www.enterprisedna.co/power-bi-resources
Enterprise DNA On-Demand – app.enterprisedna.co
Enterprise DNA Subscription – app.enterprisedna.co/pricing
Enterprise DNA Continue reading “How To Easily Create Data With Python Faker Library” →

What is a Slowly Changing Dimension???

Posted on by Annie D

Want to know more about a slowly changing dimension? What about the different types? Patrick goes through examples and ties in the surrogate key!

Sample: https://github.com/guyinacube/demo-files/blob/master/video%20demos/Synapse/20230124%20-%20SCD%20Demo.sql

Handling Type II Dimension with the MERGE Statement
https://sqldownsouth.blogspot.com/2010/11/handling-type-ii-dimension-with-merge.html

Slowly Changing Dimension
https://en.wikipedia.org/wiki/Slowly_changing_dimension

#PowerBI #GuyInACube

How To Create Dynamic Tables In Power BI Using RANKX

Posted on by Annie D

In this tutorial, Sam runs through how to create a dynamic table that only shows the top results across a range of measures. You can do this using a combination of DAX formula including the RANKX function. This is great ranking technique for a number of analytical scenarios in Power BI.

*****Video Details*****
00:00 Introduction
01:00 The goal
01:41 Profit growth YOY
03:40 Sales YOY
04:26 Margin growth YOY

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – www.enterprisedna.co/courses/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – www.enterprisedna.co/courses/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – www.enterprisedna.co/power-bi-resources
Enterprise DNA On-Demand – app.enterprisedna.co
Enterprise DNA Subscription Continue reading “How To Create Dynamic Tables In Power BI Using RANKX” →

How To Change Size Of Visual Based On Ranking Selection In Power BI Using DAX [2023 Update]

Posted on by Annie D

In this tutorial, Sam demonstrates a cool data visualization technique RANX to change the size of a visual based on a ranking selection. Once you understand the patterns there are multiple ways you could apply this to other scenarios.

*****Video Details*****
00:00 Introduction
01:01 Supporting table
02:53 Customer ranking
04:15 Incorporating the measures

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – www.enterprisedna.co/courses/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – www.enterprisedna.co/courses/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – www.enterprisedna.co/power-bi-resources
Enterprise DNA On-Demand – app.enterprisedna.co
Enterprise DNA Subscription – app.enterprisedna.co/pricing
Enterprise DNA Events – www.enterprisedna.co/events

#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial

Allow users to Show and Hide columns in a Power BI Paginated report!

Posted on by Annie D

In a Power BI Paginated Report, you can allow your report consumers to customize what they see in the report such as which columns they want in their table or matrix. Patrick shows you how!

Sample RDLs: https://github.com/guyinacube/demo-files/blob/master/video%20demos/RDL/20230118%20-%20Paginated%20Show%20Hide%20Columns.zip

#PowerBI #Paginated #GuyInACube

How To Build A Google News Aggregator In Power BI Using Python

Posted on by Annie D

While most of its users use Power BI to analyze their own data, the ‘Get Data from Website’ functionality makes it easy to analyze external data. In this video, Gaelim is going to show how you can build a Google News aggregator in Power BI using Python which visualizes news that might be relevant to your report.

***** Video Details *****
00:00 Introduction
00:19 End result
02:00 Data set
02:47 Installing Google News library
03:48 Using the News Crawler
06:34 Using Loops

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – www.enterprisedna.co/courses/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – www.enterprisedna.co/courses/ultimate-beginners-guide-to-dax
FREE Continue reading “How To Build A Google News Aggregator In Power BI Using Python” →

What is a Common Table Expression (CTE) and how do you use them?

Posted on by Annie D

We’ve had some questions about what a Common Table Expression (CTE) is. Patrick describes what they are and how you can use them in SQL Server or Azure Synapse Analytics.

WITH common_table_expression (Transact-SQL)
https://learn.microsoft.com/sql/t-sql/queries/with-common-table-expression-transact-sql?view=sql-server-ver16

Sample Scripts – https://github.com/guyinacube/demo-files/tree/master/video%20demos/Synapse

📢 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 “What is a Common Table Expression (CTE) and how do you use them?” →

Create Dynamic Visuals Based On Ranking In Power BI With DAX

Posted on by Annie D

In this tutorial, Sam shows how you can rank customers in Power BI with DAX, based on their sales or profits and also create visualizations that dynamically change for additional filters that you may put in place.

***** Video Details *****
00:00 Introduction
01:13 Total costs and total profits measures
02:29 RANKX function
03:50 ALL function
04:22 Top 10 table
05:20 Fixing incorrect total
07:13 Dynamic visualizations

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – www.enterprisedna.co/courses/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – www.enterprisedna.co/courses/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – www.enterprisedna.co/power-bi-resources
Enterprise DNA On-Demand – app.enterprisedna.co
Enterprise DNA Subscription – app.enterprisedna.co/pricing
Enterprise DNA Events Continue reading “Create Dynamic Visuals Based On Ranking In Power BI With DAX” →

Why You Should Take Advantage Of The DAX Table Constructor

Posted on by Annie D

In today’s video, Greg showcases one of his most used DAX constructs which he thinks is often overlooked by the DAX community — the DAX Table Constructor. He’ll be showing you what it’s all about and some examples on how he used it on some of his real-world works.

*****Video Details*****
00:00 Introduction
01:48 Table 1
03:18 Table 2
05:48 Single column
06:09 Multiple columns
06:52 Table 3
09:52 BASE example
11:00 GAMMA example
11:27 Text to Table example
12:19 XOR example

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – www.enterprisedna.co/courses/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – www.enterprisedna.co/courses/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – Continue reading “Why You Should Take Advantage Of The DAX Table Constructor” →

How To Write And Debug M Code More Effectively

Posted on by Annie D

In today’s video Brian discusses three important techniques that will help you write and debug M code more effectively: 1) the use of pseudocode: 2) the use of table duplicate to create “save points” to bookmark your coding/debugging progress; and 3) the use of record structures to break complex M expressions down into component variables, similar to DAX coding and debugging techniques.

*****Video Details*****
00:00 Introduction
01:15 Pseudocode solution
04:59 Debugging
09:27 Referencing
04:40 The errors
05:34 Record structure
09:28 Table duplicate
16:06 Recap

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – www.enterprisedna.co/courses/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – www.enterprisedna.co/courses/ultimate-beginners-guide-to-dax
FREE – Continue reading “How To Write And Debug M Code More Effectively” →

How To Use Query Parameter In Power BI [2023 Update]

Posted on by Annie D

In this tutorial, Sam shows how to use the query parameter feature inside of Power BI. You can bring significant scale to your reporting by using this feature without the need for duplicated reporting. Build a model once and then use this to add additional filters to your reports.

*****Video Details*****
00:00 Introduction
00:24 Query parameters
01:54 Creating a parameter
02:48 Integrating a Parameter into a query
04:50 Dealing with blanks in the table

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – www.enterprisedna.co/courses/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – www.enterprisedna.co/courses/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – www.enterprisedna.co/power-bi-resources
Enterprise DNA Continue reading “How To Use Query Parameter In Power BI [2023 Update]” →