Hi, Just wanted to know how much s the average number of records which a single user is expected to load.
I mean it can't be like all user want to see all 15 million records.
if average number of records needed for a user in around 500000 or less than following approach might help.
pull your user detail table and put the DB filter as
user_name = username()
in filters option in datasource.
here user_name should be the column with user name in your user table.
this will reduce your data for user table to 1 record on runtime.
after that pull your table with main data and join it with user table in tableau.
due to this join data from main table will be reduced to only this user.
only demerit is you have to keep your data source as live.
I hope this Helps you.