question

AnKLN-5160 avatar image
0 Votes"
AnKLN-5160 asked erinding-msft commented

Error While loading Data in Excel

Hi,

I'm using Power query of Excel 2016. I'm trying to import data from another Excel file.
After loading a few rows, I get the error :

"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. "

However, I'm able to see all the data in Power Query but the error appear when loading it in the worksheet.

Can you help me please to resolve the issue ?

office-excel-itpro
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

erinding-msft avatar image
0 Votes"
erinding-msft answered erinding-msft commented

Hi @AnKLN-5160

What's the version of your Office?
Firstly, please update it to the latest version to have a check.

I'm trying to import data from another Excel file.

<<Did you import data as below screenshot?
88533-image.png
What's the source of the Excel file? Will other PC or people import data from this Excel file successfully?
Does this issue occur when importing data from other Excel files? You could create a new Excel file to test.

Do you have other version of Office installed on this PC before? Please make sure to uninstall it completely.

If the above don't work, try repairing Office to check this issue.

Besides, are there any sorting, filtering, etc. in your data source? If yes, please remove these to have a try.
If there is table in the Excel file, you could right-click table, select Table> Convert to Range, then re-insert a table, re-import data from this Excel file.
88512-image.png

What's more, please temporarily exit third-party software if there is on the PC when importing to see if it helps.

Any updates, please let me know.

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


image.png (25.1 KiB)
image.png (18.2 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @erinding-msft

I have uninstalled Office completely and reinstall it and it worked.
I think the issue was from Office that was not well installed;

Thanks for your help.

0 Votes 0 ·

Thanks for your updates.
It's my pleasure to help~
Have a nice day. :)

0 Votes 0 ·
AnKLN-5160 avatar image
0 Votes"
AnKLN-5160 answered

Hi @erinding-msft

Thank's for your answer.

Yes, i'm trying to import data as in the screenshot.

This issue occur in my PC. I tried to import data with another PC and it works.

I really don't have an idea about the source of Excel file. But I have created a new Excel file and It doesn't work.

Now, I will try to uninstall Office completely and reinstall it.

I'll let you know if it will work.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.