I have few tables which are coming from SQL Server and some small tables i received in excel from client. unfortunately i dot have write access to the sql server and i have to join the excel table. But i am not sure of how to connect a table from SQL server and an excel data i uploaded separately to tableau. I dont see any options to connect them.Is that really possible? Please suggest. Thanks in advance for the helps.
It is possible to join between two data sources when (SQL Server & Excel) if you have a common columns with same data type so you can blend the tables using these columns (this is called data blending).
You can go through this video on how to connect to different tables from different data sources.