REPLAY Power BI tips from the Pros – LIVE (April 1, 2023)

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 “REPLAY Power BI tips from the Pros – LIVE (April 1, 2023)”

Unlocking the Power of Data Architecture and Data Pipelines with Gilbert Quevauvilliers

Today’s episode features Gilbert Quevauvilliers, an expert in the field of Business Intelligence and Data Analytics. He has been in the industry since 2009 and has been an early adopter of Power BI, which he has been using for many years in his consulting and various engagements. His expertise spans across the data stack, from multidimensional cubes to the tabular model, and he has continuously kept himself up-to-date with the latest technologies.

Starting off in a large company in Durban, South Africa, he has decided to specialize in the Microsoft ecosystem and has built a wealth of knowledge and experience Continue reading “Unlocking the Power of Data Architecture and Data Pipelines with Gilbert Quevauvilliers”

Integrating Power BI With Power Platform – New Course!

Learning to integrate Power BI with Power Platform allows data analysts to leverage the combined power of multiple tools for more efficient and effective data analysis. By integrating Power BI with Power Automate and Power Apps, analysts can streamline their workflows, automate data processing, and create interactive visualizations, making it easier to gain insights and communicate findings.

We are ecstatic to officially launch our new course “Integrating Power BI with the Power Platform” developed by Tim Weinzapfel! In this video, join Komal and Tim as they give an insight on what you can expect from this new course, and how data Continue reading “Integrating Power BI With Power Platform – New Course!”

BI 348: Data Analysis with Microsoft Power Tools- Spring – 2023 Quarter Introductory Video

BI 348 is taught by Excel MVP Mike Girvin at Highline College. This is the intro video for matriculating students at Highline College in spring quarter, 2023. If you are not a matriculating student, watch class free at YouTube here is the playlist (videos #9-end): https://www.youtube.com/playlist?list=PLrRPvpgDmw0nre_bTeBfJWjrnixKoyNtW

Excel Statistical Analysis for Business – Busn 210 – Spring 2023 Quarter Introductory Video

Busn 210, Excel Statistics for Business class taught by Excel MVP Mike Girvin at Highline College.
This is the intro video for matriculating students at Highline College in spring quarter, 2023.
To watch at YouTube here is the playlist: https://www.youtube.com/playlist?list=PLrRPvpgDmw0m3oqpp1XcPuaxyM4Bpi0dN

🔴 Power BI tips from the Pros – LIVE (May 6, 2023) (Member Chat 2nd Half)

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 (May 6, 2023) (Member Chat 2nd Half)”

Using ALLEXCEPT To Stop Cumulative Total From Resetting [2023 Update]

The ALLEXCEPT function is a DAX formula in Power BI that allows you to remove filters from a table or column while keeping other filters on the same table or column. Cumulative totals are a common calculation in Power BI where a running total is displayed over time.

However, when a date selection is made, the cumulative total may reset to zero, and this is where the ALLEXCEPT function can be used to stop this from happening. By using the ALLEXCEPT function, you can ensure that your cumulative totals continue to show accurate data, even when a date selection is Continue reading “Using ALLEXCEPT To Stop Cumulative Total From Resetting [2023 Update]”

The HEART of Power BI

Remember Analysis Services? Maybe not for some of you. What exactly powers Power BI? What’s inside that makes the data go? Adam reveals the mystery and takes a trip down memory lane.

📢 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 Continue reading “The HEART of Power BI”

Calculating Averages Per Transaction Using DAX In Power BI [2023 Update]

One valuable insight that can be discovered in Power BI is the average amounts per transaction, which can provide useful information for businesses. This insight can be used to compare transaction amounts across different time frames or dimensions in the dataset.

By analyzing this information, businesses can identify patterns and trends, make data-driven decisions, and improve their operations. In this video, Sam will demonstrate how you can calculate averages per transaction in Power BI using DAX.

*****Video Details*****
00:00 Introduction
01:00 Data set
02:12 Average sales per transaction
03:11 Using data bars
03:35 Average profits per transaction
04:30 Average margins per transaction Continue reading “Calculating Averages Per Transaction Using DAX In Power BI [2023 Update]”

code execution has been interrupted window

How to Make Excel Wait or Pause in a VBA Macro

When running macros, I have often found the need for an Excel wait or pause, mainly so that other things can happen. DoEvents surely helps for waiting for things to happen within Excel, but sometimes you need to wait for processes to start or finish outside of Excel before moving onto other steps in VBA.

Why Wait?

I am a big fan of automating processes, especially with VBA in Excel. For example, I update and save a spreadsheet to SharePoint that a Power BI model is using. I have a Power Automate process set up that automatically refreshes the Power BI model whenever this particular spreadsheet is updated. The challenge is that Power BI temporary locks the workbook as it reads it, so if I am updating a few times in a short amount of time, Excel needs to wait until the SharePoint file is unlocked.

Also, I have another process where I call a Python script and once that is done, I continue on with VBA code to process the workbook Python outputs. I need Excel to wait while the Python code runs. Side note: let me know if you would like me to write more about these other automated processes.

The Solution

Good news – making Excel wait is very easy! Here is the simple code:

This will have Excel wait for 50 seconds since the time is represented as (H:MM:SS). You can adjust as needed.

Bonus

In my code, I don’t need it to wait every time – only when it runs into an issue saving the workbook on SharePoint. Here is how I have set my code using an error handler in my VBA macro.

I hope this helps you! Please comment or reach out if you would like to see other topics covered. I truly enjoy writing about Excel tips and tricks, especially VBA and automation!

Addressed in this post (to help others find this):

  • How to pause Excel
  • How to make Excel pause
  • Make VBA pause
  • Make VBA wait
  • Make Excel wait
  • VBA code wait, VBA macro wait
  • VBA code pause, VBA macro pause
  • VBA wait for another application

RLS in the source? How does this work with DirectQuery and Import in Power BI?

What happens in Power BI when you have row-level security (RLS) in the source? And, is it different between DirectQuery and Import? Of course it depends! Patrick explains…

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

Grouping Bookmarks by Report Page In Power BI [2023 Update]

Bookmarks in Power BI are useful for saving and restoring specific views or states of a report. They allow users to easily navigate between different sections or pages of a report and can be used to create interactive experiences for viewers.

Grouping bookmarks can improve workflow by organizing related bookmarks together, making it easier to find and apply them as needed. This can save time and help ensure consistency in the report design. In this tutorial, Jarrett shows how to group bookmarks by report page in Power BI.

*****Video Details*****
00:00 Introduction
0:53 Inspiration for the tutorial
02:55 Creating bookmarks
06:33 Grouping the bookmarks

***** Related Continue reading “Grouping Bookmarks by Report Page In Power BI [2023 Update]”