Category: Power BI

How to easily compare Server Timings using DAX Studio for your Power BI dataset

Posted on by Annie D

Want to compare changes in your Power BI dataset? Making some amazing DAX optimizations? You should look at server timings in DAX Studio. Patrick shows you how to compare timings easily!

DAX Studio
https://daxstudio.org

📢 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 Continue reading “How to easily compare Server Timings using DAX Studio for your Power BI dataset” →

How To Create A Paginated Report In Power BI Service From A Published Data Set

Posted on by Annie D

Paginated reports are incredibly useful in the Power BI service because they provide a way to create pixel-perfect, printable reports that look great regardless of the device or screen size. These reports can be exported to a variety of formats, including PDF, Excel, and CSV, making them ideal for sharing with stakeholders who prefer to work with data offline.

However, creating paginated reports can be tricky, especially if you’re starting with an already published data set. One of the most common mistakes people make is assuming that the report layout will be identical to the visualizations in the original report. This Continue reading “How To Create A Paginated Report In Power BI Service From A Published Data Set” →

Use Azure SQL Managed Instance Link to have a Read Replica in the cloud!

Posted on by Annie D

Want to leverage the power of the cloud with your on-prem SQL Server? Azure SQL Managed Instance may be the answer for you! Dani joins us to talk about why MI Link can help bridge the two.

Azure SQL Managed Instance
https://learn.microsoft.com/azure/azure-sql/managed-instance/sql-managed-instance-paas-overview?view=azuresql

Azure SQL Managed Instance Link Overview
https://aka.ms/mi-link

Managed Instance (MI) Feedback to Product Group
https://aka.ms/mi-link-feedback

More Managed Instance Videos:
https://aka.ms/sqlmi-videos

Connect with Dani Ljepava:
https://twitter.com/danimir
https://www.linkedin.com/in/danimir

📢 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 Continue reading “Use Azure SQL Managed Instance Link to have a Read Replica in the cloud!” →

How To Calculate Averages Per Day In Power BI [2023 Update]

Posted on by Annie D

Power BI users often encounter the requirement of calculating averages per day when dealing with time-based data such as sales, web traffic, or social media activity. This calculation helps to provide a more accurate representation of performance trends and fluctuations over time, especially when compared to absolute values. In this tutorial, Sam will show how you can easily calculate averages per day using DAX in Power BI.

*****Video Details*****
00:00 Introduction
0:29 Data model
00:45 Total sales by customer
01:45 Averages sales per day by customer
03:10 Changing the time frame
03:48 Recap of the process
04:55 Applying the same formula against different dimensions

***** Learning Power BI? ***** Continue reading “How To Calculate Averages Per Day In Power BI [2023 Update]” →

How To Fix Spaghetti Line Charts In Power BI

Posted on by Annie D

Spaghetti line charts are a type of visualization used in Power BI to show trends and patterns in time-series data. Each data series is represented by a separate line on the chart, with lines crossing each other as they move along the x-axis. This type of chart is best used with time-series data, such as financial data, website traffic data, or social media engagement metrics, as it can help identify trends and patterns in the data over time.

To ensure the accuracy and effectiveness of the chart, it is important to format the data correctly and choose the appropriate chart type Continue reading “How To Fix Spaghetti Line Charts In Power BI” →

How To Capture and Clean On-Screen Data To Use In Power BI

Posted on by Annie D

Have you ever watched a video, perhaps a tutorial, and you just want to badly try out and practice with the featured data set? In this video, Brian is going to show how you can easily capture and clean on-screen data, apply two powerful functions for reshaping stacked data, and demonstrate some cool aspects of how pivoting works all in under 9 minutes!

*****Video Details*****
00:00 Introduction
00:45 Blackbox extension
01:10 Pasting the data
02:04 Integer-Divide
03:34 Pivoting data
04:47 Cleaning nulls
06:22 Modulo

***** 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 Capture and Clean On-Screen Data To Use In Power BI” →

