Closed EvaRuthM closed 5 years ago
@aidenyang, this is the issue related to Tableau. What we'd like is to have a tab on the website for Tableau dashboards like the example above. We have Tableau Desktop for nonprofits, which can connect to a Google Sheet. The problem that I've run into is that I can't get it to connect to any sheets in the Team Drive. I don't want to duplicate the sheets (and therefore duplicate the data sets that need to be updated) and only want to have one place where the data gets updated. So far, that's the only workaround I've found.
Hi @EvaRuthM, after Googling a little, I think you're right about the workaround. It looks like by using IMPORTRANGE and importing the TeamDrive sheet into a sheet in your personal drive, you can keep the new sheet in sync with the TeamDrive sheet. Shouldn't need to update the data in more than one place.
hey @aidenyang! I managed to set these up this evening. I now have the spreadsheets on my google drive and can connect to them on Tableau. I'm still trying to figure out through Tableau if I can have multiple users on one account.
create a tab for Tableau dashboards