Category: Power Query

What is this delta lake thing?

Posted on by Annie D

You may be using a lake for your data and it may just be regular parquet files. In this video, Stijn joins us to explain why you should be using a delta lake instead and how this works in Azure Synapse Analytics.

Connect with Stijn
https://twitter.com/SQLStijn

What is Delta Lake
https://docs.microsoft.com/azure/synapse-analytics/spark/apache-spark-what-is-delta-lake

Delta Lake Documentation
https://docs.delta.io/latest/delta-intro.html

📢 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/

#AzureSynapse #DeltaLake #GuyInACube

🔴 Visualization Q&A – LIVE w/ Alberto Cairo (Sept 3, 2022)

Posted on by Annie D

Prioritizing questions around visualizations, design, etc…

📢 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

Connect with Alberto Cairo:
https://twitter.com/AlbertoCairo
https://www.linkedin.com/in/albertocairo/
http://albertocairo.com/
http://www.thefunctionalart.com/

📢 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 Continue reading “🔴 Visualization Q&A – LIVE w/ Alberto Cairo (Sept 3, 2022)” →

Excel Switch All Pivot Value Fields To Average or Max 2498

Posted on by Annie D

Jeremy asks Is there a way to select multiple headings and change all of their “Summarize value field by” at once? I have hundreds of headings, each time I want to change their value by Max, Min, Average, I have to select one heading at a time, it is extremely labor intensive. Is there a way to change field calculation for multiple headings at once?

This episode shows some simple VBA to do this quickly.

How to create a personal macro workbook: https://www.youtube.com/watch?v=ld2SU2zJvHA

Table of Contents
(0:00) Welcome
(0:41) VBA
(1:55) Looping each field
(2:35) Copying for Sum, Max, Min
(3:10) Other calculations
(3:42) Easier way Continue reading “Excel Switch All Pivot Value Fields To Average or Max 2498” →

Get creative with buttons in Power BI!

Posted on by Annie D

Want to know how to create a button in Power BI that has an icon along with text? Adam walks you through how to set this up and to have colors sync when interacting with it.

Get feedback from your Power BI report users!
https://www.youtube.com/watch?v=0WfITrMl0hc

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

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

#PowerBI #Buttons #GuyInACube

Refresh and NO DATA in my Power BI visuals???

Posted on by Annie D

Have you published your Power BI report to the service, refresh the data, and the visuals go blank? Patrick may have an answer for you.

Troubleshooting refresh scenarios
https://docs.microsoft.com/power-bi/connect-data/refresh-troubleshooting-refresh-scenarios

Data types in Power BI Desktop
https://docs.microsoft.com/power-bi/connect-data/desktop-data-types

Damu Venkatesan:
https://twitter.com/vdamu
https://www.linkedin.com/in/damuvenkatesan/

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

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

#PowerBI #Visuals #GuyInACube

Get started with SPARK in Azure Synapse Analytics

Posted on by Annie D

Using Spark in Azure Synapse Analytics opens up a lot of possibilities to work with your data. Venk joins us to get you started with setting it up and quickly using data.

Connect with Venk:
https://www.linkedin.com/in/venkatesh-titte-4907467/

Apache Spark in Azure Synapse Analytics
https://docs.microsoft.com/azure/synapse-analytics/spark/apache-spark-overview

Azure Open Datasets
https://docs.microsoft.com/azure/open-datasets/dataset-catalog

📢 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
— rel=”nofollow”>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/

#AzureSynapse #Spark #GuyInACube

🔴 100th Power BI Q&A Live Stream!!! (August 20, 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 “🔴 100th Power BI Q&A Live Stream!!! (August 20, 2022) (Member Chat 2nd Half)” →

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

Excel Show Symbols For Gamma And Beta – 2497

Posted on by Annie D

This actually applies to any character that you want to display in Excel that is in the Unicode character set. Microsoft gave us functions for UNICODE and UNICHAR. It is not intuitive, but you have to use UNICHAR to solve this.

However, the websites showing the unicode are often showing the number in Hex, so you have to use HEX2DEC before passing the value into UNICODE.

Table of Contents
(0:00) What is gamma and beta
(0:13) Results of googling
(0:32) History of CODE and CHAR
(0:54) UNICODE isn’t it
(1:22) UNICHAR of HEX2DEC
(1:51) Displaying Beta in Excel
(2:21) ESPN Wrap up
(2:59) Retrieve Webinar
(3:30) Episode 2500 Continue reading “Excel Show Symbols For Gamma And Beta – 2497” →

Get feedback from your Power BI report users!

Posted on by Annie D

What if you could find out what your users want directly from your Power BI Reports? What if users could submit bugs and feedback for your report? Adam shows you a way to do it!

Connect with Chris:
https://twitter.com/ChrisHamill17

📢 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/
— <a Continue reading “Get feedback from your Power BI report users!” →

You thought DAX? Alex shows you Dynamic M-M-Magic!

Posted on by Annie D

We thought that DAX was the thing in Power BI. Alex proves the M-M-Magic is really with Power Query! If you wanted to be blown away but what Power Query can do, this is the video for you!

Connect with Alex:
https://twitter.com/notaboutthecell
https://www.linkedin.com/in/alexmpowers/

Power Query folding
https://docs.microsoft.com/power-query/power-query-folding

30 Day Challenge: Query Folding
https://www.youtube.com/playlist?list=PLKW7XPyNDgRCorKNS1bfZoAO3YSIAVz3N

Power Query M function reference
https://docs.microsoft.com/powerquery-m/power-query-m-function-reference

📢 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: <a Continue reading “You thought DAX? Alex shows you Dynamic M-M-Magic!” →

Top 5 things to get started with Azure Synapse Analytics

Posted on by Annie D

Getting started with Azure Synapse Analytics? Here are 5 things you should know as you begin your journey! Already been using Synapse SQL dedicated pools? Are you aware of these items?

Connect with Shane:
https://www.linkedin.com/in/shanerisk/

Best Practices: https://docs.microsoft.com/azure/synapse-analytics/sql/best-practices-dedicated-sql-pool

What is dedicated: https://docs.microsoft.com/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-overview-what-is

Table Distribution: https://docs.microsoft.com/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-distribute

Indexes: https://docs.microsoft.com/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-index

Statistics: https://docs.microsoft.com/azure/synapse-analytics/sql/develop-tables-statistics

Data Loading: https://docs.microsoft.com/azure/synapse-analytics/sql/data-loading-best-practices

📢 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: <a Continue reading “Top 5 things to get started with Azure Synapse Analytics” →