쉐도잉 연습: AI Can Now Build ANY Power BI Chart You Want - YouTube로 영어 말하기 배우기

The first time I created this chart,

⏸ 일시 정지

재생 속도:

304 문장

문장이 너무 짧거나 길면 Edit를 눌러 조정하세요.

The first time I created this chart,

it took me about half an hour,

but now AI can do it for me in less than a minute.

And there's a lot going on here.

Reference lines, highlight areas, new measures that need to be created,

visual calculations and a disconnected table.

Now I can take care of all of that.

Now in this video, I'm going to show you how to give AI the skills to create any chart you like.

Let's go.

Most Power BI developers that are using AI for development,

they're using the Power BI Data Modeling MCP server,

which gives a large language model access to your data model so that it can read or make changes to your tables,

your measures, the relationships, and that can speed up the whole development process by a lot.

However, what it cannot do is make changes to or create new visuals.

Now, to make that happen,

we have to take care of a few things.

Now, first of all, we need to save a Power BI report in this new PBI-P format,

which is basically just a folder,

multiple folders, with text files for the different components of your Power BI report.

Now, these text files AI can read and make changes to.

All right, so that's the first thing.

Now, the second thing is that large language models are trained on general data.

It doesn't know how your company or you personally do certain things.

It doesn't have your templates.

And that is a problem because if we would just ask ChatGPT

or Cloud to start making changes to these Power BI project files,

well it probably is not going to succeed

because a lot there is not documented

and it doesn't know how to create certain charts

so we have to give it the instructions to do so

and that we can do by using scales now scales are the big topic in 26

and are basically there to create anything that you want

and we can also use those for power bi now creating those scales sounds a little bit intimidating at the beginning.

However, it's nothing else than a text file,

a markdown file, which is called skill.md

that contains basically the instructions for the large language model to get to a certain output.

And you put that in a folder where the AI agent can find it together with maybe scripts

or other examples that it can use to get to that output.

Now, let's just do it and you will see it's not as difficult as it sounds like.

Now, over here, I want to create a scale that creates this chart over here,

which I did manually in my previous video.

So if you want to go over all of the steps manually yourself,

then check it out over here.

However, here we're going to create a scale for it.

Now, what do we need to create that scale?

Because, well, AI can do it for us.

Now, for that, we need the Power BI project files from the before state

and the after state so that it can see the differences.

Now, so I'm having over here the PBX file,

which I'm going to save as a Power BI project file.

All right, so save as.

And I created a folder with two subfolders,

start and end, where I'm going to save these Power BI project files.

So this is going to be the end result.

And then I have the same Power BI report in the before state,

so where I don't have the chart and the required measures.

So this one, I'm also going to save in that Power BI project format.

Now make sure to put it then in the start subfolder and save it there.

Now if we then go to one of these Power BI project folders,

for example, for the end solution,

then you will see how they are built up.

We have that PBIP file next to two subfolders,

one for the semantic model, one for the report.

Now we are interested in the report one.

Then you will find all different kinds of text files for the pages and the visuals.

For example, if we go here to definition,

pages, then here you see a subfolder for the visuals and you will see that for each visual,

you have a separate JSON file.

Now, we have all of the instructions of how it is built up.

All right, now, if I open one of them,

then you will see it actually does make sense.

For example, this one is for that slicer that plays on top of that visual with all of the details.

Now, there's no general documentation on this and therefore,

to create that scale, AI really needs this as an example,

that before state and after state.

All right.

So with this in place,

we are ready to take the next step.

Now we need Cloud Code or Codex or Visual Studio to start working on the scale to create it basically for us.

Now, I prefer to do it in Visual Studio Code.

So let's download that first.

You can just Google Visual Studio Code download and it will bring you over here we can download it for free.

All right.

Now let's open it up.

And the first thing that you can do here is open a folder that you want to use for this project.

Now I'm just going to pick that same folder from before.

And then we need to install Cloud Code or Codex, whatever you prefer.

