Month: May 2024

Expert Tips for Managing OneLake Data Access in Microsoft Fabric

Posted on by Annie D

Learn how to control access to OneLake data the right way in Microsoft Fabric with these security tips. Keep your data safe and secure with these best practices!

OneLake data access roles – Public Preview Announcement
https://blog.fabric.microsoft.com/en-us/blog/9046?ft=All

OneLake security overview
https://learn.microsoft.com/fabric/onelake/security/get-started-security

Role-based access control (RBAC)
https://learn.microsoft.com/fabric/onelake/security/data-access-control-model

Microsoft Fabric security white paper
https://learn.microsoft.com/fabric/security/white-paper-landing-page

Aaron Merrill:
LinkedIn: https://www.linkedin.com/in/aajmerrill/

📢 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 “Expert Tips for Managing OneLake Data Access in Microsoft Fabric” →

Leverage RLS with Direct Lake in Microsoft Fabric without access to OneLake

Posted on by Annie D

You don’t want to give your users access to OneLake or the Lakehouse/Warehouse directly, but you still want to use Power BI Direct Lake in Microsoft Fabric. Patrick shows you a way to get this done!

Direct Lake Overview
https://learn.microsoft.com/fabric/get-started/direct-lake-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
— http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— Continue reading “Leverage RLS with Direct Lake in Microsoft Fabric without access to OneLake” →

Unleash Your Power BI Mobile Audience Potential with Automated layouts!

Posted on by Annie D

Your Power BI Report consumers are probably using the Power BI Mobile app. Have you set up a layout for mobile? Patrick shows you how to quickly create a layout with 1 click!

Automatic mobile layout creation
https://learn.microsoft.com/power-bi/create-reports/power-bi-create-mobile-optimized-report-mobile-layout-view?tabs=powerbi-desktop#automatic-mobile-layout-creation

📢 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 href="https://guyinacube.com" Continue reading “Unleash Your Power BI Mobile Audience Potential with Automated layouts!” →

DAME 04: Data Analysis with Excel Worksheet Formulas: 4 Comprehensive examples.

Posted on by Annie D

Download files: https://people.highline.edu/mgirvin/AllClasses/348/348/2024/Content/Week06/Video04Files.zip
Free YouTube Data Analysis Class about Microsoft Power Tools in 2024 taught by Excel MVP and Highline College Professor, Mike “excelisfun” Girvin.
In this video learn about when Excel worksheet formulas are the perfect tool for data analysis. An hour lesson in the power of Excel worksheet formulas and when they beat PivotTables, Power Query and Power BI.
Topics:
1. (00:00) Introduction
2. (00:40) 4 scenarios where worksheet formulas are better than other tools.
3. (02:33) Example #1: Enter Data In Worksheet & Need Analysis Off To Side.
4. (03:22) MOD function for hours worked formula
5. (05:19) Line Chart
6. (06:37) 7-Day Continue reading “DAME 04: Data Analysis with Excel Worksheet Formulas: 4 Comprehensive examples.” →

🔴 Let’s talk Microsoft Fabric – LIVE w/ Matthew Roche (May 4, 2024) (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

Connect with Matthew:
Mastodon: https://techhub.social/@SQLAllFather
YouTube: <a href="https://www.youtube.com/" Continue reading “🔴 Let’s talk Microsoft Fabric – LIVE w/ Matthew Roche (May 4, 2024) (Member Chat 2nd Half)” →

Can’t create a relationship? Time for a surrogate key in Power BI!

Posted on by Annie D

This looks at a scenario of a hierarchy but the child ID repeats and we can’t create a relationship on it. Adam looks at how you could use a surrogate key to get a relationship in place so you can build your Power BI report.

📢 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
— Continue reading “Can’t create a relationship? Time for a surrogate key in Power BI!” →

Data Mentor meets EDNA AI

Posted on by Annie D

Discover how Data Mentor seamlessly integrates with Enterprise DNA’s suite of tools to provide an unparalleled learning experience, demonstrated through the use of agents to tackle complex learning projects and guided learning interactions for personalized skill development in Power BI and DAX.

Details of what you will learn during this video:

– Integration of Data Mentor with Enterprise DNA’s tools
– Utilization of agents for complex learning projects
– Guided learning interactions for personalized skill development in Power BI and DAX

***** Learning with Enterprise DNA *****
FREE Courses – https://bit.ly/45fu3tw
FREE Resources – https://bit.ly/455Hw6O
Enterprise DNA On-Demand – <a href="https://app.enterprisedna.co/app" Continue reading “Data Mentor meets EDNA AI” →

Getting creative with a Line Chart in Power BI

Posted on by Annie D

Saw an interesting conversation about a line chart and some different approaches in Power BI. Adam explored those options and explains the differences. Never stop tinkering with visuals!

Twitter conversation:
https://twitter.com/CJMajka/status/1781039450199302195

📢 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 “Getting creative with a Line Chart in Power BI” →

Solving Real Problems and Improving Your Productivity

Posted on by Annie D

Data Mentor seamlessly integrates into your daily workflow, offering solutions, productivity improvements, and deep learning opportunities through real-world problem-solving scenarios.

Details of what you will learn during this video:

– Data Mentor’s role in enhancing daily workflow
– Examples showcasing Data Mentor’s problem-solving in Enterprise DNA forum
– AI tools used to tackle complex forum questions
– Step-by-step guide to solving questions with Data Mentor
– Demonstrations of measure branching and code simplification
– Saving and sharing valuable insights within Data Mentor

***** Learning with Enterprise DNA *****
FREE Courses – https://bit.ly/45fu3tw
FREE Resources – https://bit.ly/455Hw6O
Enterprise DNA On-Demand – https://app.enterprisedna.co/app
Enterprise Continue reading “Solving Real Problems and Improving Your Productivity” →

Make Learning a Habit with Data Mentor

Posted on by Annie D

Discover how to use Data Mentor to learn anything new, showcasing its versatility and effectiveness for general learning through personalized workflows and comprehensive guides covering SQL fundamentals and beyond.

Details of what you will learn during this video:

– Understanding the functionality of Data Mentor.
– Exploring personalized learning paths for various topics.
– Mastering SQL and other subjects using comprehensive guides.
– Leveraging the efficiency and speed of Data Mentor for learning.

***** Learning with Enterprise DNA *****
FREE Courses – https://bit.ly/45fu3tw
FREE Resources – https://bit.ly/455Hw6O
Enterprise DNA On-Demand – https://app.enterprisedna.co/app
Enterprise DNA Subscriptions – https://app.enterprisedna.co/pricing
Enterprise Continue reading “Make Learning a Habit with Data Mentor” →