Category: Power BI

20221213 Profile with Azure Data Studio

Posted on by Annie D

📢 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 – https://guyinacube.com/tools/

#AzureSQL #AzureDataStudio #GuyInACube

Transparency Magic In Power BI With DAX

Posted on by Annie D

Brian previously talked about the best way to implement conditional formatting, which is by using the field value option because you can use the transparency masks on hex codes. In this video, Brian shows how you can utilize this transparency mask.

***** Video Details *****
00:00 Introduction
00:39 The goal
01:51 Numeric parameter slider
02:01 Color
02:20 CF Bar measure
03:40 Dynamic font measure

***** 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 – Continue reading “Transparency Magic In Power BI With DAX” →

How To Cluster With Power BI And Python

Posted on by Annie D

In this tutorial, Gaelim is going to show how you can do clustering in Power BI and Python, as well as discuss some of the advantages of using Python in your clustering.

***** Video Details *****
00:00 Introduction
01:29 Using Power BI for clustering
02:12 Scatter plot clustering
05:39 Pros of clustering
05:56 Cons of clustering
06:20 Using Python for clustering
06:41 Importing a Python package
07:57 Python script

***** 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 – rel=”nofollow”>http://www.enterprisedna.co/power-bi-resources
FREE – 60 Page DAX Reference Guide Download – https://www.enterprisedna.co/dax-formula-reference-guide-download/
Enterprise DNA Membership – https://www.enterprisedna.co/membership
Enterprise DNA Online – http://portal.enterprisedna.co/
Enterprise DNA Events – https://www.enterprisedna.co/enterprise-dna-events-page/

#EnterpriseDNA #Python #PythonTutorial #PowerBI #PowerBIDesktop #PowerBITutorial

Multi-layered Scenario Analysis Using DAX In Power BI [2022 Update]

Posted on by Annie D

Expand your thinking around what’s possible with Power BI! What you can achieve from an analytical perspective with DAX is incredible. In this video, Sam demonstrates how you can layer multiple scenarios into your analysis through supporting tables and slicers applied in a Sales & Profit data.

***** Video Details *****
00:00 Introduction
02:07 Supporting tables
05:40 Using SUMX in scenario profits measure
07:39 Checking the formula

***** 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 – Continue reading “Multi-layered Scenario Analysis Using DAX In Power BI [2022 Update]” →

Can you make a two-line dynamic title in Power BI?

Posted on by Annie D

Dynamic titles in Power BI can be really useful. What about a multi-line title? Patrick is answering a commenter’s question on how to create a two-line dynamic title!

Dynamic Titles in Power BI Desktop
https://www.youtube.com/watch?v=TYLKDPcvgK8

📢 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 Continue reading “Can you make a two-line dynamic title in Power BI?” →

How To Integrate A Power App Into Your Power BI Report

Posted on by Annie D

In this tutorial, Tim is going to demonstrate how you can incorporate a Power App directly into your Power BI report and make the two interact together

***** Video Details *****
00:00 Introduction
00:43 Report example
02:45 Inefficiencies
03:09 The goal
05:53 Adding an app
06:22 Adding data in your app
11:28 Edit mode vs Add New Record
13:42 PowerBIIntegration.Data
15:18 Auto populate a new record
16:25 Multiple selected record
20:05 Publish app

***** 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 – <a href="http://www.enterprisedna.co/power-bi-resources" Continue reading “How To Integrate A Power App Into Your Power BI Report” →

Can you use SQL Auth with Azure Synapse Serverless?

Posted on by Annie D

When using Azure Synapse Analytics Serverless Pools, using Azure AD auth is pretty simple. But, what about SQL Auth? How do you get hat working? Patrick shows you how!

Control storage account access for serverless SQL pool in Azure Synapse Analytics
https://learn.microsoft.com/azure/synapse-analytics/sql/develop-storage-files-storage-access-control?tabs=managed-identity

Sample Script: https://github.com/guyinacube/demo-files/blob/master/video%20demos/Synapse/20221206%20-%20Connect%20to%20Serverless%20-%20Security%20Script.sql

📢 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 “Can you use SQL Auth with Azure Synapse Serverless?” →

Using LASTNONBLANK For Dynamic Sales Insights In Power BI – DAX Function Deep Dive [2022 Update]

Posted on by Annie D

In this tutorial, Sam shows how to use the LASTNONBLANK function to showcase dynamic insights such as the date of the last sale for a particular variable or element in your data set.

***** Video Details *****
00:00 Introduction
01:55 Calculating last sale date
03:00 Calculating last sale amount

***** 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 DAX Reference Guide Download – https://www.enterprisedna.co/dax-formula-reference-guide-download/
Enterprise Continue reading “Using LASTNONBLANK For Dynamic Sales Insights In Power BI – DAX Function Deep Dive [2022 Update]” →

Using The Power BI “Magic” Dataset Call In Action

Posted on by Annie D

In this video, Brian shows how he and Gustaw Dudek developed the advanced analysis in their winning Challenge 23 entry, using the “magic” dataset call that he initially introduced in his previous video.

The Most Powerful Function Call In Power BI – https://youtu.be/F2M4F4sUDw8

***** Video Details *****
00:00 Introduction
05:10 Main data
05:56 Why not operate on the main data file
06:37 R script
09:41 Running in Power Query
10:30 Different applications

***** 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 The Power BI “Magic” Dataset Call In Action” →

🔴 Power BI tips from the Pros – LIVE (Dec 3, 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 (Dec 3, 2022) (Member Chat 2nd Half)” →

Manage Custom Visual purchases for Power BI

Posted on by Annie D

It used to be a bit of a struggle to purchase a custom visual for more than yourself. Adam looks at some of the changes for Power BI Custom Visuals in AppSource to help you purchase and manage licenses for your organization.

Introducing a new way to purchase licensed Power BI visuals and manage licenses through Microsoft platforms
https://powerbi.microsoft.com/blog/introducing-a-new-way-to-purchase-licensed-power-bi-visuals-and-manage-licenses-through-microsoft-platforms/

📢 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!
*******************

— <a Continue reading “Manage Custom Visual purchases for Power BI” →

Using The CROSSJOIN Function In Power BI – DAX Concepts [2022 Update]

Posted on by Annie D

CROSSJOIN is a DAX function that returns a new table based on the parameters you input into the formula. In this tutorial, Sam runs through the CROSSJOIN function in Power B, and a detailed example of how this can be effectively applied to certain types of analysis as well as other ways that this function can be used effectively.

WATCH THE FULL WORKSHOP SESSION HERE: https://youtu.be/n_Ki8XA4cCY

***** Video Details *****
00:00 Introduction
01:29 Using the CROSSJOIN function
05:42 Using the DISTINCT and SUMMARIZE functions
07:04 Other ways to use CROSSJOIN

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide Continue reading “Using The CROSSJOIN Function In Power BI – DAX Concepts [2022 Update]” →