Agentic AI in Power BI and Fabric, Part 2: Getting Started with VS Code, GitHub Copilot, and Safe MCP Setup

Agentic AI in Power BI and Fabric, Part 2 Getting Started with VS Code, GitHub Copilot

A Personal Note Before We Continue

Before I continue this series, I want to briefly share why it took me so long to publish this second blog.

As many of you who follow me on LinkedIn already know, I lost my mum about six months ago, only nine months after I lost my dad. I was still trying to recover from those deeply painful losses when more devastating news arrived from Iran.

On 8 January 2026, reports started emerging of mass killings during the violent crackdown in Iran, and the situation continued for the following two days. Many people described those days with words that are hard even to repeat. Then the war involving Iran, Israel, and the United States escalated further, and it is still ongoing as I write this blog post.

I am trying not to stay in the dark, but I am human after all. Being surrounded by grief and bad news for such a long time takes a real toll, and dealing with it has simply been hard.

That said, I still wanted to continue this series. Partly because I believe the topic matters, and partly because getting back to writing feels like one small way to keep moving forward.

Quick Recap of Part 1

In the first blog of this series, I focused on the concepts and terminology behind Agentic AI in the context of Power BI and Microsoft Fabric. We looked at ideas such as agents, tools, skills, MCP, guardrails, memory, prompts, planning, and actions.

That first post was intentionally conceptual. I did not want to jump straight into tools and demos before building the right mental model. If the foundations are unclear, the setup work quickly turns into confusion.

This follow-up post is where we move from concepts into practice, starting with the environment setup.

What This Blog Will Cover

In this post, I want to keep the scope practical and narrow enough to remain useful. We will cover:

  • why VS Code is a good starting point for agentic workflows
  • how to get started with GitHub Copilot in VS Code
  • which VS Code extensions make sense for Power BI and Microsoft Fabric work as of today (Apr 2026)
  • why you should be careful with local MCP servers
  • why Windows Sandbox or a virtual machine can be a very good idea before you start experimenting
  • how to make sure GitHub Copilot, tools, and models are ready before you start a real workflow

There is already a lot in that list, so I will deliberately keep the hands-on Power BI modelling walkthrough for the next post.

f you like to listen to the content on the go, here is the AI generated podcast explaining everything about this blog 👇.

Why VS Code Is a Good Starting Point for Agentic AI

VS Code is a very practical place to begin with agentic AI workflows. It is lightweight, extensible, well documented, and increasingly well integrated with GitHub Copilot. More importantly, it gives us a working environment where prompts, files, plans, tools, MCP-based capabilities, and extensions can all come together in one place, which is very handy.

For Power BI and Microsoft Fabric work, that matters a lot. We are usually not just asking random questions. We are trying to work with semantic models, project files, metadata, documentation, notebooks, configuration, and sometimes real environments. Therefore, we need a setup that can easily provide different mechanisms to access to Microsoft Fabric and Power BI in structured workflows. VS Code gives us exactly that.

A clean VS Code window ready for setup
A clean VS Code window ready for setup


A clean VS Code window ready for setup

Download and Install VS Code

If you do not already have VS Code installed, you have two ways to download it:

I am not going to explain the installation steps in this blog because that is not the focus here. The important point is simply to get VS Code installed and ready.

If you already use VS Code, make sure it is up to date before going further.

VS Code download options

Official VS Code download options

Continue reading “Agentic AI in Power BI and Fabric, Part 2: Getting Started with VS Code, GitHub Copilot, and Safe MCP Setup”

Use Copilot in Power BI Desktop to Create Measures from Numeric Columns

I have been thinking about a mechanism to generate measures from numeric columns on Power BI data models. Of course, we can use Tabular Editor, but it requires some scripting, which is all right. However, the more advanced our requirements get, the more complex the C# script. In real-world development scenarios, it does not make sense to blindly create measures for all numeric columns, such as the key columns used to define relationships between tables, making C# scripting a bit more complex.

In this blog and accompanying YouTube video, I explain using Copilot within Power BI Desktop to create measures from numeric columns. This feature represents a significant advancement in Power BI’s capabilities as of April 2024, enabling data analysts and BI professionals to streamline parts of their data analysis tasks.

Prerequisites

As explained in a previous post here, we first need to enable Copilot on the Fabric Portal. Please note that Copilot in Power BI Desktop requires either Power BI Premium Capacity or AT LEAST an F64 Fabric Capacity. Unfortunately, Copilot is NOT available on PPUEmbedded capacities, Fabric capacities smaller than F64 and Fabric Trial (FT) capacities.

We also need to have the latest version of Power BI Desktop installed on our machine. With that, let’s begin.

YouTube Video

Here is the video on YouTube where I explain the same thing in less than 5 min. But if you are after more details, continue reading.

Introduction to Power BI and Copilot

As Power BI evolves, it incorporates more sophisticated AI-driven capabilities that simplify various aspects of data analytics. The integration of Copilot in Power BI Desktop enhances user interaction with data in many ways. Our focus on this blog is specifically using Copilot to create simple yet crucial measures based on numeric columns that previously required manual effort.