Now here we can go to extensions to do so.

Type in Cloud and it will pop up.

There it is.

And then you just have to click on install.

That's it.

All right.

And after you install it,

well, then you just have to open up a new session

which you can do now by clicking on this little cloud code icon

and then new session now you can also open it up in the terminal

so you can click here on view terminal

and now we can ask God to make the skill for

100

us on the basis of these two Power BI project files where we have the before

101

and the after state and it can look at the differences

102

so that it can create the instructions to get to the end result now before we do

103

that though it's maybe helpful that you have seen a scale md file

104

so that you know what we are creating

105

so let me show you an end result for a different chart type skill

106

that i created before

107

and this power bi scale is to create pagination for any type of visual

108

109

if i open this scale md file every scale md file

110

starts in the same way we have over here these three little hyphens followed by the name

111

and the description now this is the name of the scale

112

which needs to correspond to the folder that it's stored in

113

and we have the description which is really important because the name

114

and the description the yaml the front matter gets loaded into the context first of all of the skills

115

that are there and on the basis of the prompt

116

and what you are asking ai to do it's going to check okay

117

which skill do i need on the basis of the name

118

and the description before it loads all of the other stuff

119

into the context okay now then we have the body

120

and in the body you basically describe all of the steps

121

that the large language model needs to take

122

and you see here we have different sections like how it works the prerequisites

123

and if we scroll a little bit further

124

and you see the implementation steps now here we do not have all of the dex measures

125

and examples no that is stored separately

126

with this scale md file so here you see i have for example templates tmdl folder

127

and here we have templates for the data table items table pages table

128

and i have also here pbir where i have all of

129

the visual elements now having this in your scale means it can use these examples these files to create

130

that chart on any Power BI report that you have,

131

if you set it up correctly.

132

All right.

133

So this is what we are trying to create or what Claude is going to create for us.

134

So if we go back here to our Claude code session,

135

we have to prompt it to create exactly that.

136

Now, how can we do that?

137

Now, over here, I have a prompt that we can give to Claude to create these scale files.

138

So it says that we have a start

139

and end folder showing a Power BI method to highlight a

140

time window in the line charts using a slicer stored in a Power BI project format,

141

div them and build a cloud code scale.

142

And over here some requirements.

143

Now let's try this out.

144

I'm just going to copy this,

145

go back to our cloud code window and put it in there.

146

Now over here if you paste it twice you can see the whole prompt,

147

press enter and let's see what it does.

148

Now after four minutes or so it analyzed all of the Power BI project files

149

and what the differences are and what steps So you see,

150

it says I have a complete picture now of the differences.

151

Here's what's changed.

152

New dim date slicer, two new measures,

153

ref ref table line etc now

154

do you want me now to create that skill

155

and default yes all right so i'm just going to go for

156

that second option where we allow all edits during this session

157

so option number two and you see now it's writing

158

and creating all of these files all right it's done it took about seven minutes

159

and it created seven files so here you see all of the files

160

that it created now of course that's skill md file

161

which then refers to the templates and the examples

162

that it can use okay so let's check it out let's go to the folder

163

and it called our scale time window highlights now let me just open it up you see we have

164

that skill md file let's open it

165

and it actually forgot to put in the name and the description

166

which is really important so let's fix this let's go to cloud code add the

167

name and description to the skill md file yaml all right

168

so now the name

169

and the description should be popping up in the scale md

170

file yep there you go perfect now followed by the goal

171

the prerequisites here we have all of the variables in the template

172

and here the step-by-step instructions where it points to the other files

173

so if we go back to the scale you see here we have the examples in the templates folder

174

and in the templates folder there we for example have the template for dim date slicer all right

175

so it can use all of

176

that okay now we have to put it to the death

177

and see does it actually work now how can we actually make use of this skill now scales

178

they are an open standard so you can use cloud code you can also use codecs whatever you prefer

179

but they need to be in the right place either we

