# Connecting the Swarmica database to Power BI / Power Query
# Symptoms

How to connect the Swarmica database to Power BI / Power Query analytics?

# Solution

1.  Set up [replication of the Swarmica database](https://support.swarmica.com/article/ru/1224-kak-nastroit-replikaciyu-bd-swarmica.html)
2.  Connect a new [data source in Power BI / Power Query using the postgresql connector.](https://learn.microsoft.com/ru-ru/power-query/connectors/postgresql)