Power Query not working. - DataFormat.Error: The supplied URL must be a valid 'http:' or 'https:' URL.

Question

Hi, I'm using Excel 2016 MSO 16.0.9330.2073 64-Bit. Up to date (Jun-9-2018)

I've been using Power Query to retrieve data from an online store for price comparison of products I buy regularly. I've never had an issue until recently. I've been getting this error:

DataFormat.Error: The supplied URL must be a valid 'http:' or 'https:' URL.

Details:

    res://ieframe.dll/dnserrordiagoff.htm#javascript:void(false) 

I researched online and found out about Power BI which also uses Power Query. When using Power BI, I did not have any issue retrieving the data, which makes me assume this is an issue with Excel and not the website itself. The website appears to be the same content-wise, at least visually.

I can provide more information/data if needed.

Any help is much appreciated. Thanks.

Regards,

AZ

Answer 1

I'm pretty sure its a bug. Every since March 2018 I've had the same problem loading tables from web pages written with PHP. From time to time I would update the Office to just if it works... It's been several months now and still not working. I am reverting back to March update and will check back here again in a few months.

Answer 2

Hello
As per next link this could be a bug, I admit in no familiar with this workflow, but seen the next link looks like a bug.

https://community.powerbi.com/t5/Issues/The-sup...

Probable good idea to leave your feedback.

Here are you options to leave a feedback:

Give feedback on Microsoft Office

https://support.office.com/en-us/article/how-do...

Disclaimer: This is a non-Microsoft website. The page appears to be providing accurate, safe information. Watch out for ads on the site that may advertise products frequently classified as a PUP (Potentially Unwanted Products). Thoroughly research any product advertised on the site before you decide to download and install it.

Answer 3

Hi, thank you for the prompt replies and help.

My Excel is a new install, so I do not have any Add-Ins installed. I tried in Safe mode regardless. No change.

Repair install did not fix the issue.

Thank you for the help thus far, any further assistance is much appreciated.

Regards.

AZ

Answer 4

Hello, it is a pleasure for me to assist you with your request.

I would recommend to use the next link to proceed with a repair:

https://support.office.com/en-us/article/repair...

Let me know if you have any further questions.

Answer 5

Please try these options one by one and check after each option.

1. Sometimes, add-ins can cause problems. To determine, if add-in is a problem start your application in safe mode and see if problem has gone away.

To start in Safe Mode -

Hold CTRL key and click on application icon and don't release the CTRL key till it asks you for Safe mode confirmation.

If yes, then start application normally and disable add-ins one by one and start application again every time you disable an add-in to determine the culprit add-in.

To disable add-in > File > Options > Add-ins > Down below you have Manage: Com Add-in : Press Go > Untick the Add-ins to disable and tick to enable them

2. Try repairing your office installation (Quick repair is good enough). Try repairing your Office installation. First try Quick Repair (takes 5 - 10 mins) , if that doesn't help then try Online Repair (Takes more than 30 mins but less than 1 hour in general)

https://support.office.com/en-us/article/Repair...