I tried to refresh my PowerQuery file that is connected to an Excel file on OneDrive Personal, and received the following error: "DataSource.Error: The downloaded data is HTML, which isn't the expected type. The URL may be wrong or you might not have provided the right credentials to the server."
In troubleshooting this, I tried to recreate the steps that I had followed to generate the file path. These are the instructions that I had found in the past, and had worked for me previously:
- In Onedrive, right-click the file and go to "</>Embed".
- At the bottom of the popup, click the "Customise how this embeded workbook will appear to others"
- In the new browser's tab appear, look for the "Embed Code" section, where you will find the path you need.
- After copying the path, use this video "Get data from OneDrive Personal files with Power Query" to manipulate the path to a path PQ can digest.
However, now when I go to "Customise how this embeded workbook will appear to others" and look in the Embed Code section, it no longer provides a URL link. I only see the below code. Is anyone else experiencing this?
<iframe width="402" height="346" frameborder="0" scrolling="no" src="?wdAllowInteractivity=False&wdHideGridlines=True&wdHideHeaders=True&wdDownloadButton=True&wdInConfigurator=True&wdInConfigurator=True"></iframe>
Why am I receiving the error "The downloaded data is HTML"? And why do the Embed Code steps no longer produce a valid file path?