Category: Power BI

How To Use Concurrent Function In Power Apps For Faster Process Time

Posted on by Annie D

Concurrent functions are a way great to optimize your Power Apps. Concurrent enables you to run processes in parallel instead of in sequences, making your Power Apps a lot faster. In this tutorial, Henry shows you how to use the Concurrent function, and shows you a side-by-side performance difference between regular sequence processes, and concurrent processes.  

***** Video Details *****
00:00 Introduction
00:48 Application overview
01:05 Variables
04:18 Concurrent function
07:24 Test run

***** 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 “How To Use Concurrent Function In Power Apps For Faster Process Time” →

Are you backing up your Power BI Dataset???

Posted on by Annie D

While Power BI is a SaaS service, backing up your dataset is still important. What if something was accidently deleted? How do you recover it? Patrick shows you how you can get a backup / restore process in place so you can sleep at night.

Backup/Restore PowerShell Script: https://guyinacu.be/backuprestorescript

Backup and restore datasets with Power BI Premium
https://docs.microsoft.com/power-bi/enterprise/service-premium-backup-restore-dataset

Power BI Service Principals 101
https://www.youtube.com/watch?v=1SO19uik1rw

📢 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 Continue reading “Are you backing up your Power BI Dataset???” →

Supercharging Your Charts & Graphs in Power BI

Posted on by Annie D

EVENT DETAILS – https://enterprisedna.co/supercharging-your-charts-graphs-in-power-bi-april-2022-registration/

RESOURCE DOWNLOAD – https://portal.enterprisedna.co/p/webinar-series-resources-free/

When is it?
April 12th – 6pm New York (EDT), 3pm Los Angeles (PDT), 11pm London (BST)
April 13th – 8am Sydney (AEST), 10am Auckland (NZST)

Where is it?
Join in from your laptop, desktop or connected device

Who’s doing it?
Presented by Reid Havens (MVP), BI Evangelist & Instructor

During This Free Training, You Will Learn:

• Discover various techniques to enhance and upgrade native visuals in Power BI
• Showcase helpful tips on how to deliver greater insights and unlock features for report consumers

If you have questions regarding this training, please send it to Continue reading “Supercharging Your Charts & Graphs in Power BI” →

How To Automatically Launch A New Web Browser In Power Automate

Posted on by Annie D

Web applications are essential components of most organizations. In today’s tutorial, Jarrett is going to demonstrate how to utilize a Power Automate Desktop function that you’ll be using often when doing web-related tasks and automation, the Launch New Browser.

***** Video Details *****
00:45 Building a flow
01:20 Browser options
01:44 Browser extensions
03:20 Launch new Chrome

***** Related Links *****
Launch New Chrome Microsoft Documentation – https://docs.microsoft.com/en-us/power-automate/desktop-flows/actions-reference/webautomation#launchchromebase

***** 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 “How To Automatically Launch A New Web Browser In Power Automate” →

REPLAY Power BI tips from the Pros – LIVE (April 9, 2022)

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

SQL For Power BI And DAX For SQL Users — Upcoming New Courses

Posted on by Annie D

Access the course here: https://portal.enterprisedna.co/p/sql-for-power-bi-users

A lot of reports we build in Power BI are based on SQL sources. Not only does SQL improve efficiency and refresh timings, it also allows us to improve the designs of our data models when we import the data in the format or shape we want through SQL.

In our upcoming new SQL courses developed by Enterprise DNA Experts, Hafiz Zubair and Antriksh Sharma, Power BI users can have a more thorough understanding of SQL, and the same for SQL users with DAX. Watch as Brian, Hafiz and Antriksh discuss the importance of Continue reading “SQL For Power BI And DAX For SQL Users — Upcoming New Courses” →

Nothing selected in Power BI Slicer? Then don’t show data!

Posted on by Annie D

Answering one of your Power BI questions about how to prevent data in a visual if nothing is selected in a slicer! Challenge accepted!

Do’s and Don’t with cascading slicers in Power BI
https://www.youtube.com/watch?v=1yv5srlqgmI

📢 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 “Nothing selected in Power BI Slicer? Then don’t show data!” →

Composite models in Power BI and Storage modes – what to pick???

Posted on by Annie D

When using composite models in Power BI, you have a choice for how to store your tables. Storage mode gives you options, but why would I pick one versus the other for my dimension tables? Adam has you covered!

Use composite models in Power BI Desktop
https://docs.microsoft.com/power-bi/transform-model/desktop-composite-models

DirectQuery model guidance in Power BI Desktop
https://docs.microsoft.com/power-bi/guidance/directquery-model-guidance

📢 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
— Continue reading “Composite models in Power BI and Storage modes – what to pick???” →

How To Execute And Interpret Paired Samples T-test In Excel

Posted on by Annie D

Comparing data sets can be a tedious and time-consuming task. Paired Samples T-test are commonly used to compare two variables for the same subject that are often separated by time. In this video, George will demonstrate how to efficiently execute and interpret a pair samples t-test in Excel.

***** Video Details *****
00:00 Introduction
01:36 Data set
02:45 Data analysis
03:06 Setting ranges
04:09 P value
05:03 Results
05:41 Recap

***** 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://enterprisedna.co/power-bi-resources" Continue reading “How To Execute And Interpret Paired Samples T-test In Excel” →

How To Automatically Send Emails By Linking Power BI And Power Automate

Posted on by Annie D

Have you ever wanted to link your Power BI reports to Power Automate? Have you ever wanted to execute a Power Automate workflow recursively to a list of user-selected records from a Power BI report? In this video, Tim and Henry show you how to connect Power BI and Power Automate. They first go through the simple example of sending emails to specific records, and then go through some bonus features (thresholds, etc.) that you can add to your Power BI reports to ensure your users don’t accidentally send thousands of emails.  

***** Video Details *****
00:00 Introduction
02:25 Data set
04:08 Potential issues
05:41 Continue reading “How To Automatically Send Emails By Linking Power BI And Power Automate” →

Use this Power BI feature to display custom message or titles

Posted on by Annie D

Want a custom message or title in your Power BI report? Not happy with the formatting options of the card visual or buttons? Patrick shows you a way that can be fully customizable!

📢 Become a member: https://guyinacu.be/membership Continue reading “Use this Power BI feature to display custom message or titles” →

limiting rows in Power BI

Limiting Rows in Power BI when Creating Reporting for Big Data (Overcoming Memory Limits)

Posted on by Annie D

Are you working with more data than you can handle in Power BI Desktop on your machine? Work with the subset of data locally and all the data in the service without using Premium and overcome the memory limitations in the desktop application!

Watch the video below on limiting rows in Power BI in the desktop, for the step by step instructions and deeper explanation.

To summarize, Patrick is working with a data source that has 600k rows.  He adds a step in the query to keep top rows, then adds a parameter to trigger whether to bring in all rows, or a subset.  He then adds a line to utilize the parameter.  Patrick demonstrates the pull with the parameter set to A (all records), and then again using the S (subset) parameter, which pulls in only 100K records.

Patrick then publishes to the service while only having 100k records loaded and continues on to demonstrate how to change the parameter to A in the browser/published version.

He then manually kicks off the refresh in the service and once complete, shows us that all 600k rows have now been imported into the model.  Very cool and useful trick, especially when working with lots of data, especially Big Data!

Video and Tip Courtesy of Guy In A Cube:

— 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 their Tools page – https://guyinacube.com/tools/

#PowerBI #PowerQuery #GuyInACube