Shadowing Practice: The Simplest Way to Connect Claude and Power BI - Learn English Speaking with YouTube
C1
In this video, I'm going to talk about
162 sentences
If sentences are too short or too long, click Edit to adjust them.
1
In this video, I'm going to talk about
2
that how do you connect Claude with Power BI so that when you give prompts in Claude,
3
Power BI acts automatically.
4
It's going to be a fun one.
5
Let's start.
6
Now, to be able to connect Claude with Power BI Desktop,
7
we need three applications, two of which you've already guessed it.
8
Yes, we need Claude Desktop.
9
That's one.
10
We need Power BI Desktop and we also need Visual Studio Code.
11
When you download Cloud Desktop,
12
you can be on the free version.
13
There is no need for you to be on the paid version,
14
although the amount of work
15
that you can do on the free version in Cloud Desktop is going to be limited
16
and Power BI Desktop is anyways free.
17
I would request you at the start that you install these three applications to begin with,
18
Cloud Desktop, Power BI Desktop,
19
I'm sure you have that, and also VS Code.
20
The installation process of any of these three applications is just the standard process.
21
There is nothing technical about it,
22
so I'll leave that onto you and after that,
23
I'll teach you that how do you connect all of these three and have Claude talk to your Power BI desktop.
24
The very first application that we'll be working inside is VS Code
25
and that is where we will install the MCP
26
or model context protocol server for Power BI officially given to us by Microsoft.
27
Now, I'm going to go over to extensions right here and in extensions,
28
I will search for Power BI.
29
You can see that I have already installed that.
30
So, there was a check mark there.
31
You can see that I have already installed that.
32
That's from Microsoft and I have gotten that already.
33
In case you haven't, you can just click on that and install.
34
There is going to be an install button right here.
35
You can just click on install and have this extension installed in your VS Code.
36
The important thing to note is
37
that there is no way Claude can talk to an application in your PC like Power BI Desktop.
38
So the way that it connects to Power BI Desktop is via this MCP.
39
Although we don't need VS Code for any coding purposes,
40
we would just want to take that MCP
41
that we have installed the model context protocol that we have installed feed
42
that into Claude so that Claude can connect to Power BI Desktop
43
and start interacting
44
and you can do a bunch of work in there quick
45
introduction in case you're liking the video thus far you're absolutely
46
going to love my courses on power bi dax data modeling m language
47
and power query i have these structured courses where i start talking about concepts fundamental concepts right from scratch
48
and then i take the students to the next level by
49
talking about how to think how to construct the logic of the problem
50
and start solving harder problems on your own hundreds
51
and thousands of students have joined my courses and they have provided some raving feedback.
52
In case you're interested, the link of the courses is going to be down in the description.
53
I look forward to seeing you inside the course.
54
Let's get back to the video.
55
Let's just see that once you've installed this MCP or extension in your VS Code,
56
how do we then take this and connect to Cloud?
57
The next thing that I'm going to do is open up a Windows Explorer window
58
and then I am going to go over to users to take the path where my MCP is installed
59
and then connect it to Cloud Desktop.
60
So take a look.
61
So I am in my C drive wherever you have installed your Windows and we have users in there.
62
This is me, Chandip Chhabra.
63
And then I'm going to go over to VS Code.
64
I have installed some extensions.
65
So I'll go in the subfolder con extensions.
66
The Power BI MCP extension is installed in this particular folder,
67
Analysis Services, Power BI Modeling MCP.
68
I'll just double click on that within
69
which I will go on to the server folder and I will find the Power BI modeling MCP.
70
Now this technically is the place in your entire Windows directory where the MCP server is kept.
71
I would want to take this position or this particular file and then feed it into Claude.
72
How do you do that?
73
Now if you actually open this particular file,
74
it's going to most likely open in a terminal window
75
or like a shell in a PowerShell window and you see this particular code right here.
76
You can copy this code and this is the code
77
that we will stick inside of Claude so that Claude can talk to Power BI.
78
And you can take a look that the path
79
that is mentioned in here is the very path that I have navigated to.
80
So C, users, my name,
81
VS code extensions, blah, blah, blah.
82
And here is the Power BI modeling MCV.
83
It's encapsulated in a JSON.
84
So I can just copy all of that from here.
85
Control c on that and now i'm going to feed this inside of claude the next thing
86
that i do is i open up claude desktop after i have closed the powershell window
87
that opened for the executable file next up i'm just going to go over to the top
88
and i will click on file
89
and then click on the settings in the settings i will roll down over to developer
90
and you can see that since i have already connected and that's my Power BI server already connected right here.
91
Now, I don't really want to disturb my connection at the moment.
92
I will just tell you how can you do that.
93
So obviously, you would not see this being connected at the moment.
94
So you can click on a button and I'm going to click on edit at the moment.
95
So I'll click on edit and this is going to give me the place where I can make the change.
96
You can see that there is a cloud desktop config JSON right here.
97
I'm going to open up this JSON on this json file
98
needs to point to where your mcp is now this particular file
99
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
Download App
AI scoring for every sentence you speak
TRENDING
Popular
Context & Background
In the video "The Simplest Way to Connect Claude and Power BI," the speaker focuses on how to integrate Claude with Power BI, showcasing an efficient way for users to enhance their workflows. This tutorial serves as a practical guide for those interested in leveraging technology for data visualization and automation. The speaker’s engaging tone and structured approach make it easy for viewers to follow along, providing not only instructions but also insights into the tools required for the task. Using this video as a learning resource can significantly aid English learners, especially when practicing specific vocabulary and phrases related to technology.
Top 5 Phrases for Daily Communication
- “Let’s start.” – A common phrase to signal the beginning of an activity or discussion.
- “I would request you...” – A polite way to ask someone to do something.
- “The installation process is just standard.” – A simple way to describe an uncomplicated procedure.
- “Connect via…” – This phrase is important when discussing how to link two applications.
- “I’m sure you have that.” – A way to express confidence that the audience is familiar with something.
Step-by-step Shadowing Guide
Shadowing is a powerful technique to improve English pronunciation and fluency. Below is a step-by-step guide to effectively tackle this video using the shadow speech method:
- Watch Actively: Begin by watching the video without attempting to repeat. Focus on the speaker's pace and pronunciation.
- Phrase Breakdown: Pause the video after each key phrase or sentence. Repeat the phrase aloud, mimicking the intonation and rhythm of the speaker.
- Repetition is Key: Go over the top phrases multiple times. For example, say “Let’s start” in different contexts to solidify its usage in your mind.
- Incorporate Vocabulary: As you practice, incorporate other technical terms related to Power BI and Claude. This will expand your vocabulary beyond everyday phrases.
- Record Yourself: Use a recording device to capture your attempts. Listening to your own speech can help you spot areas for improvement and boost your confidence.
- Practice Regularly: Make it a routine to utilize this shadowing method with different videos. Explore other tutorials to learn English with YouTube and enhance your language skills alongside technical knowledge.
Utilizing the shadow speak technique can significantly enhance your English learning experience, allowing for both language acquisition and comprehension of technological concepts simultaneously.
What is the Shadowing Technique?
Shadowing is a science-backed language learning technique originally developed for professional interpreter training and popularized by polyglot Dr. Alexander Arguelles. The method is simple but powerful: you listen to native English audio and immediately repeat it out loud — like a shadow following the speaker with just a 1–2 second delay. Unlike passive listening or grammar drills, shadowing forces your brain and mouth muscles to simultaneously process and reproduce real speech patterns. Research shows it significantly improves pronunciation accuracy, intonation, rhythm, connected speech, listening comprehension, and speaking fluency — making it one of the most effective methods for IELTS Speaking preparation and real-world English communication.
☕ Buy us a coffee
ShadowingEnglish remains 100% free thanks to your support. Server and AI costs are high — your coffee keeps us going! 🙏