Please refer below links, I hope it' s useful for you. If Useful then marked as correct band helpful.
amar D. Savale
Just connect Tableau directly to SQL Server and it will work
Have you got that ?
Not really .... do you want the data to automatically from the dashboard ?
Can you create a mockup of what you're trying to do ?
Does that help or not ?
No you are just telling me how to get filter data its not the case here.
Look If we connect oracle database or any excel sheet for example in the data source tab we will get all the data in the sheet right.
Same as that i have to directly access to that data if i click on some sheet holding that data table if i click that all the data in the sheet shouls display in my worksheet.
are you there ?
Hi Bangaru, just a friendly reminder that most of the folks here that respond to Forum questions are actually not Tableau employees. They kindly volunteer their time to help others with their Tableau questions. If you're looking for a direct link to Tableau Support, I would recommend raising a case --> Support & Services | Tableau Software
[Program Manager | Tableau Community Forums]
Thank you ciara
But ciara I think this was not by default provided by tableau, so need to have out of box idea to crack this that's why i have posted in forum
1 of 1 people found this helpful
Would it help if you drew us a picture of what you're trying to achieve? I don't think we're understanding your requirement. My first thoughts were similar to those posted by Chris. I've had another think but am still not really getting what you're after. I've drawn an example below of what I think you could be meaning, but throw that away and draw us a better picture if you think it'll help!
yes steve the same one
An interesting requirement - sounds like a fun project!
I have some follow up questions for you:
- Are the tables all the same structure (same columns) or do they differ?
- How many tables are we talking about? A handful, more, everything in the database?
- Will that list of tables change over time? "No, it's always the same 10 tables" or "Yes, as new tables are added to the database we want to see them in the dashboard!"
Depending on the answers the advice may change but ...
If the tables are all the same structure then you may actually be able to do what Chris has already suggested. E.g. could you UNION them together along with an indication of table name in the query, then use the table name as a filter?
If the tables differ in structure then do they differ by much? If not then the above option may still be workable. If the tables differ lots then continue reading.
Okay, so the tables differ quite a bit. Sweet that makes it a more challenging task. Fun times! How many tables are there? If there's always a set small number of tables then could you consider: Defining a sheet per table. Then adding a parameter and using sheet swapping in your dashboard? That would mean no need for the API side of things eh. https://www.thedataschool.co.uk/hashu-shenkar/tableau-tip-switch-between-views-dynamically-on-a-dashboard/
Still no good? Lots of tables, lots of different columns? ... or small number of tables but looking for the dashboard to cater for new tables as and when they're added to the SQL Server database? I shall have to think further on this but my first thought here would be that you're trying to build in Tableau what might be better achieved by giving someone very basic database querying access via a different tool.
If I'm still not getting please do have another go at explaining the complexity!