Initialization of the data source failed.

Question

I am trying to use "New Query" to refresh data from a webpage but get the following issue: "Initialization of the data source failed. Check the database server or contact your database administrator. Make sure the external database is available, and then try the operation again. If you see this message again, create a new data source to coneect to the database." This is Microsoft Office Professional Plus 2016 edition. I am trying to set up a new query in office 2016 (not opening a file from a previous edn)

Answer 1

Hi,

We noticed the post has been inactive for 48 hours now. We'd like to make sure if you still need assistance regarding this issue.

If the previous recommendation resolved your issue, we encourage you to inform the Community by marking the post as an answer or by clicking on Helpful.

Let us know if you need further assistance.

Answer 2

Hi,

---

Errors in creating a query to Excel could be due to an incorrect setting while attempting the query. For starters, we suggest checking this support article: Add a query to an Excel worksheet (Power Query). The said article contains step-by-step guide on creating a Power Query which you might find useful in resolving the process.

Don’t hesitate to ask us if you have other queries.