180

leave them in the project folder where your power bi report lives

181

or we put them in a place where cloud can always find it

182

so let's go for that second option so i'm gonna go back

183

and i'm just going to copy a scale from here

184

and then i go to my user folder where we have the folder for cloud

185

and in the cloud folder we have scales okay now i took all of my scales away

186

because i just want to show you how to do it

187

when you have nothing yet i'm going to put it in there

188

and now claude should be able to find it how do we know well

189

if we go back to visual studio code

190

and let's open up a new terminal session over here and

191

if you now do forward slash

192

and then look up the name of your scale now in this case it contains something window

193

so you see time window highlight it should be popping up

194

so we can use it however i don't want to tell claude to specifically use

195

that scale i want to keep it a little bit more vague

196

so let's give it the following prompt i have a pbip project at this file path

197

and i just copied the start folder

198

and i want to enable the user to select the time window

199

and then line chart in the first page okay that's it all right

200

so let's see what it does now it correctly figured out

201

that it should be using our time window highlight scale

202

so that's a success do you want it to proceed let's go for yes

203

or the second option and now we can just lean back

204

and see what it does oh another question um all right do you want to list all files

205

and folders in the power bi project is

206

that okay yep now you can also just let claude do everything

207

and just run to the end however maybe it's a good

208

idea to keep a little bit of control over the process which is probably a little bit safer now

209

over here list top level directories is also okay all right it's done it created semantic model changes

210

and report changes by editing certain files or creating new ones for the visuals that that were not existing before.

211

So it's time to see if it actually worked.

212

Now I'm going to go to the file where I had a copy and then let's just open that BBI file.

213

And that looks promising.

214

Now the chart is a little bit big,

215

so I'm just gonna make it a little bit smaller.

216

All right, now here we have that slicer and we can just adjust the range.

217

There you go.

218

And you see, we have only labels for those data points

219

that are within the selected time window we have the reference

220

lines the highlight area we have a disconnected table there for

221

that slicer that it created we have new measures that were added

222

and if i select the visual you see there's a visual calculation perfect quick note

223

if you want to have the scale from this video there's

224

a download link in the description below i will be adding

225

there some extra resources in the future as well around Power BI development with AI

226

which is part of something bigger than I'm currently working on

227

which is super exciting

228

so make sure to check it out let's go back to

229

the video now the real question is will it still work

230

if we have a completely different data set now one great

231

way to test this is just to take the example data set from Power BI

232

so I'm going to create a new blank report

233

and let's just load the sample data into it

234

and now i'm going to save this report as a power guy project

235

so let's go over here and put it in a new folder

236

so the folder that i created is called demo

237

and over here i'm just going to switch to pbip

238

and let's call this one demo i'm going to trigger

239

that scale in the same way as we did before in a new cloud code session

240

so i'm just going to copy over that prompt with the only adjustment

241

that we are now pointing to the demo power bi project

242

okay that's it all right now let's Let's see what it comes up with.

243

Now you see that in the prompt,

244

I'm referring to a line chart that actually doesn't exist,

245

but it's smart enough to figure that out and create it for you.

246

Now, over here, do you want to proceed?

247

So we have to, well,

248

press two or one a few times.

249

All right, so now something interesting is happening

250

because of course it doesn't see the line chart and it has different data to work with.

251

So we need to answer a few questions.

252

Now, first of all, which column should be the x-axis of the line chart?

253

So here we can, for example,

254

say it should use the month name.

255

All right.

256

So two.

257

And which value should the line chart plot on the y-axis?

258

Sales, profit, cost, sales, unit, solve.

259

Let's go for sales.

260

And where should the two new DAX measures be stored?

261

New measure table?

262

Yeah.

263

Maybe let's go for that.

264

Okay.

265

So let's submit these answers.

266

And now it continues.

267

All right.

268

It's done again.

269

So let's open up this demo file and see if it worked.

270

And that looks promising now over here you can just click it away

