Author: Annie D

Your Microsoft Fabric Is a Mess Without DOMAINS!

Posted on by Annie D

Have you been using Domains? They are a great way to organize items within Microsoft Fabric and to allow delegation of tenant settings. Adam shows you what they are all about!

Fabric domains
https://learn.microsoft.com/fabric/governance/domains

Best practices for planning and creating domains in Microsoft Fabric
https://learn.microsoft.com/fabric/governance/domains-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: https://guyinacu.be/courses

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

— http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— http://twitter.com/patrickdba
— <a href="http://www.facebook.com/guyinacube" Continue reading “Your Microsoft Fabric Is a Mess Without DOMAINS!” →

OneLake Integration for Power BI Semantic Models

Posted on by Annie D

Want your Power BI Semantic Model data within OneLake? You may not have to rebuild anything. Patrick looks at how you can just integrate imported models directly into Microsoft Fabric OneLake!

OneLake integration for semantic models
https://learn.microsoft.com/power-bi/enterprise/onelake-integration-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/
— <a href="https://guyinacube.com" target="_blank" Continue reading “OneLake Integration for Power BI Semantic Models” →

Tracing your Power BI Report

Posted on by Annie D

Is your Power BI report taking too long? Are you curious about breaking down report rendering vs DAX query duration but don’t have Performance Analyzer from the service perspective? Adam shows you how you can trace your report in the service!

📢 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 “Tracing your Power BI Report” →

Introducing Prompt Array – a new prompt; creation, library & collaboration tool

Posted on by Annie D

***** Video Details *****
Discover how to streamline your AI prompt management with PromptArray. In this video, you’ll see how to store, organize, and reuse prompts across multiple AI tools—from ChatGPT and Claude to emerging development platforms. Learn how to quickly create prompt groups, access community templates, and even chain prompts together for more complex workflows. PromptArray helps ensure you get high-quality results by crafting detailed, reusable prompts and keeping them all in one place. It’s a straightforward way to elevate your AI-driven projects and save time on repetitive tasks.

***** Related Links *****
https://www.promptarray.ai/

***** Learning with Enterprise DNA ***** Continue reading “Introducing Prompt Array – a new prompt; creation, library & collaboration tool” →

MS 365 Excel Basics #5: IF Function & Logical Test. IFS, IFNA, OR, AND, NOT, ISNUMBER Functions More

Posted on by Annie D

Download Excel File: https://people.highline.edu/mgirvin/AllClasses/218M365/Content/ExcelBasics05.xlsx
Read (download right-click): pdf notes: https://people.highline.edu/mgirvin/AllClasses/218M365/Content/ExcelBasics05.pdf
In this video learn about logical tests which are the driver behind functions like IF, IFS, AND, OR, NOT, ISNUMBER and more. See 14 examples of logical tests and the IF function and more.
Topics:
1. (00:00) Introduction
2. (00:40) Topics in Video
3. (01:19) IF function and its arguments
4. (01:56) Logical tests in the Excel worksheet: Complete Story
5. (08:48) Logical formula using comparative operators, including a comparison to how comparative operators are used in functions like SUMIFS and COUNTIFS
6. (10:45) Logical formula using ISNUMBER function
7. (11:55) Logical formula using Continue reading “MS 365 Excel Basics #5: IF Function & Logical Test. IFS, IFNA, OR, AND, NOT, ISNUMBER Functions More” →

Rebinding your Power BI Report with Semantic Link Labs

Posted on by Annie D

Maybe you are moving from Dev to Production, or you migrated your Power BI Semantic Models to Direct Lake. Now you need to repoint the reports to the new model. Patrick shows you how with Semantic Link Labs.

Semantic Link Labs
https://github.com/microsoft/semantic-link-labs

Use the Power BI Rebind API to move from cached to Azure AS
https://youtu.be/wjOLp4E5K4Q

Switch a Power BI Report’s dataset without needing Premium!
https://youtu.be/X_1tBbPwBMg

📢 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 Continue reading “Rebinding your Power BI Report with Semantic Link Labs” →

🔴 Microsoft Power BI / Fabric Q&A – LIVE (Dec 14, 2024) (Member Chat 2nd Half)

Posted on by Annie D

Join us live as we answer your questions about Power BI & Microsoft Fabric! 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 Power BI / Fabric Q&A – LIVE (Dec 14, 2024) (Member Chat 2nd Half)” →

Excel – Unlock the Secrets of Excel’s New Compatibility Version! – Episode 2663

Posted on by Annie D

Microsoft Excel Tutorial: Unlock the Secrets of Excel’s New Compatibility Version!

Are you tired of mismatched results when sharing Excel files between coworkers using different versions? Microsoft has finally addressed this issue. Today we dive into the game-changing **Function Compatibility Version**.
This feature offers a solution to inconsistencies caused by updates to five key functions: **LEN, MID, SEARCH, FIND, and REPLACE**. While the updates might seem minor, the implications are massive, especially for teams juggling old and new versions of Excel.
Learn how the new **Compatibility Version** setting makes it easier to manage version disparities. Whether you’re stuck on Excel Continue reading “Excel – Unlock the Secrets of Excel’s New Compatibility Version! – Episode 2663” →

Migrate your Power BI Semantic Models to Direct Lake

Posted on by Annie D

Want to make your Import or DirectQuery Power BI Semantic models use Direct Lake? Patrick highlights a way to do the migration and take full advantage of Microsoft Fabric!

Direct Lake Migration
https://www.elegantbi.com/post/direct-lake-migration

Michael Kovalsky
https://www.linkedin.com/in/michaelkovalsky/
https://www.elegantbi.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
— http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— Continue reading “Migrate your Power BI Semantic Models to Direct Lake” →

Leverage Copy Job to copy in the latest file in Data Factory

Posted on by Annie D

Copy Job within Data Factory can allow you to easily get your data into Microsoft Fabric with an easy-to-use UI. Also allowing you to quickly set up incremental load. Patrick shows you how!

What is the Copy job (preview) in Data Factory for Microsoft Fabric
https://learn.microsoft.com/fabric/data-factory/what-is-copy-job

📢 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
— <a href="http://www.facebook.com/guyinacube" Continue reading “Leverage Copy Job to copy in the latest file in Data Factory” →

How to go from idea to starter app in a day

Posted on by Annie D

***** Video Details *****
In this video, I walk you through a new development workflow that leverages cutting-edge AI tools to rapidly build functional applications. Using an innovative API, I’ve started creating a dynamic AI voice and avatar application. Imagine interacting with AI agents seamlessly—click an avatar, start a conversation, switch agents, and explore limitless possibilities for learning, social engagement, or productivity.

I showcase my workflow, from using tools like Lovable.dev for rapid prototyping to integrating the code with platforms like Supabase, GitHub, and advanced IDEs like WindSurf. Whether you’re a beginner or experienced developer, you’ll see how AI-first tools are transforming Continue reading “How to go from idea to starter app in a day” →

Create your own AI podcast generator

Posted on by Annie D

***** Video Details *****
Discover how artificial intelligence is transforming the way we create and customize podcasts. In this episode, we explore the latest AI-powered tools and techniques that make podcast production easier and more accessible than ever. From leveraging platforms like Play.ai to integrating APIs for seamless podcast generation, learn how to harness the power of AI to streamline your podcasting process. Whether you’re a seasoned podcaster or just starting out, these insights will help you elevate your podcast creation journey. Tune in to unlock the secrets of AI-driven podcasting and take your audio content to the next level!

***** Related Continue reading “Create your own AI podcast generator” →