Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello Team,
Can you advise how to change source data. For Ex: Sheet1 to Sheet2(Column names are same).
Regards,
Chandrashekar B
Solved! Go to 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 , 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],
Hello,
Thanks Amit.
Regards,
Chandrashekar B
User | Count |
---|---|
53 | |
22 | |
18 | |
16 | |
11 |
User | Count |
---|---|
80 | |
57 | |
40 | |
19 | |
10 |