Category: Power BI

A better way to share Personal Bookmarks in Power BI

Posted on by Annie D

A while back Adam shared how you can share a personal bookmark with others. There is now a better way to share personal bookmarks in Power BI if your report is in a workspace. Learn how!

Share Power BI reports and dashboards with coworkers and others
https://learn.microsoft.com/power-bi/collaborate-share/service-share-dashboards

Alternative to sharing a Power BI Personal Bookmark
https://www.youtube.com/watch?v=-c1-VQ6RsrA

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

Why isn’t my Agg being hit in Power BI???

Posted on by Annie D

There are different reasons why your Agg isn’t being hit in Power BI. In this video, Patrick looks at a specific reason based on the DAX functions you are using. Gotta watch out!

📢 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 “Why isn’t my Agg being hit in Power BI???” →

How To Use ECDF Plots With Python And Power BI

Posted on by Annie D

In this video, Gaelim demonstrates how to use a Cumulative Distribution Plot also know as Empirical Cumulative Distribution Function (ECDF) Plot, and showcase the advantages of using this variation of plot over other plot types.

***** Video Details *****
00:00 Introduction
00:34 Kinds of distribution plots
04:34 Histogram plot code
06:07 KDE plot code
06:23 Box plot code
06:50 ECDF plot code
08:05 Styling plots

***** 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 “How To Use ECDF Plots With Python And Power BI” →

Best Practice Tips For Using The Advanced Editor In Power BI [2022 Update]

Posted on by Annie D

In this tutorial, Sam runs through some of his best practice tips for using the query editor in Power BI. The query editor is undoubtedly important in Power BI, but it is so hidden away that those who are just starting out might not easily know that it exists. Power BI users will ultimately need to learn how to use it, and use it well. Check out Sam’s tips to help you navigate the query editor efficiently.

***** Video Details *****
00:00 Introduction
00:50 Using the query editor
04:14 Making changes in the editor
05:08 Fixing the error

***** Learning Power BI? *****
FREE COURSE – Continue reading “Best Practice Tips For Using The Advanced Editor In Power BI [2022 Update]” →

Parameterize your Notebooks in Azure Synapse

Posted on by Annie D

Using notebooks in Azure Synapse Analytics? Do you find yourself wanting to have a dynamic value for use with your pipelines? Patrick shows you how you can accomplish this!

📢 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 – <a href=”https://guyinacube.com/tools/” Continue reading “Parameterize your Notebooks in Azure Synapse” →

How To Add A Conditional Index In Power Query

Posted on by Annie D

In this video, Melissa is going to give a walkthrough on her approach for Bhavya Gupta’s Power Query Challenge involving Conditional Indexing. The task is to add an index number from 1 for each ID in the table and begins in the row after the values in the date columns hit more than or equal 90.

Link to the Power Query Challenge: https://bit.ly/3T9XBSJ

***** Video Details *****
00:00 Introduction
00:57 Group By
02:43 Table.RowCount
02:56 List.PositionOf
04:54 Generic list
06:00 List.Repeat
06:40 Restricting elements
07:50 Contstruct table
09:20 Expand nested tables

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – <a Continue reading “How To Add A Conditional Index In Power Query” →

How To Add Date To Filename In Power Automate Desktop

Posted on by Annie D

In this video, Jarrett is going to show how to use Power Automate Desktop to add a date to a filename.

Enterprise DNA Forum Post: https://forum.enterprisedna.co/t/refreshing-and-excel-file-in-sharepoint-w-power-automate/28162

***** Video Details *****
00:00 Introduction
01:35 The problem
02:20 Getting current date and time
02:58 Converting datetime to text
04:01 Renaming file
05:26 Running flow

***** 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 Continue reading “How To Add Date To Filename In Power Automate Desktop” →

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

Scale Your Power BI Reporting With Row Level Security [2022 Update]

Posted on by Annie D

In this tutorial, Sam will show how to implement a security model into your Power BI models with Row Level Security and be able to manage provision users to only see segments of analysis they are allowed to see.

***** Video Details *****
00:00 Introduction
01:11 Regional information
01:55 Creating simple visualisations
02:58 Managing roles
04:08 Viewing as roles
06:15 Publishing and managing security model

***** 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 “Scale Your Power BI Reporting With Row Level Security [2022 Update]” →

Office 365 meet Power BI Desktop

Posted on by Annie D

Let’s talk about an upcoming change for Power BI Desktop and how it can be deployed. If you use Office 365, it may get a lot easier for you!

David Eldersveld
https://twitter.com/dataveld

Twitter Thread
https://twitter.com/dataveld/status/1576359796449902592

Power BI in Office installer
https://learn.microsoft.com/power-platform-release-plan/2022wave1/power-bi/power-bi-office-installer

📢 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
— <a Continue reading “Office 365 meet Power BI Desktop” →

Let Power Query write your SQL for you!

Posted on by Annie D

We tell you to push your transformations upstream as much as possible. But you don’t know how to write SQL. That’s ok, let Power Query do it for you to move your project forward. Patrick shows you how!

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

***Gear***
🛠 Check out my Tools page – https://guyinacube.com/tools/

#PowerBI #GuyInACube

Taking On Access Analytic’s Start Stop Challenge

Posted on by Annie D

In this video, Melissa will demonstrate an approach to Access Analytic’s Start Stop Challenge. The ask is to calculate the total number of hours member for a staff member on each month and date. See how you can solve this challenge!

Start Stop Challenge: https://accessanalytic.com.au/power-query-stop-start-challenge

***** Video Details *****
00:00 Introduction
00:55 Dataset
01:11 Filtered rows
03:10 Adding custom column
05:12 Variables
15:30 Projection
16:09 Aggregate values

***** 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 Continue reading “Taking On Access Analytic’s Start Stop Challenge” →