Author: Annie D

Adding a column to your Lakehouse? Where is it in the Semantic Model???

Posted on by Annie D

When you add a column to your lakehouse in Microsoft Fabric, why isn’t is showing up in the Power BI Semantic Model? Patrick shows you how to get it there!

Gaston Cruz
https://twitter.com/GastonFCruz
https://www.linkedin.com/in/gastoncruz/

📢 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***
🛠 Continue reading “Adding a column to your Lakehouse? Where is it in the Semantic Model???” →

Become A Power BI Power User With DAX

Posted on by Annie D

Business Intelligent Summit are action packed live events showcasing a variety of beginner to advanced Power BI/Power Platform tips and techniques. Summit sessions have a unique focus on how anyone can build and develop analytical solutions with Power BI that solve real-world business problems. Thousands attend these events live to watch and learn from a real-time demo.

***** Details of what you will learn during this event series module *****
Control – the Query, Filter, and Row contexts to write DAX expressions
Realize – what you can achieve when you use the CALCULATE function to inject a filter context
Learn – how to Continue reading “Become A Power BI Power User With DAX” →

REPLAY Microsoft Fabric / Power BI Q&A – LIVE (Nov 4, 2023)

Posted on by Annie D

Join us live as we answer your questions about Microsoft Fabric (including Power BI)! Get your questions in the chat early as we don’t get to all of them.

NOTE: European friends, Time zone trickery is here. It’s an hour different from what it normally is.

💥 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 Continue reading “REPLAY Microsoft Fabric / Power BI Q&A – LIVE (Nov 4, 2023)” →

REPLAY Microsoft Fabric / Power BI Q&A – LIVE (Nov 11, 2023)

Posted on by Annie D

Join us live as we answer your questions about Microsoft Fabric (including Power BI)! Get your questions in the chat early as we don’t get to all of them.

💥 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 Continue reading “REPLAY Microsoft Fabric / Power BI Q&A – LIVE (Nov 11, 2023)” →

REPLAY Microsoft Fabric / Power BI Q&A – LIVE (Dec 9, 2023)

Posted on by Annie D

Join us live as we answer your questions about Microsoft Fabric (including Power BI)! Get your questions in the chat early as we don’t get to all of them.

💥 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 Continue reading “REPLAY Microsoft Fabric / Power BI Q&A – LIVE (Dec 9, 2023)” →

REPLAY Microsoft Fabric / Power BI Q&A – LIVE w/ Kim Manis & Bogdan Crivat (Dec 16, 2023)

Posted on by Annie D

Join us live as we answer your questions about Microsoft Fabric (including Power BI) with special guests Kim Manis & Bogdan Crivat from the Fabric Product Team! Get your questions in the chat early as we don’t get to all of them.

This is also the last stream of 2023. It’s time to donate the money in the “It Depends” jar! We have also listed this stream as a fundraiser stream for St. Jude Children’s Hospital. The mission of St. Jude Children’s Research Hospital is to advance cures, and means of prevention, for pediatric catastrophic diseases through research and treatment. Learn Continue reading “REPLAY Microsoft Fabric / Power BI Q&A – LIVE w/ Kim Manis & Bogdan Crivat (Dec 16, 2023)” →

REPLAY Starting off 2024! Microsoft Fabric LIVE Q&A (Jan 6, 2024)

Posted on by Annie D

Join us live as we start off 2024 by answering your questions your questions about Microsoft Fabric (including Power BI)! Get your questions in the chat early as we don’t get to all of them.

💥 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 Continue reading “REPLAY Starting off 2024! Microsoft Fabric LIVE Q&A (Jan 6, 2024)” →

Join us at SQLBits 2024 and save 10%!

Posted on by Annie D

We will be at SQLBits and want to see you there! You can save 10% by using code giac10. Join us to learn great stuff about Microsoft Fabric and Power BI!

SQLBits 2024
Farnborough, UK
March 19-23, 2024
https://sqlbits.com
Theme: Aviation
10% discount: giac10

📢 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/
— Continue reading “Join us at SQLBits 2024 and save 10%!” →

Don’t Use PivotTables. Use COUNTIFS or FREQUNCY Functions Instead. Excel Magic Trick 1849

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1847-1849.xlsx
Learn about how PivotTables cannot include upper limit when grouping number data with decimals. COUNTIFS and FREQUNCY Functions do include upper limits when grouping numbers into upper and lower limit categories.
Topics:
1. (00:00) Introduction
2. (00:06) PivotTable
3. (01:45) COUNTIFS
4. (02:49) Text Labels for Formula Report
5. (03:25) Find Feature to create labels for PivotTable
6. (03:56) FREQUENCY Array Function
7. (05:15) Summary
8. (05:30) Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftexcel #microsoftmvp #lookup #xlookup

🔴 Microsoft Fabric / Power BI Q&A – LIVE (Feb 3, 2023) (Member Chat 2nd Half)

Posted on by Annie D

Join us live as we answer your questions about Microsoft Fabric (including Power BI)! Get your questions in the chat early as we don’t get to all of them.

💥 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 Continue reading “🔴 Microsoft Fabric / Power BI Q&A – LIVE (Feb 3, 2023) (Member Chat 2nd Half)” →

Power BI Tips: Excluding Top N with DAX

Posted on by Annie D

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

Use Source Control with your Power BI Report in Microsoft Fabric!

Posted on by Annie D

People have been asking for source control with Power BI reports for a long time. It’s here in Microsoft Fabric! Adam explores how to set this up.

Introduction to Git integration (preview)
https://learn.microsoft.com/fabric/cicd/git-integration/intro-to-git-integration

Manage a workspace with Git (preview)
https://learn.microsoft.com/fabric/cicd/git-integration/git-get-started?tabs=commit-to-git

Power BI Desktop projects (PREVIEW)
https://learn.microsoft.com/power-bi/developer/projects/projects-overview

Git
https://git-scm.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
— <a Continue reading “Use Source Control with your Power BI Report in Microsoft Fabric!” →