Use Copilot for Measure Creation

Using Copilot is straightforward and demonstrates impressive intelligence in its operational logic. The following steps explain how to do so:

Continue reading “Use Copilot in Power BI Desktop to Create Measures from Numeric Columns”

Microsoft Fabric: Use Copilot to Generate Data Model Synonyms

Microsoft Fabric: Use Copilot to Generate Data Model Synonyms

One of my older posts explains how to enable Copilot on Fabric and how to use Copilot to generate Power BI reports. In this post, I aim to explain yet another use case for Copilot that can help us to make a better and more useful semantic model in Power BI using synonyms. In an old post published in May 2016, I explained how to use Power BI synonyms to take our Power BI Q&A experience to another level. In that post, I explained how we could use synonyms to translate data model objects in different languages so the end-user could ask questions in their native language and get the results in Power BI. That was such a cool use case for synonyms, I suppose, wasn’t it? Fast track to December 2023, I believe the Q&A is still one of the coolest Power BI features that stands out when demoing the solutions to the customers; therefore, it makes absolute sense to use synonyms to improve the Q&A‘s efficiency and accuracy. This blog post explores the possibility of using Copilot to define synonyms in Power BI Desktop.

Prerequisites

As explained here, we first need to enable Copilot on Fabric Service. Please note that the technique explained in this post requires either Power BI Premium Capacity or at least F64 Fabric capacity and won’t work on PPU, Embedded capacities, Fabric capacities smaller than F64 or Fabric Trial (FT) capacities.

We also need to have the latest version of Power BI Desktop installed on our machine. With that, let’s begin.

Using Power BI Copilot to generate synonyms

While defining synonyms for the semantic model objects significantly helps with the Q&A experience, it is still a cumbersome process if done manually. So, if we meet the prerequisites, we can summon Copilot to the rescue. Follow these steps after opening a Power BI file in Power BI Desktop:

  1. Ensure you’re signed into Fabric service with your account
  2. Click the Insert tab
  3. Select the Q&A visual
  4. On the Q&A visual, click the Q&A Setup button shown with a gear icon
  5. On the Q&A Setup window, you must see a message offering to “Improve Q&A with synonyms from Copilot” on top of the window; click the Add synonyms button

The following image shows the preceding steps:

Improve Q&A with synonyms from Power BI Copilot in Microsoft Fabric
Improve Q&A with synonyms from Copilot
Continue reading “Microsoft Fabric: Use Copilot to Generate Data Model Synonyms”

Microsoft Fabric: Generating Reports with Copilot

Microsoft Fabric Generating Reports with Copilot on Fabric

In Nov 2023, Microsoft announced Microsoft Fabric’s general availability and Public Preview of Copilot in Microsoft Fabric. In a previous post, I explained what Copilot means to Power BI developers, which is valid for other Fabric developers such as data engineers and data scientists as Copilot for Fabric helps with those experiences as well. But the main focus of this blog post is to discuss the requirements, how to enable Copilot, and how to use it from a Power BI development point of view. So, this blog will not discuss other aspects of Copilot in Microsoft Fabric. With that, let’s begin.

Requirements

Right off the bat, Copilot is only available on Power BI Premium capacities or their equivalent Fabric capacities. So, NO it is NOT available on Power BI Pro or Premium Per User or Power BI Embedded Analytics. So the Power BI items you want to use Copilot on must be in a Workspace assigned to a Power BI Premium P1 or Microsoft Fabric F64 capacities or higher.

You also need to have a Contributor role on the premium workspace.

To use Copilot, your Microsoft Fabric Administrator must enable it from the Fabric Admin Portal. This setting is not available in all regions yet, but Microsoft is gradually rolling it out to more regions.

Useful links:

Enabling Copilot on Fabric Admin Portal

As mentioned before, your Fabric Administrator must enable Copilot features within the Admin Portal. Follow these steps to enable Copilot on your tenant after logging into Microsoft Fabric:

  1. Click Settings (the gear icon on the top right of the page)
  2. Click Admin portal
  3. Ensure that the Tenant setting tab is selected
  4. Scroll all the way down to the Copilot and Azure OpenAI Service (preview)​ section

Note

You can also use the search box and search for OpenAI to find the Copilot and Azure OpenAI Service (preview)​ section.

  1. Enable the Users can use a preview of Copilot and other features powered by Azure OpenAI
  2. Click the Apply button
  3. Enable the ​​​Data sent to Azure OpenAI can be processed outside your tenant’s geographic region, compliance boundary, or national cloud instance
  4. Click the Apply button again

That is it. You enabled the Copilot capabilities on your tenant.

The following image shows the preceding steps:

Enabling Copilot for Power BI in Fabric Service Admin Portal
Enabling Copilot in Fabric Admin Portal
Continue reading “Microsoft Fabric: Generating Reports with Copilot”