Category: Power Query

Want a BEAUTIFUL Power BI Report? Start here!

Posted on by Annie D

If you are like us, creating beautiful Power BI reports doesn’t come easy. Mara Pereira joins us to show us where to start to get amazing and beautiful Power BI reports even with no designer background.

Dribbble
https://dribbble.com/

Freepik
https://www.freepik.com/

Figma
https://www.figma.com/

Adobe Color
https://color.adobe.com/create/color-wheel

Coolors
https://coolors.co/

Connect with Mara Pereira:
https://www.datapears.com/
https://www.youtube.com/@datapears
https://twitter.com/datapears
https://www.linkedin.com/in/marapereira/

📢 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 “Want a BEAUTIFUL Power BI Report? Start here!” →

Why is there a limited relationship when using the same data source?

Posted on by Annie D

Using Power BI Desktop and notice that you have some limited relationships in your model? Patrick discovered an interesting issue that threw him off at first. Learn how he solved it!

Model relationships in Power BI Desktop
https://learn.microsoft.com/power-bi/transform-model/desktop-relationships-understand

Regular and limited relationships in Power BI (SQLBI)
https://www.sqlbi.com/articles/strong-and-weak-relationships-in-power-bi/

📢 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
— Continue reading “Why is there a limited relationship when using the same data source?” →

Controlling cost with Azure Synapse Serverless Pools

Posted on by Annie D

Curious how to save cost when using Azure Synapse Serverless Pools? Any way to minimize the amount of data you are processing? Patrick shows you how and has a script for you!

Cost management for serverless SQL pool in Azure Synapse Analytics
https://learn.microsoft.com/azure/synapse-analytics/sql/data-processed

Azure Synapse Toolbox
https://github.com/microsoft/Azure_Synapse_Toolbox

Sample Query: https://pastebin.com/iRKagQHR

📢 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
— rel=”nofollow”>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 #Serverless #GuyInACube

Excel for Mac New AddIn Brings More Data To Power Query – 2598

Posted on by Annie D

Power Query for Mac Excel is missing From Table/Range.
Power Query for Mac Excel is missing From Folder.
Power Query for Mac Excel is missing From XML.
Power Query for Mac Excel is missing From JSON.

A new More Data add-in from Suat Ozgur at MrExcel adds all four of these functionalities to Excel for Mac! Download the add-in from this article: https://www.mrexcel.com/board/excel-articles/morequery-for-mac.68/

The FREE, open-source add-in adds From Table/Range to Power Query for Mac. It adds From Folder. It adds From XML. It adds from JSON.

Table of Contents:
(0:00) More Data Add-In fixes Power Query for Mac
(0:37) Get Data From Table/Range Continue reading “Excel for Mac New AddIn Brings More Data To Power Query – 2598” →

Excel Technique Refer To Every Third Column From Bob Umlas 2583

Posted on by Annie D

Microsoft Excel Puzzle and Solutions.
Bob Umlas sent in the puzzle. How to refer to every 3rd column on Sheet2?

Table of Contents
(0:00) Bob Umlas Book
(0:22) Problem: Refer to every 3rd cell
(0:44) CHOOSECOLS with SEQUENCE
(1:16) Horizontal XLOOKUP
(1:46) Fill Handle from 3 Cells
(2:32) Delete Empty Cells
(2:54) R1C1 Method 2
(3:43) Replace = with x=
(4:12) Change R1C1 to A1
(4:21) Insert colums/rows to test

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

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 1, 2023)” →

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

The HEART of Power BI

Posted on by Annie D

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” →

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

Posted on by Annie D

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

How to SCHEDULE your notebooks to run with Azure Synapse

Posted on by Annie D

Taking advantage of Notebooks in Azure Synapse Analytics? How do you automate that great work you did? Patrick shows you some options to schedule the run of your notebooks.

📢 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 – <a href="https://guyinacube.com/tools/" Continue reading “How to SCHEDULE your notebooks to run with Azure Synapse” →

Mac Excel Power Query Three Missing Connector Workarounds – Episode 2597

Posted on by Annie D

Great news: Power Query debuted for the Mac in early 2023.
Bad news: It is missing four important connectors:
• From Table/Range – Fixed in this video
• From Web – Fixed in this video
• From Folder – Fixed in this video
• From PDF – no solution yet.

Thanks to Suat Ozgur – our resident Mac expert at MrExcel, we have solutions for three of those connectors.

Table of Contents
(0:00) Problem Statement
(1:17) From Table or Range
(2:44) How to edit query
(3:33) New icons in Applied Steps
(3:59) From Web
(5:17) From Folder
(9:45) No solution for From PDF yet
(10:27) Thanks to Excel Team
(11:15) Subfolders granted access
(11:24) Avoiding VBA

REPLAY Power BI Adoption and More Q&A with Melissa Coates and Matthew Roche!

Posted on by Annie D

Join us live as we answer your questions about Power BI Adoption and more with special guests, Melissa Coates and Matthew Roche!

📢 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

The Hitchhiker’s Guide to Adopting Power BI in Your Organization
https://CoatesDS.com/Hitchhikers-Guide

Power BI Adoption Roadmap: https://aka.ms/PowerBIAdoptionRoadmap
Power BI Implementation Planning: https://aka.ms/PowerBIImplementationPlanning

Connect with Melissa:
Power BI Deployment & Continue reading “REPLAY Power BI Adoption and More Q&A with Melissa Coates and Matthew Roche!” →