Skip to main content
Connect your Hardal analytics data to Microsoft Power BI to create comprehensive business intelligence dashboards and reports.
Get your database credentials from SettingsDatabase in your Hardal dashboard.

Get Connection Credentials

1

Access Database Settings

  1. Log into your Hardal dashboard
  2. Select your Signal from the project list
  3. Go to SettingsDatabase
  4. Copy your connection details
You now have the credentials needed for Power BI integration.

Connect to Power BI

1

Open Power BI Desktop

  1. Launch Power BI Desktop
  2. Click Get Data on the Home ribbon
  3. Search for and select MySQL database
  4. Click Connect
2

Configure Database Connection

Enter your Hardal database credentials:
  • Server: [from your database settings]
  • Database: [from your database settings]
Click OK, then enter authentication details:
  • User name: [from your database settings]
  • Password: [from your database settings]
Ensure your database credentials are stored securely and access is limited to authorized personnel.
3

Select and Load Data

  1. Choose the Hardal tables you want to import
  2. Click Load to import the data directly, or Transform Data to modify it first
  3. Wait for the data import to complete
Your Hardal data is now available for creating reports and visualizations.

Next Steps

Once connected, you can:
  • Design interactive reports with drag-and-drop visuals
  • Create automated refresh schedules in Power BI Service
  • Share dashboards with stakeholders across your organization
  • Integrate with other Microsoft 365 applications