Power Bi / Looker Stuido Conection
Good afternoon, has anyone tried to create a Twenty dashboard by connecting Power BI or Looker Studio directly to the application's database? I'm not able to make this connection.. 😢
3 Replies
You should be able to connect it to the postgres db, but if you are running it on docker, you will have to tweak the db container settings and db settings to allow outside connections. In that case also make sure you properly configure firewalls and use a good password :)
I'm confused on why you want to connect it to PowerBi though, do you want to use it to create graphs based on the twenty data?
@gazzoni : I had the same issue - my motivation was that I wanted to create an app in Teams that made some simple reports from the sales team to management.
Here's what I had to do to access the database from outside:
1) In the docker-compose.yaml file, you need to add a port mapping under the db: section, for instance under volumes:
ports:
- "5432:5432"
2) Rebuild the docker container for the db
3) Inside the twenty-db-1 docker container, you need to edit /var/lib/postgresql/data/pg_hba.conf and add a line like
host all all 0.0.0.0/32 md5
under # IPv4 local connections - you may want to change the IP range for additional security.
4) Restart the db docker container.
Then you should be able to access the database using the postgres user and the password that you find in the .env file.
no dont point it to the DB directly the fastest way to do it is via the API.
I got mine up and running in about 5 min via the API