शैडोइंग अभ्यास: The Simplest Way to Connect Claude and Power BI - वीडियो के साथ अंग्रेजी बोलना सीखें

In this video, I'm going to talk about

that how do you connect Claude with Power BI so that when you give prompts in Claude,

Power BI acts automatically.

It's going to be a fun one.

Let's start.

Now, to be able to connect Claude with Power BI Desktop,

we need three applications, two of which you've already guessed it.

Yes, we need Claude Desktop.

That's one.

We need Power BI Desktop and we also need Visual Studio Code.

When you download Cloud Desktop,

you can be on the free version.

There is no need for you to be on the paid version,

although the amount of work

that you can do on the free version in Cloud Desktop is going to be limited

and Power BI Desktop is anyways free.

I would request you at the start that you install these three applications to begin with,

Cloud Desktop, Power BI Desktop,

I'm sure you have that, and also VS Code.

The installation process of any of these three applications is just the standard process.

There is nothing technical about it,

so I'll leave that onto you and after that,

I'll teach you that how do you connect all of these three and have Claude talk to your Power BI desktop.

The very first application that we'll be working inside is VS Code

and that is where we will install the MCP

or model context protocol server for Power BI officially given to us by Microsoft.

Now, I'm going to go over to extensions right here and in extensions,

I will search for Power BI.

You can see that I have already installed that.

So, there was a check mark there.

You can see that I have already installed that.

That's from Microsoft and I have gotten that already.

In case you haven't, you can just click on that and install.

There is going to be an install button right here.

You can just click on install and have this extension installed in your VS Code.

The important thing to note is

that there is no way Claude can talk to an application in your PC like Power BI Desktop.

So the way that it connects to Power BI Desktop is via this MCP.

Although we don't need VS Code for any coding purposes,

we would just want to take that MCP

that we have installed the model context protocol that we have installed feed

that into Claude so that Claude can connect to Power BI Desktop

and start interacting

and you can do a bunch of work in there quick

introduction in case you're liking the video thus far you're absolutely

going to love my courses on power bi dax data modeling m language

and power query i have these structured courses where i start talking about concepts fundamental concepts right from scratch

and then i take the students to the next level by

talking about how to think how to construct the logic of the problem

and start solving harder problems on your own hundreds

and thousands of students have joined my courses and they have provided some raving feedback.

In case you're interested, the link of the courses is going to be down in the description.

I look forward to seeing you inside the course.

Let's get back to the video.

Let's just see that once you've installed this MCP or extension in your VS Code,

how do we then take this and connect to Cloud?

The next thing that I'm going to do is open up a Windows Explorer window

and then I am going to go over to users to take the path where my MCP is installed

and then connect it to Cloud Desktop.

So take a look.

So I am in my C drive wherever you have installed your Windows and we have users in there.

This is me, Chandip Chhabra.

And then I'm going to go over to VS Code.

I have installed some extensions.

So I'll go in the subfolder con extensions.

The Power BI MCP extension is installed in this particular folder,

Analysis Services, Power BI Modeling MCP.

I'll just double click on that within

which I will go on to the server folder and I will find the Power BI modeling MCP.

Now this technically is the place in your entire Windows directory where the MCP server is kept.

I would want to take this position or this particular file and then feed it into Claude.

How do you do that?

Now if you actually open this particular file,

it's going to most likely open in a terminal window

or like a shell in a PowerShell window and you see this particular code right here.

You can copy this code and this is the code

that we will stick inside of Claude so that Claude can talk to Power BI.

And you can take a look that the path

that is mentioned in here is the very path that I have navigated to.

So C, users, my name,

VS code extensions, blah, blah, blah.

And here is the Power BI modeling MCV.

It's encapsulated in a JSON.

So I can just copy all of that from here.

Control c on that and now i'm going to feed this inside of claude the next thing

that i do is i open up claude desktop after i have closed the powershell window

that opened for the executable file next up i'm just going to go over to the top

and i will click on file

and then click on the settings in the settings i will roll down over to developer

and you can see that since i have already connected and that's my Power BI server already connected right here.

Now, I don't really want to disturb my connection at the moment.

I will just tell you how can you do that.

So obviously, you would not see this being connected at the moment.

So you can click on a button and I'm going to click on edit at the moment.