Where are the Power BI Gateway logs? I thought I knew…

Posted on by Annie D

Do you know where the Power BI Gateway log files are? I didn’t! I’ll show you a tool I use to help figure something like this out. And also tell you where they are!

Process Monitor
https://learn.microsoft.com/sysinternals/downloads/procmon

Rui Romano’s Gateway Monitor Report
https://github.com/RuiRomano/pbigtwmonitor

📢 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
— Continue reading “Where are the Power BI Gateway logs? I thought I knew…” →

Calculating Averages Per Weekdays or Weekends Using DAX In Power BI [2023 Update]

Posted on by Annie D

The AVERAGEX function in DAX is used to calculate the average of a set of numeric values in a table or expression that results in a table. It is useful in Power BI reports when you need to calculate an average for a group of values based on a specific condition, such as average sales per customer.

To maximize the function, use it with a filtered table or expression, consider using it with other DAX functions, and be mindful of performance with large data sets. This also showcases how adaptable iterating formulas are in DAX. In this video, Sam Continue reading “Calculating Averages Per Weekdays or Weekends Using DAX In Power BI [2023 Update]” →

Setup a Reverse Hybrid Table without using Tabular Editor for Power BI!

Posted on by Annie D

Hybrid Tables can be very useful for mixing archived data with current data. Pat Mahoney joins Patrick to show how to configure a Hybrid Table within a Power BI dataset without using Tabular Editor. Just some straight “M”agic.

Hybrid Table Documentation:
https://learn.microsoft.com/power-bi/connect-data/service-dataset-modes-understand#hybrid-tables

Connect with Pat Mahoney:
https://twitter.com/mahoneypa
https://www.linkedin.com/in/patrick-mahoney-3138526/
https://www.youtube.com/@hoosierbi5669
https://hoosierbi.com/

📢 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 #HybridTable #GuyInACube

How To Create A Word Cloud Of Any Shape In Power BI Using Python

Posted on by Annie D

It’s a handy skill for data analysts to know how to create a word cloud in Power BI because it is a powerful way to visually represent textual data. Word clouds are useful in summarizing large amounts of text data and identifying patterns in it. They are also an effective way to communicate insights to stakeholders who may not have technical expertise.

Word clouds work best with data that consists of short, descriptive phrases or keywords, such as survey responses, customer feedback, or social media posts. In this tutorial, Gaelim is going to show how you can create a word Continue reading “How To Create A Word Cloud Of Any Shape In Power BI Using Python” →

Convert CSV to Parquet using pySpark in Azure Synapse Analytics

Posted on by Annie D

You’ve got a bunch of CSV files and you’ve heard of Parquet. How do you convert them for Azure Synapse Analytics? Patrick shows you how using pySpark.

pyspark DataFrame
https://spark.apache.org/docs/latest/api/python/reference/pyspark.sql/dataframe.html

pyspark.sql.DataFrameReader.load
https://spark.apache.org/docs/latest/api/python/reference/pyspark.sql/api/pyspark.sql.DataFrameReader.load.html

pyspark.sql.DataFrameWriter
https://spark.apache.org/docs/latest/api/python/reference/pyspark.sql/api/pyspark.sql.DataFrameWriter.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
— http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— https://guyinacube.com

***Gear***
🛠 Continue reading “Convert CSV to Parquet using pySpark in Azure Synapse Analytics” →

How To Use Variables In DAX Formula With Power BI [2023 Update]

Posted on by Annie D

Learning how to use variables in DAX formulas is beneficial for data analysts because it allows them to simplify their code and make it easier to read and understand. Variables can be used to store intermediate results, making complex calculations more manageable and reducing the risk of errors. Additionally, using variables can help to optimize query performance, as calculations that are reused multiple times can be cached in memory.

Using variables can make it easier to debug code, as it allows analysts to isolate and test individual parts of the calculation. In this tutorial, Sam will demonstrate how you can Continue reading “How To Use Variables In DAX Formula With Power BI [2023 Update]” →