271

or click on refresh now we have a slicer

272

which is based on dim date slicer created for us we can choose our time window

273

which is connected to that highlight area perfect now creating these scales is an iterative process

274

and often you have to prompt claw a few more times to get it perfect

275

so that you get exactly that result

276

that you're looking for for example in this case i would ask it to create a day table

277

if it doesn't exist so and well claude probably would create another template file

278

that it can then use all right so you see this is pretty awesome

279

and i will put up this scale for you to download

280

just follow the link in description maybe i also create a few more for example i also have one here

281

that creates pagination

282

and here it is you see it turns a normal bar

283

chart into a bar chart where we have pagination now that That scale is created in exactly the same way.

284

And you will see over here also has a scale.md file with templates.

285

So if I open this one up,

286

then we have the front matter,

287

the name and the description,

288

followed by all of the steps where it refers to all of the templates and examples.

289

All right.

290

Now, what do you think?

291

Is this the next revolution in Power BI development?

292

Well, I think it is going to make a big change in how we create a report.

293

We were already able through the Power BI data modeling MCP server to make changes to the backend.

294

However, now, well, we can do much more.

295

Create any visual that we want and,

296

well, the opportunities, they are endless.

297

So let me know your thoughts,

298

put your ideas in the comment section below and let's explore this further.

299

Now, if you like these tips and tricks,

300

then make sure to also check out these videos over here.

301

If you want to create Power BI reports together with me,

302

see my process from beginning to end,

303

then check out my Power BI design transformation program over there.

304

Thank you for watching and see you in the next video.

TRENDING

쉐도잉이란? 영어 실력을 빠르게 키우는 과학적 방법

쉐도잉(Shadowing)은 원래 전문 통역사 훈련을 위해 개발된 언어 학습 기법으로, 다언어 학자인 Dr. Alexander Arguelles에 의해 대중화된 방법입니다. 핵심 원리는 간단하지만 매우 강력합니다: 원어민의 영어를 들으면서 1~2초의 짧은 지연으로 즉시 소리 내어 따라 말하는 것——마치 '그림자(shadow)'처럼 화자를 따라가는 것입니다. 문법 공부나 수동적인 청취와 달리, 쉐도잉은 뇌와 입 근육이 동시에 실시간으로 영어를 처리하고 재현하도록 훈련합니다. 연구에 따르면 이 방법은 발음 정확도, 억양, 리듬, 연음, 청취력, 말하기 유창성을 크게 향상시킵니다. IELTS 스피킹 준비와 자연스러운 영어 소통을 원하는 분들에게 특히 효과적입니다.

☕ 커피 한 잔 사주기

ShadowingEnglish는 여러분의 지원 덕분에 100% 무료로 운영됩니다. 서버 및 AI 유지 비용이 많이 듭니다. 여러분의 커피 한 잔이 큰 힘이 됩니다! ��

PayPal로 기부하기

ShadowingEnglish.com – 영어 쉐도잉 연습

쉐도잉(Shadowing)으로 원어민처럼 영어를 말하세요. YouTube 영상을 한 문장씩 듣고 따라 말하며, 진짜 발음과 유창성을 키우세요. IELTS 학습자들이 선택한 방법.

쉐도잉 연습: AI Can Now Build ANY Power BI Chart You Want - YouTube로 영어 말하기 배우기

인기 동영상

이 비디오로 말하기 연습을 하는 이유는 무엇인가요?

문맥 속의 문법 및 표현

일반적인 발음 오류

쉐도잉이란? 영어 실력을 빠르게 키우는 과학적 방법

쉐도잉 연습: AI Can Now Build ANY Power BI Chart You Want - YouTube로 영어 말하기 배우기

앱 다운로드

이 비디오로 말하기 연습을 하는 이유는 무엇인가요?

문맥 속의 문법 및 표현

일반적인 발음 오류

쉐도잉이란? 영어 실력을 빠르게 키우는 과학적 방법