Page 1 of 1

Missing Data Source Connection

Posted: Mon Apr 09, 2018 3:07 am
by 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?

Re: Missing Data Source Connection

Posted: Fri Apr 13, 2018 8:27 pm
by 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 607 times

Re: Missing Data Source Connection

Posted: Sat Apr 14, 2018 11:42 pm
by tykrumm
Thanks for the reply, Rudi. I updated and have gotten all the features back.