So I'll click on edit and this is going to give me the place where I can make the change.

You can see that there is a cloud desktop config JSON right here.

I'm going to open up this JSON on this json file

needs to point to where your mcp is now this particular file

which is json file you can open up in a text editor in a notepad plus plus

100

or in vs code

101

that we have just installed it doesn't matter we just want to modify this

102

if i double click on the file it opens up in my vs code something like this

103

and you can take a look that i have already copy pasted

104

that code that i copied it from the mcp there are a bunch of other things as well

105

which has helped me to connect in case the code

106

that MCP shows is not working somehow in case you would want to take a look at my code instead,

107

I can just paste this code somewhere down below the video and you can just paste this code instead.

108

Note that what is important is that the command line should point to the directory where your MCP is.

109

One more thing to note that you can see

110

that we have double slashes in here rather than actually having a single slash.

111

So make sure that you change your file directory to have double slashes everywhere

112

and rest everything is going to be all right.

113

Now once you've done this particular change and you've deleted the original code

114

that was kept here and replaced it with the code that we copied.

115

Save it, close it and you are done.

116

At this stage, you might have to restart your PC once again for that change to take effect.

117

But for now, I have two windows open side by side.

118

I have a sales model that is open,

119

which is where I have got a couple of tables listed right here.

120

They are connected.

121

And on the other side,

122

I have Claude Desktop open.

123

Now, I'm going to start prompting Claude Desktop.

124

One thing you should keep in mind is

125

that the way to check it

126

if Power BI is connected to Claude is by again going over to the three dots right here,

127

file and then settings, and then making sure that in the developer,

128

you have the Power BI MCP connected, something like this.

129

Once I've ensured that the connection is working,

130

then I can go and talk to Claude to just do some operations on my Power BI report.

131

Let's just try to get how many tables are loaded in the current model.

132

Let's just see what happens.

133

Cool.

134

After a bit of soul searching,

135

Claude has returned me the answer that there are six tables loaded.

136

We have sales table and you can see that here,

137

the calendar table, which is right here,

138

the products refunds, an empty measures table and the product names table,

139

which is right here.

140

Let's try one more prompt with Claude.

141

Let's just see if it can actually create my total sales calculation,

142

which is technically going to be the units from the sales table multiplied with the price in the products table.

143

Let's just see if it can figure that out on its own or not.

144

All right, that is done as well.

145

You can see that Claude has written the measure.

146

Go in every single row of the sales table,

147

take the units, multiply that with the VLOOKUP of the price.

148

And this particular measure, which is total sales measure,

149

has been added in our model automatically.

150

Let's just go.

151

And if I drag this measure to our visual,

152

as it gives me the correct results,

153

sure enough, it actually does give me the correct results.

154

Now, all of this seems very rosy and very attractive

155

and then you might just get a high that Claude can do literally everything in my Power BI report.

156

But the answer might quite be very different.

157

In the next video, I've explored

158

that how realistic is to develop a full-fledged enterprise-grade report with Power BI and using Claude prompts.

159

I'll highly recommend that you watch that video to get some reality check of what Claude can and cannot do.

160

I'll see you in that video.

161

Cheers.

162

click click click click click click

शैडोइंग तकनीक क्या है?

शैडोइंग (Shadowing) एक विज्ञान-समर्थित भाषा सीखने की तकनीक है जो मूल रूप से पेशेवर दुभाषिया प्रशिक्षण के लिए विकसित की गई थी। विधि सरल लेकिन शक्तिशाली है: आप मूल अंग्रेज़ी ऑडियो सुनते हैं और तुरंत इसे ज़ोर से दोहराते हैं — जैसे वक्ता की छाया 1-2 सेकंड की देरी से। शोध से पता चलता है कि यह उच्चारण सटीकता, स्वर, लय, जुड़ी हुई ध्वनियाँ, सुनने की समझ और बोलने की प्रवाहशीलता में काफ़ी सुधार करता है।

शैडोइंग अभ्यास: The Simplest Way to Connect Claude and Power BI - वीडियो के साथ अंग्रेजी बोलना सीखें

इस पाठ के बारे में

मुख्य शब्दावली और वाक्यांश

अभ्यास सुझाव

शैडोइंग तकनीक क्या है?