Missing Data Source Connection

tykrumm
Posts: 2
Joined: Mon Apr 09, 2018 3:04 am

Missing Data Source Connection

Postby tykrumm » Mon Apr 09, 2018 3:07 am

I'm getting a Compatibility Warning when opening a workbook with queries made at work. It says "the queries were authored with a newer version of Power Query and might not work in your current version." The funny thing is, both my work and home version of Excel are 2016. Another strange thing i noticed about my home version is ever since I reinstalled and starting having these issues, I don't have the ability to create a conditional column in PQ; the option is completely missing. Any clues?
Attachments
No Conditional Column Option.png
No Conditional Column Option.png (7.45 KiB) Viewed 645 times
Compatibility Warning.png
Compatibility Warning.png (8.01 KiB) Viewed 645 times

Rudi
Posts: 6
Joined: Fri Sep 01, 2017 4:33 pm

Re: Missing Data Source Connection

Postby Rudi » Fri Apr 13, 2018 8:27 pm

It seems to me (from your screenshot) that you do not have the latest version of PQ? For the past few months, PQ has also had "Column From Example" and "Invoke Custom Function". I do not see these in your screenshot? Maybe try running Windows/Office Updates? This will also probably resolve your compatibility issues.

20180413_201.jpg
20180413_201.jpg (22.88 KiB) Viewed 611 times

tykrumm
Posts: 2
Joined: Mon Apr 09, 2018 3:04 am

Re: Missing Data Source Connection

Postby tykrumm » Sat Apr 14, 2018 11:42 pm

Thanks for the reply, Rudi. I updated and have gotten all the features back.


Return to “Power Query”

Who is online

Users browsing this forum: No registered users and 1 guest

cron