Category: 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]” →

Can you do Page-Level Security in Power BI?

Posted on by Annie D

What’s up with page-level security in Power BI? We keep getting questions from people about how to do this. I’ve got bad news and I’ve got… well, just watch the video!

Row-Level Security and Object-Level Security together in Power BI??? Yup!
https://www.youtube.com/watch?v=ZYO7wGKVM0Y

Did you know you can now selectively show report pages for specific users in Power BI?
https://www.fourmoo.com/2020/05/26/did-you-know-you-can-now-selectively-show-report-pages-for-specific-users-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: 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 #pagelevelsecurity #GuyInACube

How To Create Parallel Coordinate Plots With Python

Posted on by Annie D

In this video, Gaelim is going to show how to create multi-variate coordinate plots aka Parallel Coordinate Plots using Python, which are used to show the relationship between multiple variables that share the same numerical data.

***** Video Details *****
00:00 Introduction
01:04 Plot overview
01:50 Data set
04:03 Importing data
05:12 Python code
10:06 Plot styles
10:56 Color map

***** 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 Continue reading “How To Create Parallel Coordinate Plots With Python” →

Azure Synapse Serverless vs Dedicated SQL Pool

Posted on by Annie D

Not sure on whether to choose Serverless versus SQL Dedicated Pools with Azure Synapse Analytics? Brad Schacht joins Patrick to talk about how to make the choice and get going with your data!

Serverless SQL Pool
https://learn.microsoft.com/azure/synapse-analytics/sql/on-demand-workspace-overview

Dedicated SQL Pool
https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-overview-what-is

Brad Schacht:
Twitter: https://twitter.com/BradleySchacht
LinkedIn: https://www.linkedin.com/in/bradleyschacht/
Blog: https://bradleyschacht.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!
*******************

— http://twitter.com/guyinacube
— <a Continue reading “Azure Synapse Serverless vs Dedicated SQL Pool” →

The Most Powerful Function Call in Power BI | Power BI Tutorial

Posted on by Annie D

In this video, I demonstrate perhaps my favorite feature within Power BI – a single, simple function call that lets you radically expand the analytical capabilities of the program, literally putting hundreds of thousands of additional functions right at your fingertips from within Power Query.

***** Video Details *****
00:13 Intro to the function call in Power BI
02:10 Excel BI Nightly challenge
02:18 changing data type
02:43 creating a list
05:10 R prime number package
06:32 inserting the R prime package into Power BI
10:21 filtering the prime numbers
10:50 GROUPBY

***** Related Links *****
Linkedin Post:
https://www.linkedin.com/posts/brianjuliusdc_dataanalytics-powerbiprotips-r-activity-6996019482087333888-GxtW?utm_source=share&utm_medium=member_desktop

Excel BI Nightly Challenge:
https://excelbianalytics.com/wp/category/challenge/

***** Learning Power Continue reading “The Most Powerful Function Call in Power BI | Power BI Tutorial” →

Integrated Financial Reporting – Power BI Techniques For Accounting & Finance [2022 Update]

Posted on by Annie D

Many times your financial information sits in different data locations and is not summarized as you need. This is especially true for P&L statements where your sales/revenues will usually sit with a transaction table and all your expenses will sit in other tables. In this video, Sam walks through how you can combine these data sources and create integrated financial statements which are entirely automated.

***** Video Details *****
00:00 Introduction
03:23 Using SUMX
03:34 Using Query Editor
06:09 Using SUMMARIZE
07:44 Using UNION

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Continue reading “Integrated Financial Reporting – Power BI Techniques For Accounting & Finance [2022 Update]” →