There is no way to do the former (create tabs where there are none). We actually treat/load the workbook slightly differently on the server based on the whether "Show sheets as tabs" was selected at publish time. One can easily do the latter (hide tabs later), however:
Hope this helps!
I've also read recently that Show Sheets as Tabs slows down the visualization. I tried this today with one of our dashboards which uses lots of data and this advice does appear to be true. If you use multiple tabs against the same data source with filters which work across views, I think the server must try and run the other views or at least do something with the filters. When they are not in tabs I think it must be treating them separately as it is definitely a lot faster.
The “other” sheets (tabs) actually aren’t executed in any way until they are given focus. The reason it can take longer is that we need to do extra “up front” discovery work to make sure we understand what’s behind each tab so that a user can navigate to it seamlessly.
Perfect. Thanks for the response. I will just upload as tabbed version for now and then I can pull out individual sheets if necessary.