Category: Power Query

Here’s a BANANAS report design idea!

Posted on by Annie D

There are many things you can do in a Power BI report that aren’t super complex. Here are a few ideas to get you thinking! If Adam can do this, you definitely can! Shout out to Chris Hamill for this design!

Chris Hamill:
https://twitter.com/ChrisHamill17

Info Panel Video: https://www.youtube.com/watch?v=yYr_SlG8bpw

Mastering Bookmarks: https://www.youtube.com/watch?v=xCMqWEvSkAs

Custom Background: https://www.youtube.com/watch?v=0QvovI3aycs

📢 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!
*******************

— Continue reading “Here’s a BANANAS report design idea!” →

MrExcel’s Favorite Excel Tricks & Tips – 2022

Posted on by Annie D

Special ESPN Pricing:
https://www.mrexcel.com/news/special-ocho-deals-on-training-books-to-celebrate-excel-being-on-espn/

The Excel All Star Battle will air on ESPN2 at:
Friday August 5, 2022 at 5 AM Eastern. (2 AM Pacific. 10 AM in London.)
Sunday August 7, 2022 at 9AM Eastern. (6 AM Pacific, Noon in London.)
Monday August 8 (8/8!), 2022 at 11:30 PM Eastern. (8:30 PM Pacific – Prime Time, Baby! And 4:30 AM Tuesday in London).

Bill’s favorite Excel trick: Fast Formula Copy, as well as a lot of other items.

Table of Contents
(0:00) Historical re-enactment
(0:20) Data description
(1:00) Begins typing
(1:38) Adding text is #VALUE error
(1:57) & to Concatenate
(2:10) FORMULATEXT function
(2:36) Adding a space while joining Continue reading “MrExcel’s Favorite Excel Tricks & Tips – 2022” →

What if we could RATE a Power BI report page?

Posted on by Annie D

Have you wanted the ability to give ratings or feedback on Power BI reports? Have your users tell you what they think? Patrick shows you a way you can do this using Power Automate!

📢 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 Continue reading “What if we could RATE a Power BI report page?” →

Can you be a Data Scientist without actually being a Data Scientist???

Posted on by Annie D

Forecasting data and other items are usually stuff that data scientists use to tell the future. What if you could do the same thing – EASILY! Tzvia is back to show you how Azure Data Explorer can help!

Connect with Tzvia:
https://www.linkedin.com/in/tzvia/
https://twitter.com/tzvia

Time series analysis in Azure Data Explorer
https://docs.microsoft.com/azure/data-explorer/time-series-analysis

Anomaly detection and forecasting in Azure Data Explorer
https://docs.microsoft.com/azure/data-explorer/anomaly-detection

Machine learning capability in Azure Data Explorer
https://docs.microsoft.com/azure/data-explorer/machine-learning-clustering

📢 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 “Can you be a Data Scientist without actually being a Data Scientist???” →

Generate Excel Formulas Using Artificial Intelligence – 2496

Posted on by Annie D

ExcelFormulaBot.com is a free A.I. bot that generates the Excel formula for any problem. You type a sentence. It suggests a formula. Free from David Bressler.

Table of Contents
(0:00) This is cool
(0:36) Formula for last word
(1:15) Formula for Prime Numbers
(2:23) Excel All Star Battle on ESPN8 The Ocho

Learn Excel From Mr Excel: SmartRoster Doesn’t Work, Microsoft Blocks Macros

Posted on by Annie D

Episode 2491 – While using SmartRoster software, you try to export a report to Word. The export does not start and you get a message that says, “Microsoft Word Security Notice. Microsoft Office has identified a potential security concern. Microsoft has blocked macros from running because the source of this file is untrusted.”

I recently posted episode 2485 that attempted to allow macros by using the Unblock checkbox in the workbook properties. That method won’t work here. Instead, you can temporarily set up a trusted location. This video shows you how.

Table of Contents
(0:00) Microsoft is blocking macros from running.
(0:53) Continue reading “Learn Excel From Mr Excel: SmartRoster Doesn’t Work, Microsoft Blocks Macros” →

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

Discovering data within Power BI and quickly EXPORT!

Posted on by Annie D

Sometimes you just don’t know what data is out there in Power BI. Patrick shows you how you can discover data available to you and also how to quickly export that data! Even with just a Pro account!

Data discovery using the data hub
https://docs.microsoft.com/power-bi/connect-data/service-data-hub?tabs=datasets

Create exportable formatted data tables in the Power BI service
https://docs.microsoft.com/power-bi/paginated-reports/paginated-formatted-table

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

FAST – Billions of rows with Azure Data Explorer (ADX)

Posted on by Annie D

Have you tried Azure Data Explorer? We look at how ADX can support large amounts of data and query at blazing fast speeds. it truly is BANANAS! And you can try it for FREE!

Connect with Tzvia:
https://www.linkedin.com/in/tzvia/
https://twitter.com/tzvia

What is Azure Data Explorer?
https://docs.microsoft.com/azure/data-explorer/data-explorer-overview

Create a free Azure Data Explorer cluster
https://docs.microsoft.com/azure/data-explorer/start-for-free-web-ui

Azure Data Explorer (ADX) free cluster with Upgrade option
https://techcommunity.microsoft.com/t5/azure-data-explorer-blog/azure-data-explorer-adx-free-cluster-with-upgrade-option/ba-p/3576347

📢 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 Continue reading “FAST – Billions of rows with Azure Data Explorer (ADX)” →

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

The most UNDERUSED feature in Power BI???

Posted on by Annie D

What would you say is the most UNDERUSED feature of Power BI? Adam gives you his opinion and talks about why he thinks that is. Do you agree?

Page intentionally left blank
https://www.youtube.com/watch?v=M_nS1Liey-w

Review Performance Analyzer in this Power BI Report from Smart Power BI
https://www.youtube.com/watch?v=Z-J4n9uymQ0

Use Performance Analyzer to examine report element performance
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-performance-analyzer

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

Prevent Excel From Changing Numbers On Import – 2494

Posted on by Annie D

I love this feature so much, I turned it off!
For decades, Excel has been performing default data conversions:
Remove leading zeroes
Keep first 15 digits of long numbers and convert to scientific notation
Convert digits surrounding an E to scientific notation.

New in Insiders beta, Excel will ask if you want to do all three of those things. The first time, I was happy to click Don’t Convert.
But I think the real solution is to embrace all three options and turn all three of them off! They have been annoying us for so long. Why would you want Microsoft to ask, “Hey, should we Continue reading “Prevent Excel From Changing Numbers On Import – 2494” →