Embedded Database Connection Configuration

Power BI can access the MyQ Embedded Database via ODBC. In order to create an ODBC data source:

Power BI will only let you connect to a ODBC data source that is available on the local PC it is running within. Your data source should be created on the same PC that Power BI desktop run.

1. Download and install the latest ODBC driver for Firebird from:
   https://firebirdsql.org/en/odbc-driver/

2. Once installed, open the ODBC Data Sources application from the Windows Apps menu.

3. Go to the System DSN tab and click Add.

   

4. In the Create New Data Source window, select Firebird/InterBase(r) driver and click Finish.

   

5. In the Firebird ODBC Setup tab, enter the connection details:

   1. Data Source Name (DSN): Add a name as an identifier for the connection

   2. Database: Add the path to your database file (C:\ProgramData\MyQCentral\MYQ.FDB by default)

   3. Client: Add the path to the Firebird library client used for the connection. It is recommenced to use the MyQ Central Server client, found in C:\Program Files\MyQ Central\Firebird\fbclient.dll by default

   4. Database Account: Add the Database Account user name. The default one is SYSDBA, but it is highly recommended not to use the default database account, but create a new database user with limited rights to only read required tables, described in the Database Views Description chapter.

   5. Password: Add the Database Account password. In case you are using the default database account (not recommended) and you haven't changed the password in MyQ Central Easy Config, the default one is masterkey.

   6. The rest of the fields can be left unchanged. Click Test Connection and if successful, click OK.