Connecting Power BI

Before connecting, complete the SSH tunnel and PostgreSQL ODBC driver setup in Instructions for Direct Database Integration.

Connecting Power BI to Mosaic Data via SSH Tunnel

  1. Launch Power BI and navigate to Report > Get Data > ODBC.
  1. Select your ODBC connection (e.g., Mosaic DDI).
  1. Enter the database Username and Password, and click "Connect".
  1. Proceed to import and utilize your data as needed.