cannot connect data with looker studio from Postgres: I just started using my Looker Studio account and can access a report that is shared with me, but when I try to add data sources, it says "Sorry, we encountered an error and were unable to complete your request."
I had to migrate from my PostgreSQL version 15 to version 14 in order to use Looker Studio. It worked, but exactly 3 days ago, I haven't been able to connect to PostgreSQL and I'm getting the same error without much more information.
how can I fix this: cannot connect data with looker studio from Postgres: I just started using my Looker Studio account and can access a report that is shared with me, but when I try to add data sources, it says "Sorry, we encountered an error and were unable to complete your request."
its maybe the postgree versión, I had to migrate from my PostgreSQL version 15 to version 14 in order to use Looker Studio. It worked, but exactly 3 days ago, I haven't been able to connect to PostgreSQL and I'm getting the same error without much more information.
Yes, that's right. Looker Studio hasn't implemented support for all versions of PostgreSQL yet. Supported versions: 9.6; 10; 11; 12; 13; 14; In any case, I would suggest to ingest data from PostgreSQL to BigQuery DWH, and then connect BigQuery to Looker Studio. Works 10x better and faster. JFYI BigQuery's costs are pretty tiny honestly.
According to this article - support.google.com/looker-studio/answer/7288010#zippy=%2Cin-this-article, 16 version is not supported rn. It seems like it is a known issue on forums. If besides Postgres you have any sort of DWH like BigQuery, then you may setup an ETL/ELT to ingest data from Postgres to BigQuery and, then, connect BigQuery to Looker Studio.
cannot connect data with looker studio from Postgres:
I just started using my Looker Studio account and can access a report that is shared with me, but when I try to add data sources, it says "Sorry, we encountered an error and were unable to complete your request."
I had to migrate from my PostgreSQL version 15 to version 14 in order to use Looker Studio. It worked, but exactly 3 days ago, I haven't been able to connect to PostgreSQL and I'm getting the same error without much more information.
how can I fix this: cannot connect data with looker studio from Postgres:
I just started using my Looker Studio account and can access a report that is shared with me, but when I try to add data sources, it says "Sorry, we encountered an error and were unable to complete your request."
its maybe the postgree versión,
I had to migrate from my PostgreSQL version 15 to version 14 in order to use Looker Studio. It worked, but exactly 3 days ago, I haven't been able to connect to PostgreSQL and I'm getting the same error without much more information.
Yes, that's right.
Looker Studio hasn't implemented support for all versions of PostgreSQL yet.
Supported versions: 9.6; 10; 11; 12; 13; 14;
In any case, I would suggest to ingest data from PostgreSQL to BigQuery DWH, and then connect BigQuery to Looker Studio.
Works 10x better and faster. JFYI BigQuery's costs are pretty tiny honestly.
I try to connect the postgres v16 with looker studio but it not work with this connector.
do anyone know other way to connect it.
could you elaborate on what exactly goes wrong? Error text?
According to this article - support.google.com/looker-studio/answer/7288010#zippy=%2Cin-this-article, 16 version is not supported rn. It seems like it is a known issue on forums.
If besides Postgres you have any sort of DWH like BigQuery, then you may setup an ETL/ELT to ingest data from Postgres to BigQuery and, then, connect BigQuery to Looker Studio.
@@stan_visualytics Thanks for reply.