I ran into a strange problem. I have a PROC in SQL Server that works just fine w/o any error and populates the desired table.
When I connect to the PROC in Tableau, Tableau sees the data structure, load all the fields but no data at all. Number of records is zero.
I've been using PROC and Tableau for a long time and never had a problem.
More info: All my PROCs live in one database. Connection property is the same for all of them. I am on Tableau 10.5.
Any thoughts is much appreciated.
So, I solved my own problem
Seems like when you have a cursor in your PROC, and you want to use your cursor's variable in your final table as a field, then having that variable as a VARCHAR(max) causes the problem. I've changed it and now it's working fine.