Perform join on data from Postgres in data studio

Thanks very much for the reply. Yeah I thought so -- I couldn't find a way. I don't want to create views in the postgres db because it's my ERP database and I don't want to make a mess of it. Would need too many of them anyway.

Obviously this is a major thing that needs to be implemented, and a feature of Tableau that you would expect to have. Google Data Studio has a lot of promise to eventually replace Tableau, but it's nowhere near it yet. I wish there was a simpler way to submit "suggestions" to the developers, but hopefully they are reading these forums.

but i doubt it will make big difference, GDS team do not share their roadmap, so you don't really know what they are planning for the product.

do you need the data to be live or are you happy to have just multiple refresh per day, and then that depends too on how much data you have, Google sheet can connect to your ERP and then you can load the data from there

Re: Perform join on data from Postgres in data studio

Thanks, yes, I thought of that also. Unfortunately, my crappy ERP (Odoo) presents difficultly in making that bridge, but I will probably end up doing it that way with Sheets. I don't need real-time, just to refresh when viewing the report is fine.

Definitely they will have to make this possible, but it could be a long time. In Tableau it's easy: