Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi I have an excel file stored locally on my computer. I have saved the same file to sharepoint and I am trying to change my source from the local file to the share point file in the query editor by clickin on the little cog next to source in the applied steps. I changed the URL to the share point file and open file as excel workbook and I get this error. Any idea what is happening?
Solved! Go to Solution.
Hi @fingalbrad ,
The way to get excel file in local and in sharepoint is different.
Local file:
Sharepoint:
So, I suggest you change the whole code after Source= to change your data.
Regards,
Daniel He
Hi @fingalbrad ,
The way to get excel file in local and in sharepoint is different.
Local file:
Sharepoint:
So, I suggest you change the whole code after Source= to change your data.
Regards,
Daniel He
So typcially a file on Sharepoint will have a http address like:
eg.
http://myserver.com/sites/site1/library/mydocument.xslx
You can often change this to a unc style path and then your existing Power Query code will continue working. You do this by replacing the leading "http://" with "\\" and swapping all the forward slashes "/" to backward slashes "\"
eg.
\\myserver.com\sites\site1\library\mydocument.xslx
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |