Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Solved! Go to Solution.
Are you reformatting your Excel web URL? Like this: "You have to strip out the :x/r/ from the middle of the URL and the question mark and everything after from the end and then it'll work."
Hi jeffshieldsdev,
Thank you so much for reverting back quickly. I did as you told and it is working now,
Cheers
Are you reformatting your Excel web URL? Like this: "You have to strip out the :x/r/ from the middle of the URL and the question mark and everything after from the end and then it'll work."
Hi,
I've got the same issue execpt when I follow you advice I don't have the :x/r/ or the ? in my URL
In my query edittor I have the following as my source:
= Excel.Workbook(Web.Contents("https://(then my link url).xlsx"), null, true)
Any ideas that can help me?
Thanks for this solution, it has been making me anxious from last many days.. Strange kind of error..