Excel 2016 and Power Query issue

[gmeunier]

Hi everyone,

I developed a file on O365 using Power Query for my wife to automatize some tasks.
On her laptop the file with power query would not work (using Excel 2016).
I first thought it was linked to a version issue but then I did the following on her professional laptop :

1. Close and reopen Excel
2. Create a new file
3. Create a table with headers and one line, load it up in power query.
4. Close power query and save.
5. A worksheet with the results of the query is being created.

As far, everything is fine. Then comes the issue :
When I update the table of the result query or if I do Data > Update all data, the following message shows up :

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 connect to the database

Of course, if I change the set of the data, the PQ result does not update.

So that is not linked to my file but to her Excel configuration I guess.
I saw some posts on that topic, unfortunately with no answer that would solve that issue.

Any idea ?

Many thanks,

Gerald

 

[sandy666]

the same file works on XL365 but doesn't work on XL2016 on different computers?
could you share this file (wife) via onedrive, googledrive or any similar service and paste link to the shared file here? (if there is no any confidential data)

 

[gmeunier]

the same file works on XL365 but doesn't work on XL2016 on different computers?
could you share this file (wife) via onedrive, googledrive or any similar service and paste link to the shared file here? (if there is no any confidential data)

Hi sandy666,

That is not due to the file.
As said, starting from scratch with a newly created file on HER laptop, I get the same issue :

1. Open Excel
2. Create a new file
3. Create a table with headers and one line, load it up in power query.
4. Close power query and save.
5. A worksheet with the results of the query is being created.

As far, everything is fine. Then comes the issue :
When I update the table of the result query or if I do Data > Update all data, the following message shows up :

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 connect to the database

 

[sandy666]

anyway could you post a link to this file? shared file
or at least an M-code from Advanced Editor. Don't forget to use code tags

 

[gmeunier]

Here is the file.
Simple file
When opened back in O365, Excel finds out an issue and fix it.

 

[sandy666]

downloaded, saw error, refreshed and it works (XL2016)
maybe try update XL2016 to the latest?

 

[gmeunier]

downloaded, saw error, refreshed and it works (XL2016)
maybe try update XL2016 to the latest?

I effectively think it is linked to the version of excel installed. I did a repair on it but had the same issue.
I know that some other laptop of her company my original file worked out with xl2016.
I asked her to look for the version used on that one.
I will keep you posted.

 

[sandy666]

would be nice to see what's going on there