Missing Data Source Connection

[tykrumm]

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?

[Rudi]

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 (22.88 KiB) Viewed 248 times

[tykrumm]

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