Category: Power Query

Data From Picture is here in Excel!

Posted on by Annie D

Episode 2490:
The Android phone has had it for a long time, but the new Data From Picture has finally reached the Office Insiders beta channel on desktop Excel. Bill gives this new feature a spin with various pictures of data.

Table of Contents
(0:00) Speech Recognition 1989 to today
(1:10) From Picture near Power Query tools
(1:35) Creating data picture
(2:00) Data From Picture no gridlines
(3:40) Cleaning the results
(4:15) The numbers all match
(4:30) Gridlines don’t help
(5:35) Right-align headings
(7:20) Need to proof
(7:50) With real photo test 1
(8:40) From clipboard test 2
(10:03) This will improve

Why can’t Power BI connect to my cloud source???

Posted on by Annie D

You have a cloud data source like Azure SQL Database. Why can’t Power BI connect to it? They are both in the cloud! Adam shows you some things to consider and options you have!

What is an on-premises data gateway?
https://docs.microsoft.com/data-integration/gateway/service-gateway-onprem

What is a virtual network (VNet) data gateway?
https://docs.microsoft.com/data-integration/vnet/overview

📢 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
— <a Continue reading “Why can’t Power BI connect to my cloud source???” →

From Decomposition Tree to Details in Power BI!!!

Posted on by Annie D

The Decomposition Tree is an amazing visual but how can we get to the details. Where’s my drill through? Patrick walks you through how you can set this up in Power BI Desktop!

Create and view decomposition tree visuals in Power BI
https://docs.microsoft.com/power-bi/visuals/power-bi-visualization-decomposition-tree

Set up drillthrough in Power BI reports
https://docs.microsoft.com/power-bi/create-reports/desktop-drillthrough

Wyn Hopkins
https://twitter.com/wynhopkins

📢 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 “From Decomposition Tree to Details in Power BI!!!” →

Modern Data Lakehouse? Where do you even start??? Azure Synapse of course!

Posted on by Annie D

Trying to get started with a Modern Data Lakehouse? There are so many options today. Where do you even begin? Patrick and Stijn help you get a handle on it with Azure Synapse Analytics!

Stijn Wynants
https://twitter.com/SQLStijn

Building a Modern Lakehouse Data Warehouse with Azure Synapse Analytics: Moving your Database to the lake
https://sql-stijn.com/2022/06/14/building-a-modern-lakehouse-data-warehouse-with-azure-synapse-analytics-moving-your-database-to-the-lake/

Pipelines and activities in Azure Data Factory and Azure Synapse Analytics
https://docs.microsoft.com/azure/data-factory/concepts-pipelines-activities

Integrate with pipelines
https://docs.microsoft.com/azure/synapse-analytics/get-started-pipelines

📢 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 “Modern Data Lakehouse? Where do you even start??? Azure Synapse of course!” →

Publish from Power BI Desktop for External Users

Posted on by Annie D

Have you ever wanted to publish from Power BI Desktop to a different organization? External Users publishing!!! I show you how you can log in as an external user in Power BI Desktop and then publish. BANANAS!!!

Ross Couldrey
LinkedIn: https://www.linkedin.com/in/rosscouldrey/

Distribute Power BI content to external guest users using Azure Active Directory B2B
https://docs.microsoft.com/power-bi/guidance/whitepaper-azure-b2b-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
— Continue reading “Publish from Power BI Desktop for External Users” →

What tool do you use to optimize your Power BI dataset?

Posted on by Annie D

Need some help optimizing your Power BI Dataset but don’t want to hand over your Power BI Desktop file? Patrick shows you some tools to get information to help with optimizing assistance! These are tools we use EVERYDAY!

DAX Studio
https://daxstudio.org/

Bravo for Power BI
https://bravo.bi/

Tabular Editor 3
https://tabulareditor.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 courses: https://guyinacu.be/courses

*******************
LET’S CONNECT!
*******************

— http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— Continue reading “What tool do you use to optimize your Power BI dataset?” →

What are the main tools for Azure Synapse and SQL???

Posted on by Annie D

Getting started with Azure Synapse Analytics or Azure SQL Database? Or even Microsoft SQL Server in general? Patrick shows you how to use some of the common tools and be able to connect to your instance!

Download SQL Server Management Studio
https://docs.microsoft.com/sql/ssms/download-sql-server-management-studio-ssms

Download and install Azure Data Studio
https://docs.microsoft.com/sql/azure-data-studio/download-azure-data-studio

📢 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
— <a href="http://twitter.com/patrickdba" Continue reading “What are the main tools for Azure Synapse and SQL???” →

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

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

Answering your datamart questions

Posted on by Annie D

You’ve got a LOT of questions about datamarts in Power BI! Adam answers a few that we’ve seen popping up. Giving his thoughts on these questions.

Introduction to datamarts
https://docs.microsoft.com/power-bi/transform-model/datamarts/datamarts-overview

Comparing dataflows to datamarts
https://docs.microsoft.com/power-bi/transform-model/datamarts/datamarts-overview#comparing-dataflows-to-datamarts

When to use dataflows
https://docs.microsoft.com/power-bi/transform-model/dataflows/dataflows-introduction-self-service#when-to-use-dataflows

📢 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
— <a href="https://www.instagram.com/guyinacube/" Continue reading “Answering your datamart questions” →

Power BI dataflows vs datamarts: What’s the difference???

Posted on by Annie D

Are you excited about datamart in Power BI? What about dataflows? Should you even use dataflows anymore? Do we just datamart all the things? Let’s have a look!

Introduction to datamarts
https://docs.microsoft.com/power-bi/transform-model/datamarts/datamarts-overview

Comparing dataflows to datamarts
https://docs.microsoft.com/power-bi/transform-model/datamarts/datamarts-overview#comparing-dataflows-to-datamarts

When to use dataflows
https://docs.microsoft.com/power-bi/transform-model/dataflows/dataflows-introduction-self-service#when-to-use-dataflows

Dataflows with benefits
https://ssbipolar.com/2022/05/25/dataflows-with-benefits/

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

#PowerBI #datamart #GuyInACube

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