Integration with business intelligence applications
      Back to home
      1. Knowledgebase & Help Center
      2. ChiliDataWarehouse®
      3. Integration with business intelligence applications

      📈 Integration with PowerBI

      This guide explains how to connect ChiliDataWarehouse to PowerBI to create insightful reports and dashboards.

      1. Establishing the Connection
        Open PowerBI Desktop and select “Get Data” → “SQL Server Database”.
        Enter the server name (e.g., dataconnection.chili.ch) and the name of the database.
      2. Authentication
        Use the login credentials contained in the Connection String.
      3. Data Import and Analysis
        Review the data preview, load the required tables, and create visualizations.

      Important: If the Connection String is regenerated in the backend, you must update the connection in PowerBI immediately.