Skip to content
Start free
Start free
Explore

Try CrateDB Live

Connecting CrateDB to Power BI
  • 1. Choose Scenario
  • 2. Get Ready
  • 3. Run CrateDB
  • 4. Import Data
  • 5. Explore Queries
  • 6. More Queries
  • 7. Connect
  • 8. Next Steps

You can connect Power BI to CrateDB via the PostgreSQL connector.

Steps:

  1. Select PostgreSQL as a data source
  2. Enter
    • Host: <your-host>
    • Port: 5432
    • Database: demo
  3. Authenticate using your credentials

Once connected, you can:

  • Explore your dataset visually
  • Build dashboards with geospatial and time-series data
  • Use Power BI’s drag-and-drop interface for analysis