I'm using 2016. My external database is TeraData. I have no problem connecting the two, and getting the Query Editor window looking at the database table that is relevant to me.
However, I don't know M, and I already have a SQL query that I had been using to query the data directly in TeraData (and then pasting into Excel).
Is there really not a way that I can keep using that query, if I want to pull the data in through Excel? Must I re-write it in M?
However, I don't know M, and I already have a SQL query that I had been using to query the data directly in TeraData (and then pasting into Excel).
Is there really not a way that I can keep using that query, if I want to pull the data in through Excel? Must I re-write it in M?