Category: Power BI

The Surprising Enhancements for DAX Query View in Power BI

Posted on by Annie D

The DAX Query View for Power BI got some nice updates and a special item for those on a Mac! Zoe Douglas walks us through what we can do!

Zoe Douglas
https://www.linkedin.com/in/zoedouglas-data/
https://x.com/datazoepowerbi

📢 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 Continue reading “The Surprising Enhancements for DAX Query View in Power BI” →

Some GOTCHAs when using Mirroring in Microsoft Fabric

Posted on by Annie D

Mirroring in Microsoft Fabric can be very powerful but setting them up can sometimes have some frustrations. Patrick walks you through the challenges he hit and how he got around it.

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 “Some GOTCHAs when using Mirroring in Microsoft Fabric” →

Design Engaging Power BI Report Page Tooltips Effortlessly

Posted on by Annie D

We’ve talked about Tooltips before, but this time Adam walks you through how to recreate his Report Page Tooltip in Power BI Desktop. Learn how you can make things a bit more exciting and engaging!

Create tooltips based on report pages
https://learn.microsoft.com/power-bi/create-reports/desktop-tooltips?tabs=powerbi-desktop

📢 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
— <a href="https://www.instagram.com/guyinacube/" Continue reading “Design Engaging Power BI Report Page Tooltips Effortlessly” →

Accelerating your skills acquisition using AI

Posted on by Annie D

In this video, I share my insights on leveraging AI to rapidly acquire new skills, emphasizing the unprecedented learning opportunities available. I discuss the transformative power of AI in learning, the efficiency of short bursts of learning followed by project implementation, and the personalized learning experience AI offers. I recommend integrating AI into skill acquisition processes and highlight the compounding effect it has on productivity and skill development.

Selenium in Python – What’s possible?

Posted on by Annie D

In this video, I dive into the powerful web automation capabilities of the Selenium library in Python, sharing how it can be integrated with AI tools to efficiently automate tasks. I talk about my personal experiences using Selenium to automate web interactions, such as data input, navigation, and even data acquisition, making it a great tool for anyone looking to streamline repetitive tasks.

You’ll see how Selenium can be used to automate workflows without needing to write a lot of Python code. I demonstrate how it grabs data from spreadsheets, loops through items in a CSV file, and inputs that data Continue reading “Selenium in Python – What’s possible?” →

Mock up new web apps and automations fast – here’s how to do it.

Posted on by Annie D

In this video, I walk through how easy it is to create web apps using GitHub and AI tools, focusing on how these technologies have democratized app development, even for beginners like myself. I highlight how platforms like Replit and Streamlit, along with open-source projects, can supercharge the web app development process, making it faster and more accessible.

You’ll see how I quickly set up repositories on GitHub, find code templates or cookbooks, and fork them to start building my own web apps. I also explore the power of the Grock API and Replit as tools for rapid development, where I Continue reading “Mock up new web apps and automations fast – here’s how to do it.” →

Understanding Gateway Clusters in Microsoft Fabric

Posted on by Annie D

Concerned about high availability of your On-Premises Data Gateway within Microsoft Fabric? Gateway clusters are a way of ensuring you can process data for sources going through a gateway.

What is an on-premises data gateway?
https://learn.microsoft.com/data-integration/gateway/service-gateway-onprem

On-premises data gateway architecture
https://learn.microsoft.com/data-integration/gateway/service-gateway-onprem-indepth

Manage on-premises data gateway high-availability clusters and load balancing
https://learn.microsoft.com/data-integration/gateway/service-gateway-high-availability-clusters

Plan, scale, and maintain a business-critical gateway solution
https://learn.microsoft.com/en-us/data-integration/gateway/plan-scale-maintain

📢 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" Continue reading “Understanding Gateway Clusters in Microsoft Fabric” →

A look at the Microsoft Fabric Admin Portal

Posted on by Annie D

New to Microsoft Fabric Administration? Here is a look at the Admin Portal and how you can manage Microsoft Fabric along with what roles you need to be in.

What is the admin portal?
https://learn.microsoft.com/fabric/admin/admin-center

Understand Microsoft Fabric admin roles
https://learn.microsoft.com/fabric/admin/roles

Microsoft Fabric documentation for admins
https://learn.microsoft.com/fabric/admin/

Microsoft Fabric security
https://learn.microsoft.com/fabric/security/

📢 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
— <a href="http://twitter.com/awsaxton" Continue reading “A look at the Microsoft Fabric Admin Portal” →

Get started with the On-Premises Data Gateway in Microsoft Fabric

Posted on by Annie D

Trying to leverage on-premises data? Can’t connect to a cloud source because of firewalls or private networks? Learn how you can use the On-Premises Data Gateway with Microsoft Fabric to get the data you need!

What is an on-premises data gateway?
https://learn.microsoft.com/data-integration/gateway/service-gateway-onprem

On-premises data gateway architecture
https://learn.microsoft.com/data-integration/gateway/service-gateway-onprem-indepth

Install an on-premises data gateway
https://learn.microsoft.com/data-integration/gateway/service-gateway-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
— <a Continue reading “Get started with the On-Premises Data Gateway in Microsoft Fabric” →

Get a custom endpoint without creating an EventHub for EventStreams

Posted on by Annie D

No need to create a custom event hub when leveraging eventstreams in Microsoft Fabric. Just create a custom endpoint instead! Patrick shows you how.

Add custom endpoint source to an eventstream
https://learn.microsoft.com/fabric/real-time-intelligence/event-streams/add-source-custom-app?pivots=enhanced-capabilities

📢 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 “Get a custom endpoint without creating an EventHub for EventStreams” →

Update Data Sources within Deployment Pipelines

Posted on by Annie D

Making use of a Deployment Pipeline within Microsoft Fabric? Not sure how to update data sources for your Power BI semantic model as you move through stages? Adam has you covered!

Get started with deployment pipelines
https://learn.microsoft.com/fabric/cicd/deployment-pipelines/get-started-with-deployment-pipelines?tabs=from-fabric

Create deployment rules
https://learn.microsoft.com/fabric/cicd/deployment-pipelines/create-rules

📢 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
— <a href="https://www.instagram.com/guyinacube/" Continue reading “Update Data Sources within Deployment Pipelines” →