Category: Power BI

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

How To Bring In Summary Statistics and Correlation Tables In Power BI Using Python

Posted on by Annie D

Power BI is a powerful tool in its own, but there are even more potential that are not possible to do with only its built-in capabilities In this tutorial, Gaelim is going to show how you can bring in descriptive statistics and correlations into Power BI as tables using some easy Python code. This will help data analysts perform more advanced statistical analyses and build more complex visualizations for deeper insights and improved communication in Power BI.

*****Video Details*****
00:00 Introduction
00:40 The data set
01:27 Descriptive statistics overview
02:10 Correlations overview
03:20 Python script
05:12 Not resetting the index
06:46 Unpivot data
08:29 Correlations
11:50 The outcome
12:18 Formatting visualizations

***** Continue reading “How To Bring In Summary Statistics and Correlation Tables In Power BI Using Python” →

Dataset permissions required for App report in Power BI? What am I missing???

Posted on by Annie D

Struggling with Power BI App permissions when using shared datasets? Adam looks at how this works. Even for PRO users!!!

Composit model permission blog (Older information):
https://powerbi.microsoft.com/en-us/blog/update-to-required-permissions-when-using-composite-models-on-a-power-bi-dataset/

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

#PowerBI #Permissions #GuyInACube

Detect Abnormal Patterns In Behaviour Using DAX In Power BI [2023 Update]

Posted on by Annie D

With the powerful capabilities of Power BI, you can unlock some truly remarkable insights! In this video, Sam demonstrates one fascinating example that showcases the great potential of Power BI — by skillfully combining a range of advanced DAX formulas and techniques, you can uncover any unusual patterns or anomalies lurking within your datasets.

*****Video Details*****
00:00 Introduction
02:45 Unique products bought
03:33 Ave. products bought in a quarter
04:01 Ave. products bought in all quarters

***** 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 Continue reading “Detect Abnormal Patterns In Behaviour Using DAX In Power BI [2023 Update]” →

Publish/Migrate your RDL files from Power BI Report Server to the service

Posted on by Annie D

Using on-premises Power BI Report Server? You can now migrate your paginated RDL reports to the Power BI service from within the portal. Patrick shows you how!

Plan to migrate .rdl reports to Power BI
https://learn.microsoft.com/power-bi/guidance/migrate-ssrs-reports-to-power-bi

Blog Announcement:
https://powerbi.microsoft.com/blog/power-bi-report-server-january-2023-feature-summary/#post-21998-_Toc121395751

Public RDL files to Power BI
https://learn.microsoft.com/power-bi/guidance/publish-reporting-services-power-bi-service?tabs=powerbi-report-server

📢 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
— Continue reading “Publish/Migrate your RDL files from Power BI Report Server to the service” →

Uncovering the Power of Enterprise Data Modeling with Chris Barber

Posted on by Annie D

With his financial background and data modeling expertise, Chris Barber, a Microsoft MVP, explores the irony of his journey to discover the optimal data model, a task that requires both technical knowledge and a judgement call, to uncover the key to his clients’ successful decision-making.
Chris Barber is a Microsoft MVP and chartered accountant with a Masters in analytics. He has presented at Microsoft Reactor and the London Business Analysts Group, and runs the website Starchema.co.uk, which has over 1000 people taking his finance course. He specializes in large scale data modeling and financial reporting.
Chris Barber was always interested in Power Continue reading “Uncovering the Power of Enterprise Data Modeling with Chris Barber” →

Provide data lake access with Azure Synapse Analytics

Posted on by Annie D

Using a lake database with Azure Synapse Analytics and struggling to figure out permissions needed for your data readers? Patrick and Adam show you what’s missing!

Azure Synapse Access Control
https://learn.microsoft.com/azure/synapse-analytics/security/synapse-workspace-access-control-overview

How to set up access control for your Azure Synapse workspace
https://learn.microsoft.com/azure/synapse-analytics/security/how-to-set-up-access-control

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=user-identity

📢 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 href="http://twitter.com/guyinacube" Continue reading “Provide data lake access with Azure Synapse Analytics” →

How To Use The GROUPBY Function In Power BI

Posted on by Annie D

In this tutorial, Sam will run through how to use the GROUPBY function in Power BI with a few examples. This is a similar table function to the likes of SUMMARIZE and SUMMARIZECOLUMNS, but it has some unique nuances to it that are interesting and worth diving into more deeply.

*****Video Details*****
00:00 Introduction
01:55 Creating tables using GROUPBY
03:58 Using the CURRENTGROUP function
05:28 Working out GROUPBY inside a variable
06:33 Return results using MAXX function
06:54 Checking out a specific customer

***** 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 Use The GROUPBY Function In Power BI” →

How To Easily Create And Organize Multiple Measures At Once In Power BI

Posted on by Annie D

In our past video, Brian showed how to automatically kill unused columns and measures in Power BI. Now, he’ll demonstrate some cool time-saving techniques on how you can create and organize dozens of measures at once, while also setting format strings and turning off aggregations. 

*****Video Details*****
00:00 Introduction
01:04 Data model
01:50 C# script
02:18 Fact table
03:24 Measures table
04:00 Metadata Mechanic Pro

*****Related Links*****

Tabular Editor 3:
https://tabulareditor.com/

Tabular Editor 2: (Free)
https://github.com/TabularEditor/TabularEditor
Metadata Mechanic Pro (part of Enterprise DNA Power Tools Suite)
https://www.enterprisedna.co/tech/power-tools/

Metadata Mechanic (Free)
https://github.com/gdeckler/MicrosoftHatesGregsQuickMeasures
GitHub Gist Bulk Measure Creation Script
https://gist.github.com/bjulius/8e71fde3e82574d278b9b06093583905

GitHub Gist Countrows Measure Continue reading “How To Easily Create And Organize Multiple Measures At Once In Power BI” →

How To Get Totals Correct When Using Advanced DAX Logic In Power BI [2023 Update]

Posted on by Annie D

When you start writing more advanced DAX formula, your totals will likely start playing up and not returning the values you want. In this tutorial, Sam demonstrates how to use a technique that will get you the correct totals particularly when using advanced DAX logic.

*****Video Details*****
00:00 Introduction
01:11 The objective
01:45 Total sales
02:15 Monthly averages
03:37 Average yearly result
05:24 Incorporating HASONEVALUE

***** 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 Get Totals Correct When Using Advanced DAX Logic In Power BI [2023 Update]” →

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