Press "Enter" to skip to content

Day: May 5, 2025

Debugging R Code in Visual Studio Code

Published 2025-05-05 by Kevin Feasel

Yohann Mansiaux steps through the code:

We are going to see how to use these functions in VSCode, as well as introducing “breakpoints”. Breakpoints are markers that you can set in your code to pause execution at a specific line. This allows you to inspect the state of your code at that point and step through it line by line. They are very close to the browser() function. They can also be used in RStudio IDE, but I have to admit that I never used them.

Read on to see how VSCode fills the need when it comes to debugging code. H/T R-Bloggers.

Leave a Comment

Building a Multi-Agent Orchestrator with Flink and Kafka

Published 2025-05-05 by Kevin Feasel

Sean Falconer builds an orchestration engine:

Just as some problems are too big for one person to solve, some tasks are too complex for a single artificial intelligence (AI) agent to handle. Instead, the best approach is to decompose problems into smaller, specialized units so that multiple agents can work together as a team.

This is the foundation of a multi-agent system—networks of agents, each with a specific role, collaborating to solve larger problems.

Read on for the overview. There’s also a code repository and a free e-book on the topic.

Leave a Comment

Digging into Non-Idempotent Subqueries via CTE in PostgreSQL

Published 2025-05-05 by Kevin Feasel

Shayon Mukherjee continues pulling on a thread:

A few days ago, I wrote about a surprising planner behavior with CTEs, DELETE, and LIMIT in PostgreSQL, a piece I hastily put together on a bus ride. That post clearly only scratched the surface of a deeper issue that I’ve since spent way too many hours exploring. So here are some more formed thoughts and findings.

Click through for a deeper dive into the topic, including some key takeaways.

Leave a Comment

Authenticate to Fabric Data Connections via Key Vault Secrets

Published 2025-05-05 by Kevin Feasel

Aditya Jain announces a preview:

Azure Key Vault support in Fabric Data connections is now in preview! With this capability, we are introducing a new concept called ‘Azure Key Vault references’ in Microsoft Fabric, using which, users can reuse their existing Azure key vault secrets for authentication to data source connections instead of copy-pasting passwords, slashing credential-management effort and audit risk.

Click through to see what works so far and the current limitations.

Leave a Comment

Adding Carousel Buttons in Power BI

Published 2025-05-05 by Kevin Feasel

Boniface Muchendu builds a carousel:

Power BI carousel buttons allow users to cycle through visuals, measures, or text within a single report space—making your dashboards more interactive and space-efficient. While Power BI doesn’t include a native carousel visual, this guide shows how to simulate the same functionality using button slicers and field parameters. We’ll walk through several practical use cases, including switching between KPIs, toggling dimensions, and displaying text content, all with built-in Power BI features.

Click through to see how they work. I’m not a big fan of doing this on a proper dashboard, given that any visuals you’ve hidden on the carousel are no longer glanceable, but it’s a neat aesthetic idea for highly interactive reports.

Leave a Comment

Model Documentation via Fabric Data Agent

Published 2025-05-05 by Kevin Feasel

Chris Webb gets some answers:

AI is meant to help us automate boring tasks, and what could be more boring than creating documentation for your Power BI semantic models? It’s such a tedious task that most people don’t bother; there’s also an ecosystem of third party tools that do this job for you, and you can also build your own solution for this using DAX DMVs or the new-ish INFO functions (see here for a good example). That got me wondering: can you use Fabric Data Agents to generate documentation for you? And what’s more, why even generate documentation when you can just ask a Data Agent the questions that you’d need to generate documentation to answer?

For a simple scenario, Chris was able to get pretty solid results. As complexity grows, your mileage may vary.

Leave a Comment

Resulting Data Types from a UNION Operation

Published 2025-05-05 by Kevin Feasel

Andy Brownsword puts on the lab coat and performs some experiments:

The UNION and UNION ALL operators allow us to combine results, but there’s no guarantee that each set of results uses the same data types. So what data types are returned?

For the longest time I thought the data types from the first set of results were used for the final results. That’s not the case.

Read on to see what the rules look like.

Leave a Comment