Forum Discussion
Change Source Unavailable for Excel File
Worst case you should be able to use the Query Editor to just change the Source step either through the gear icon or Advanced Editor.
The icon doesn't exist beside 'Source' (again never seen that) and I instructed my colleague to use the Advanced Editor trick and he claimed it didn't work.
Any other suggestions, or maybe tips on why this happens so I can avoid it happening again?
Any way that you could copy and paste the code from Advanced Editor? Or are you not allowed in Advanced Editor?
Here's the snippet for just the beginning. Let me know if the whole thing is more useful for troubleshooting
Source = Excel.Workbook(File.Contents("C:\Users\Sean\Desktop\Clients\Eguide\Community_Project_Verification_Form_.xlsx"), null, true){[Name="Table2"]}[Data]
seanpratt , Please refer:https://community.powerbi.com/t5/Community-Blog/Why-can-t-I-change-the-Data-Source-in-Power-BI-disabled-button/ba-p/915365
if you need more help make me @
Appreciate your Kudos.
