There are so many new and more productive ways you can use Power BI now by augmenting all your work with AI. Listen in for many insights into how to develop quality Power BI reports from 2024 onwards. HINT – using AI to help at all steps boosts your productivity an incredible amount. Embrace it!
Category: Power BI

Which Microsoft Fabric SQL Analytics Endpoint should you use?
Both the Microsoft Fabric lakehouse and warehouse have a SQL Analytics Endpoint. But they have different limitations. Which one is the right one to use? Patrick breaks it down!
Better together: the lakehouse and warehouse
https://learn.microsoft.com/fabric/data-warehouse/get-started-lakehouse-sql-analytics-endpoint
📢 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 “Which Microsoft Fabric SQL Analytics Endpoint should you use?”

Dive into Power BI and Microsoft Fabric – IN PERSON – two events!
We are presenting a full day introduction to Microsoft Fabric at two different events in September! This is also important for Power BI folks to understand what all is available to them. Join us to get up to speed quickly!
Data Saturday Dallas (Dallas-Fort Worth, Texas:
Friday, September 6, 2024
Data Saturday Registration:
https://www.eventbrite.com/e/data-saturday-dallas-tickets-905734084027
Data Saturday Pre-Con Sign up:
https://www.eventbrite.com/e/harnessing-the-power-of-microsoft-fabric-tickets-931743197987
SQLKonferenz (Hanau, Germany):
Monday, September 30, 2024
https://sqlkonferenz.de/precon-workshops-2024/
https://sqlkonferenz.de/registration/
📢 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 Continue reading “Dive into Power BI and Microsoft Fabric – IN PERSON – two events!”

REPLAY Let’s talk Microsoft Fabric – LIVE w/ Matthew Roche (July 27, 2024)
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 “REPLAY Let’s talk Microsoft Fabric – LIVE w/ Matthew Roche (July 27, 2024)”

Happy little accidents with the Power BI Card Visual
Ready to take the Power BI card visual to the next level? Adam tinkers to get it to look just right. It’s a lot of customization but the outcome is way better than the starting point.
Create a (new) card visualization in Power BI Desktop (preview)
https://learn.microsoft.com/power-bi/visuals/power-bi-visualization-new-card?tabs=On-the-ribbon
📢 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 Continue reading “Happy little accidents with the Power BI Card Visual”

Creative way to use Sempy to update a Power BI report definition
Need to do a bulk change of something in your Power BI report? The new Power BI report format enables some slick automations. Patrick uses Sempy to get this done!
What is semantic link?
https://learn.microsoft.com/fabric/data-science/semantic-link-overview
Items – Get Item Definition
https://learn.microsoft.com/rest/api/fabric/core/items/get-item-definition?tabs=HTTP
Items – Update Item Definition
https://learn.microsoft.com/rest/api/fabric/core/items/update-item-definition?tabs=HTTP
📢 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 #report #GuyInACube

Claude vs ChatGPT – which is best, in which situations?
In this video, I dive into a comparison of two powerful AI tools, Claude and ChatGPT, and highlight the strengths each brings to the table. While ChatGPT excels in quickly generating text and handling general AI tasks, Claude shines when it comes to coding and offers a user interface that makes tasks like code visualization and web app creation much easier.
I also explore how Claude’s superior coding capabilities make it an ideal tool for developers, particularly with its smooth integration with GitHub for seamless code editing and deployment. For those who need to generate text or boilerplate code quickly, ChatGPT Continue reading “Claude vs ChatGPT – which is best, in which situations?”

How to use Replit for build simple web apps
In this video, I introduce Replit, an online IDE that has made web app development much simpler, especially for people like me who are still learning to code. I’ll show you how Replit integrates with GitHub and offers AI assistance, making the entire coding process more accessible, even if you’re not a coding expert.
During the video, I demonstrate how I built a speech-to-speech AI assistant using open-source templates. One of the key takeaways is the importance of understanding the code logic behind these apps, which has been a big focus for me as I continue learning. Replit is such a Continue reading “How to use Replit for build simple web apps”

How to build your own CSV data generator without coding
In this video, I take you through my journey of building a data generator app using AI tools like Replit and Claude. My goal is to show how easy and accessible app development has become, even for those of us who aren’t coders. I’ll walk you through how I set up this app to generate business scenarios and data sets, which can be a real game-changer for professionals who need custom data quickly and efficiently.
Throughout the video, I share what I’ve learned from using platforms like GitHub and how they’ve played a crucial role in my app development process. You’ll Continue reading “How to build your own CSV data generator without coding”

Are we entering a new era of app development? YES!
In this video, we explore the rapid evolution of app development tools and the game-changing impact of AI-powered solutions like GPT Engineer. You’ll learn how GPT Engineer can quickly generate detailed front-end mockups using natural language, significantly reducing the cost and time of app development. The video highlights the integration of AI tools with platforms like GitHub, enabling seamless workflows and emphasizing how combining various AI technologies can revolutionize productivity, learning, and documentation.
Throughout the video, the speaker shares personal experiences of creating app mockups on an iPad, showcasing how these technologies are democratizing software development and making it accessible to Continue reading “Are we entering a new era of app development? YES!”

Expert Guide: GitHub Integration for Microsoft Fabric
We talked about Git integration with Azure DevOps in the past, but now you can integrate GitHub with Microsoft Fabric! Once things are configured most things are the same because it’s just Git! Adam walks you through it!
Introduction to Git integration (preview)
https://learn.microsoft.com/fabric/cicd/git-integration/intro-to-git-integration?tabs=github
Basic concepts in Git integration
https://learn.microsoft.com/fabric/cicd/git-integration/git-integration-process?tabs=GitHub%2Cazure-devops
📢 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 “Expert Guide: GitHub Integration for Microsoft Fabric”

Unleashing Data for OneLake with Mirroring in Microsoft Fabric
Learn how to replicate your database to Microsoft Fabric using Mirroring! Patrick walks you through how you can do this with Azure SQL Database and CosmosDB and join across the two.
What is Mirroring in Fabric?
https://learn.microsoft.com/fabric/database/mirrored-database/overview
Mirroring Azure SQL Database (Preview)
https://learn.microsoft.com/fabric/database/mirrored-database/azure-sql-database
Mirroring Azure Cosmos DB (Preview)
https://learn.microsoft.com/fabric/database/mirrored-database/azure-cosmos-db
📢 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 “Unleashing Data for OneLake with Mirroring in Microsoft Fabric”