Running the SQL that you provided results in a table that works fine for me in 2018.2. Are you seeing any errors in Tableau? In SQL Server can you check to make sure the geometry that you have is valid, has SRID assigned, etc.?
But, assuming that your table was generated using the same code you pasted into your question above, I don't see any reason why it shouldn't work since it is working for me in 2018.2
hmmm. If the above code worked for you all should be fine on the database side. Given same version of Tableau, this leaves the driver as the culprit? What version of SQL server are you running? I created my datasource using connection to "Microsoft SQL Server". Any way to know what driver it's using?
Thanks for your help!
I’m using SQL Server Express 14.0.1000
As for knowing what driver is being used, I’m sorry that I don’t have a clue… I mostly deal with SQL Server when forced ☺
You could check the driver download page<https://www.tableau.com/support/drivers> to see if there is a new driver for your version of SQL Server. Maybe the difference is that I was using a fresh install of 2018.2 with whatever recent updates would have come out.