1 Reply Latest reply on Feb 13, 2018 12:23 PM by Sina Zarafshan

    SQL Server Stored Procedure works fine in SMSS but not in Tableau

    Sina Zarafshan

      Hi guys,

       

      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.

       

      Sina