Category: Power BI

How I Fixed 1000+ Power BI Comments in ONE Day!

Posted on by Annie D

Join Patrick as he shares how he tackled some Power BI questions! These honestly answer thousands of questions we get every day. Following best practices solves so many head-aches!

Demo files:
https://github.com/guyinacube/demo-files/blob/master/video%20demos/PBIX/2025/20250226%20-%20Star%20Schema.zip

📢 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 Continue reading “How I Fixed 1000+ Power BI Comments in ONE Day!” →

We’re Going to Try to Automate VBA Coding With AutoVBA!

Posted on by Annie D

***** Video Details *****
In this episode, we explore the power of AI-driven application development and how it’s unlocking new automation possibilities. Learn about AutoVBA, a VBA automation app designed to generate and manage complex code effortlessly, reducing manual work. From AI-enhanced user experiences to solving complex logic dependencies, these projects showcase the incredible potential of AI-first development. As AI continues to evolve, so do the opportunities to build smarter, faster, and more intuitive applications. Tune in to see what’s possible!

***** Related Links *****
https://lovable.dev/
https://supabase.com/

***** Learning with Enterprise DNA *****
FREE Courses – <a href="https://bit.ly/45fu3tw" Continue reading “We’re Going to Try to Automate VBA Coding With AutoVBA!” →

Extracting Your BIM File and Using AI Extensively for Assistance

Posted on by Annie D

***** Video Details *****
Did you know you can extract metadata from Power BI reports and use AI to enhance your data models? In this episode, we walk you through how to convert a PBIX file into a project file, revealing key metadata, DAX formulas, and Power Query details. Using AI tools like ChatGPT and DeepSeek, we explore ways to optimize data models, generate new DAX measures, and automate analytical insights. Whether you’re working with SQL, M code, or Power BI reports, AI can transform the way you analyze and improve data. Don’t miss this game-changing workflow that bridges Power BI, Continue reading “Extracting Your BIM File and Using AI Extensively for Assistance” →

GitHub Workflow for Echo Assist

Posted on by Annie D

***** Video Details *****
This episode explores the GitHub workflow for Echo Assist, a voice-typing productivity app, and how AI-powered tools like Windsurf & GitHub make software development more efficient. Learn how to clone repositories, set up a local environment, and enhance UI/UX with AI assistance, even with minimal coding experience. We showcase automated UI improvements, API integrations, and seamless GitHub commits, demonstrating how AI reduces development time from hours to minutes. With AI streamlining the process, coding has never been more accessible.

***** Related Links *****
https://copycoder.ai/
https://codeium.com/windsurf
https://github.com/

***** Learning with Enterprise DNA ***** Continue reading “GitHub Workflow for Echo Assist” →

How to Setup a New Application Ultra Fast Using Cursor + Copycoder

Posted on by Annie D

***** Video Details *****
AI is changing the game for developers! In this episode, we explore Copycoder & Cursor, two cutting-edge AI tools revolutionizing software development. Watch as we take a screenshot of a design and turn it into a fully structured app—automatically. From frontend layouts to backend setup with Supabase, AI is making full-stack development faster, easier, and more accessible than ever. We also dive into authentication automation, project structuring, and the rise of AI-powered development ecosystems. What used to take hours can now be done in minutes—so is this the future of coding? Tune in to see AI in Continue reading “How to Setup a New Application Ultra Fast Using Cursor + Copycoder” →

Multiple Fact Tables in Power BI Made Simple and FAST!

Posted on by Annie D

We got a question about circular dependencies based on a previous video Patrick did. So, how do you handle that with multiple fact tables in Power BI? Patrick breaks it down!

Understanding circular dependencies in DAX
https://www.sqlbi.com/articles/understanding-circular-dependencies/

Avoiding circular dependency errors in DAX
https://www.sqlbi.com/articles/avoiding-circular-dependency-errors-in-dax/

Sample files:
https://github.com/guyinacube/demo-files/blob/master/video%20demos/PBIX/2025/20250220%20-%20Multiple%20Facts.zip

