Forum Discussion
Changing Source Data
Hello Team,
Can you advise how to change source data. For Ex: Sheet1 to Sheet2(Column names are same).
Regards,
Chandrashekar B
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
4 Replies
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
Thanks Amit.
Regards,
Chandrashekar B
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],
