Power BI

Microsoft Power BI connects to ArcadeDB via its PostgreSQL connector.

Setup

  1. In Power BI Desktop, click Get Data > More…​ > Database > PostgreSQL database.

  2. Click Connect.

  3. Enter the connection details:

    Server

    localhost:5432 (include the port)

    Database

    Your ArcadeDB database name

    Data Connectivity mode

    Import (recommended)

  4. When prompted for credentials, select Database and enter your ArcadeDB username and password.

  5. If prompted about encryption, choose to connect without encryption.

Usage

For custom queries, use the Advanced options in the connection dialog:

  1. In the SQL statement field, enter your query:

    SELECT name, age, city FROM Person LIMIT 1000

  2. Click OK.

Graph traversals and Cypher via language prefix:

SELECT name, out('FriendOf').size() AS friendCount FROM Person WHERE age > 25
{cypher}MATCH (p:Person)-[:FRIEND_OF]->(f:Person)
RETURN p.name AS person, f.name AS friend, p.city AS city

After loading data, build visualizations by dragging fields from the Fields panel. For graph/network visualizations, install a custom visual from AppSource (e.g., "Network Graph by Powerviz").

Use Import mode instead of DirectQuery. DirectQuery works for basic queries but may have issues with complex types or ArcadeDB-specific SQL extensions.

Known Limitations

  • DirectQuery mode may not work reliably for all query types - Import mode is recommended

  • The Navigator dialog may show incomplete or no tables - use native SQL queries instead

  • Language prefixes work in the SQL statement field but not through the visual query builder

  • No built-in graph/network visualization - requires a marketplace custom visual

  • SSL is not supported - connections must be unencrypted

  • Refreshing data in Power BI Service requires a gateway configured for PostgreSQL connections