Missing Data Source Connection
Missing Data Source Connection
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 (7.45 KiB) Viewed 110 times
-
- Compatibility Warning.png (8.01 KiB) Viewed 110 times
Re: Missing Data Source Connection
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.
Re: Missing Data Source Connection
Thanks for the reply, Rudi. I updated and have gotten all the features back.
Who is online
Users browsing this forum: No registered users and 1 guest