You can transfer lots of data from Power Apps to Power Automate, but images and signatures can be quite tricky. In this video, Henry goes through how you can create a workflow that takes an uploaded image and signature from Continue reading “How To Transfer Images And Signatures From Power Apps To Power Automate”
Category: Power BI
Can Patrick handle the challenge??? Query Folding in Power BI!
Can Patrick handle the challenge that Alex Powers presented to him? Can he actually complete the challenges of the Power Query 30 day Query Folding challenge? Let’s find out…
These are great for both Power BI and Microsoft Excel!
30 Day Challenge Continue reading “Can Patrick handle the challenge??? Query Folding in Power BI!”
How To Create Form Popups In Power Apps
In this tutorial, Henry is going to give a 101 on Form Popups within Power Apps and how they can offer a more customized and interactive user experience.
***** Video Details *****
00:00 Introduction
00:21 What are Form Popups
01:27 Sample report overview
02:34 Creating Continue reading “How To Create Form Popups In Power Apps”
How To Organize Your DAX Measures in Power BI Folders and Make Finding Them A Breeze
As you progress in Power BI, you will gradually be working with more DAX measures and calculations. As a result, things can easily get cluttered. Today you will learn a few valuable tips and tricks on how to organize your DAX measures for a more efficient workflow. Hopefully this will help you and become a standard practice!
Watch the video for step by step instructions and a full explanation.
To summarize, Reid shows us how to add a new table and move our measures to it so they are together in one place.
He then shows us how to convert this into a folder, and then subsequently create subfolders to further organize your DAX measures in the model. Reid continues on to show us how we can have a measure in multiple locations if it makes sense.
What a great way to manage the measures as they grow in number!
***** Video Details *****
00:00 Introduction
00:33 Root folders
01:32 Subfolders
03:30 Actual Amount VTB
***** 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://enterprisedna.co/power-bi-resources
FREE – 60 Page DAX Reference Guide Download – https://enterprisedna.co/dax-formula-reference-guide-download/
Enterprise DNA Membership – https://enterprisedna.co/membership
Enterprise DNA Online – http://portal.enterprisedna.co/
Enterprise DNA Events – https://enterprisedna.co/enterprise-dna-events-page/
#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial
Some tips for your data labels in Power BI
Charts can be hard to understand sometimes. Ambiguity is never a good thing. Here are some tips for using data labels in Power BI to help your consumers better understand the meaning of the values.
📢 Become a member: <a href="https://guyinacu.be/membership" Continue reading “Some tips for your data labels in Power BI”
So, we just wait???
What’s up with the wait time in Power BI Dataflows? Do we just live with it? What’s going on and what can we do about? Adam, has you covered!
Understanding and optimizing dataflows refresh
https://docs.microsoft.com/power-bi/transform-model/dataflows/dataflows-understand-optimize-refresh
📢 Become a member: <a Continue reading “So, we just wait???”
How To Count Count Distinct Values In Excel
In this video, Greg goes through different approaches on how you can count distinct values in Excel from more traditional way to a more modern technique.
***** Video Details *****
00:00 Introduction
00:26 Overview
01:16 Data set
01:36 Remove duplicates method
02:45 Count distinct method
04:35 Dynamic Continue reading “How To Count Count Distinct Values In Excel”
How To Embed And Play Videos In Your Power BI Reports
We at Enterprise DNA do our best to cover as much topics as possible in the vast world of Power BI and data analytics. But despite the numerous content we have in our platforms, it was brought to our attention Continue reading “How To Embed And Play Videos In Your Power BI Reports”
How To Refresh An Excel File In Sharepoint With Power Automate Desktop
For today’s tutorial, Jarrett is going to demonstrate how you can create a Power Automate Desktop flow using an Excel file in Sharepoint.
***** Video Details *****
00:00 Introduction
00:39 The goal
01:51 Creating a new flow
02:57 Opening Excel in Sharepoint
05:58 Running the flow
06:27 Continue reading “How To Refresh An Excel File In Sharepoint With Power Automate Desktop”
Revisiting a Power BI solution with Dynamic M Parameters
Dynamic M Parameters for SQL are here in Power BI! YES!!! Let’s revisit a Power BI solution and how we can take it to the next LEVEL using these!
LEVEL UP Power BI Conditional Drill with Paginated reports!
rel=”nofollow”>https://youtu.be/43CwBmaym8Q
Teo Lachev’s Blog:
https://prologika.com/power-bi-dynamic-m-query-parameters-reloaded/
Chris Webb’s Blog:
https://blog.crossjoin.co.uk/2022/02/20/tsql-table-valued-functions-and-dynamic-m-parameters-in-power-bi-directquery/
Documentation:
https://docs.microsoft.com/power-bi/connect-data/desktop-dynamic-m-query-parameters
📢 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 – https://guyinacube.com/tools/
#PowerBI #PowerQuery #GuyInACube
Environmental Data Reporting | Power BI Challenge Winner – Best Practices
EVENT DETAILS – https://enterprisedna.co/power-bi-challenge-winner-best-practices-march-2022-registration/
RESOURCE DOWNLOAD – https://portal.enterprisedna.co/p/webinar-series-resources-free/
When is it?
March 10th – 5pm New York (ET), 2pm Los Angeles (PT), 10pm London (GMT)
March 11th – 9am Sydney (AEDT), 11am Auckland (NZDT)
Where is it?
Join in from Continue reading “Environmental Data Reporting | Power BI Challenge Winner – Best Practices”
How To Load Sample Datasets In Python
In this video, George will demonstrate how you can load sample datasets in Python. It may not seem as a particularly exciting topics but it’s definitely something important to learn. Sample datasets are not only good to practice on when Continue reading “How To Load Sample Datasets In Python”