Changing Source Data

[Chandrashekar]

Hello Team,

Can you advise how to change source data. For Ex: Sheet1 to Sheet2(Column names are same).

Regards,

Chandrashekar B

[amitchandak · Accepted solution]

@Chandrashekar , Open Transform data-> Transform Data .

Right click on the table and open advance editor, you will see sheet name in code change that

How to Change Connection Details https://www.youtube.com/watch?v=59PUFuuCrbY

Change Connection from One source type to another Source Type and use existing steps: https://youtu.be/nwYJgG2hmd0

[Chandrashekar]

Thanks Amit.

Regards,

Chandrashekar B

[amitchandak]

@Chandrashekar , Usually Item is the sheet name. Refer code below

Source = Excel.Workbook(File.Contents("D:\Data\Sales Data Used in Video.xlsx"), null, true),
Sales_Sheet = Source{[Item="Sales",Kind="Sheet"]}[Data],

[Chandrashekar]

Hello,

Thanks Amit.

Regards,

Chandrashekar B