跟读练习: The Simplest Way to Connect Claude and Power BI - 通过YouTube学习英语口语
C1
In this video, I'm going to talk about
162 句
如果句子过短或过长，请点击 Edit 进行调整。
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
下载应用
AI 为你说出的每个句子打分
TRENDING
热门
背景与背景
在这段视频中，讲者分享了如何将Claude与Power BI连接，以便在Claude中输入提示时，Power BI能够自动响应。这一过程结合了三种应用程序：Claude Desktop、Power BI Desktop和Visual Studio Code。对于希望提升英语技能、特别是在技术场景中应用英语的学习者来说，了解这些工具的使用与连接方法十分重要。尤其是，视频中介绍的各种专业术语和操作步骤，对学生的专业英语能力提升有极大的帮助。
日常交流的五个短语
- Let's start.（我们开始吧。）——常用于开启对话或讨论。
- I'm going to talk about...（我将谈论……）——用于引入即将讨论的主题。
- It's going to be a fun one.（这会很有趣。）——表达对某个活动或讨论的期待。
- We need to connect...（我们需要连接……）——用于说明需要建立的关系或连接。
- There is no way...（没有办法……）——强调某件事情的不可行性。
逐步跟读指南
要有效提升你的口语能力，建议使用shadow speak的方法跟读视频内容。通过这种方式，学习者能够更好地理解发音、语调，以及如何在特定场景中使用专业术语。以下是跟读的步骤：
- 首先，观看视频并独立记下重要信息和术语，尤其是与Power BI和Claude相关的内容。
- 随后，反复播放视频的关键部分，跟随讲者的语速进行跟读。你可以使用shadowspeaks技术，模仿讲者的口音和语调。
- 在每次跟读后，暂停视频，自己重复讲者所说的话，确保发音准确。
- 尝试在不同场景中使用视频中的短语，例如与朋友讨论技术问题或工作中的数据分析。
- 最后，定期回顾和总结所学的内容，评估自己的进步，并寻找新的短语和表达方式来丰富你的英语词汇。
通过这种方法，不仅提高了口语能力，同时也增强了专业领域的词汇量，利用shadow speech提升英语学习的效率，帮助你在技术职业中更自信地表达自我。
什么是跟读法？
跟读法 (Shadowing) 是一种有科学依据的语言学习技巧，最初开发用于专业口译员的培训，并由多语言者Alexander Arguelles博士普及。这个方法简单而强大：您在听英语母语原声的同时立即大声重复——就像是一个延迟1-2秒紧跟说话者的影子。与被动听力或语法练习不同，跟读法强迫您的大脑和口腔肌肉同时处理并模仿真实的讲话模式。研究表明它能显着提高发音准确性，语调，节奏，连读，听力理解和口语流利度——使其成为雅思口语备考和真实英语交流最有效的方法之一。