跟讀練習: The Simplest Way to Connect Claude and Power BI - 通過影片學習英語口語

選擇練習模式

每種模式都會開啟全屏練習室。

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 發音評分逐句打分
音標練習掌握每個音
詞彙學習建立你的詞庫
詞彙遊戲邊玩邊學
FOR YOU

推薦影片

背景與背景

在這段影片中,講者分享瞭如何將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的方法跟讀影片內容。通過這種方式,學習者能夠更好地理解發音、語調,以及如何在特定場景中使用專業術語。以下是跟讀的步驟:

  1. 首先,觀看影片並獨立記下重要資訊和術語,尤其是與Power BI和Claude相關的內容。
  2. 隨後,反覆播放影片的關鍵部分,跟隨講者的語速進行跟讀。你可以使用shadowspeaks技術,模仿講者的口音和語調。
  3. 在每次跟讀後,暫停影片,自己重複講者所說的話,確保發音準確。
  4. 嘗試在不同場景中使用影片中的短語,例如與朋友討論技術問題或工作中的資料分析。
  5. 最後,定期回顧和總結所學的內容,評估自己的進步,並尋找新的短語和表達方式來豐富你的英語詞彙。

通過這種方法,不僅提高了口語能力,同時也增強了專業領域的詞彙量,利用shadow speech提升英語學習的效率,幫助你在技術職業中更自信地表達自我。

影片中的語法

說話人最常用的結構,並附上影片中的原話:

結構影片中的用法
現在完成時 have/has + 過去分詞 — 過去發生但與現在仍有關聯的事you've already guessed · have already installed · have gotten
被動語態 be + 過去分詞 — 強調發生了什麼,而不是誰做的is installed · is kept · is mentioned
定語從句 who / which + 從句 — 補充說明人或事物table, which is · measure, which is

什麼是跟讀法?

跟讀法 (Shadowing) 是一種有科學依據的語言學習技巧,最初開發用於專業口譯員的培訓,並由多語言者Alexander Arguelles博士普及。這個方法簡單而強大:您在聽英語母語原聲的同時立即大聲重複——就像是一個延遲1-2秒緊跟說話者的影子。與被動聽力或語法練習不同,跟讀法強迫您的大腦和口腔肌肉同時處理並模模擬實的講話模式。研究表明它能顯著提高發音準確性,語調,節奏,連讀,聽力理解和口語流利度——使其成為雅思口語備考和真實英語交流最有效的方法之一。

影子跟讀法: 閱讀完整分步指南 →