📢 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" target="_blank" Continue reading “Multiple Fact Tables in Power BI Made Simple and FAST!” →

How To Become A Full Stack AI Professional AI Builders

Posted on by Annie D

***** Video Details *****
Building apps? Automating workflows? Creating intelligent systems? Years ago, these have felt out of reach. Fast forward to today—you can do it all. With AI, things that once took teams of engineers and thousands of dollars can be done in minutes with AI-powered development. This is the full-stack AI revolution, and it’s just beginning. The opportunity is massive. AI is not replacing jobs—it’s creating new ones for those who are willing to learn.

***** Related Links *****

***** Learning with Enterprise DNA *****
FREE Courses – https://bit.ly/45fu3tw
FREE Resources – https://bit.ly/455Hw6O
EDNA Learn – <a Continue reading “How To Become A Full Stack AI Professional AI Builders” →

How to Make Your PowerPoint Presentations 10X More Powerful?

Posted on by Annie D

Want to make your PowerPoint presentations 10X more powerful??? Patrick goes through new capabilities with embedding a Power BI report to make your slides interactive and more engaging!

Add live Power BI data to PowerPoint
https://learn.microsoft.com/power-bi/collaborate-share/service-power-bi-powerpoint-add-in-install

📢 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 “How to Make Your PowerPoint Presentations 10X More Powerful?” →

Your Connections are a MESS! Let’s clean it up…

Posted on by Annie D

Have you ever looked at the Connections area in Microsoft Fabric? Even all the Power BI folks should look at this! It can get out of control. Patrick shows how he approaches the chaos of connections.

Data source management
https://learn.microsoft.com/fabric/data-factory/data-source-management

📢 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 “Your Connections are a MESS! Let’s clean it up…” →

Exploring AI in Application Development

Posted on by Annie D

***** Video Details *****
Discover how AI is revolutionizing application development, enabling you to build apps 10x faster and at a fraction of the cost. This video explores AI-powered tools, automation strategies, and best practices to streamline your development process and maximize efficiency. Whether you’re a beginner or an experienced developer, you’ll gain insights into leveraging AI for smarter, more cost-effective app creation.

***** Related Links *****
https://lovable.dev/

***** Learning with Enterprise DNA *****
FREE Courses – https://bit.ly/45fu3tw
FREE Resources – https://bit.ly/455Hw6O
EDNA Learn – https://app.enterprisedna.co/app
Data Mentor – https://mentor.enterprisedna.co/
EDNA Chat – Continue reading “Exploring AI in Application Development” →

Upgrade to a free Microsoft Fabric Trial? I already have capacity!

Posted on by Annie D

I wanted to start using some of the new Preview features in Microsoft Fabric when I got a message saying I needed to “Upgrade to a free Microsoft Fabric Trial”. Huh??? I already have the workspace in a Capacity! Adam explains what might be happening.

Create a SQL database in the Fabric portal
https://learn.microsoft.com/fabric/database/sql/create

Create an AI skill (preview)
https://learn.microsoft.com/fabric/data-science/how-to-create-ai-skill

📢 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: <a href="https://guyinacu.be/courses" target="_blank" Continue reading “Upgrade to a free Microsoft Fabric Trial? I already have capacity!” →

Mirror or Shortcut with Azure Databricks in Microsoft Fabric? YES!!!

Posted on by Annie D

Using Azure Databricks? Confused if you should just use a shortcut or mirror it? Perhaps the answer is YES! Patrick shows you the benefits of using the mirroring capability with Azure Databricks.

Mirroring Azure Databricks Unity Catalog (Preview)
https://learn.microsoft.com/fabric/database/mirrored-database/azure-databricks

Tutorial: Configure Microsoft Fabric mirrored databases from Azure Databricks (Preview)
https://learn.microsoft.com/fabric/database/mirrored-database/azure-databricks-tutorial

📢 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 “Mirror or Shortcut with Azure Databricks in Microsoft Fabric? YES!!!” →