Excel 2016 - Problem with 'Power Query'

Question

When I had Excel 2013 I was able to use Power Query.

Now I have a new laptop, with Excel 2016 Standard.

When I want to make a new document with the 'Get and Transform' function, I can't.

Also when I try to renew an old document, made with the Power Query 2013, I get the same message.

I don't know how to say it in English, but it says: 'Initialisatie van de gegevensbron mislukt'.

Can you help me?

Greetings,

Hanne

Answer 1

The problem occurs when I open an older document in the new version, not the other way around.

Greetings Hanne

Answer 2

Hi Hanne,

When I had Excel 2013 I was able to use Power Query.

Now I have a new laptop, with Excel 2016 Standard.

When I want to make a new document with the 'Get and Transform' function, I can't.

Also when I try to renew an old document, made with the Power Query 2013, I get the same message.

I don't know how to say it in English, but it says: 'Initialisatie van de gegevensbron mislukt'.

See:

https://support.office.com/en-us/article/Power-Pivot-error-Initialization-of-the-data-source-failed-55d6b559-3124-4583-85fb-deb2fa1c098b

===

Regards,

Norman

Answer 3

Hi Hanne,

Thank you for posting in Microsoft Community.

Since the issue is related to Power Query, your issue would be better addressed in the Excel IT Pro forums:

Click on the link below to post the query:

http://social.technet.microsoft.com/Forums/en/excel/threads

If you have any issues related to Office, you may post and I would be glad to assist you.

Thank you.