Street and highway labels are available as a layer--see the map card on the right hand side of the map. Assuming you are at a high enough zoom level, check the box and you should be fine.
Are you interested specifically in Google Maps or the ability to see road names (some/all)? Technically, Google Maps can be accessed by proxying a WMS server, but the results will be slow, inconsistent and this also contravenes the Google ToU. But have no fear! Urban Mapping offers native mapping to Tableau customers, meaning our map services tie directly into Tableau. We'll be giving more info to the community about hacking the tms, giving you greater customization, but that is recommended only for advanced users!
Thank you very much for taking the time to respond. The layer that is available is great and gives me exactly what I need at this point in time.
I was keen to show the road network and this option does that nicely and as per your suggestion when I am looking at a specific area of the UK the Zoom functionality gives me the ability to view the road labels.
Many thanks again for replying with very useful information.