Forum

OneDrive Personal -...
 
Notifications
Clear all

OneDrive Personal - Embed path not working

1 Posts
1 Users
0 Reactions
61 Views
(@rtrenz2007)
Posts: 1
New Member
Topic starter
 

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:

  1. In Onedrive, right-click the file and go to "</>Embed".
  2. At the bottom of the popup, click the "Customise how this embeded workbook will appear to others
  3. In the new browser's tab appear, look for the "Embed Code" section, where you will find the path you need.
  4. 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?

This topic was modified 16 hours ago by Ryan Renz
 
Posted : 26/04/2025 2:23 am
Share: