Forum Discussion
Change Source Unavailable for Excel File
Oh lord, what have I done? I created a Power BI dashboard using a long excel file for survey responses. However, I only used the data to connect to and built my dozens of measures within Power BI and...
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.
