Connecting multiple databases to a Power BI dashboard

Add more than one database to a Power BI report.

By design, the Geotab Data Connector connects to a single database using a single set of credentials. Use the following procedure to connect up to seven databases to the same Power BI dashboard. If you need to connect a larger number of databases, use multistreaming instead.

Important:

Before you begin, make sure the Geotab Data Connector is enabled in each database you want to connect. For more information, see Data Connector requirements.

  1. Create a new OData feed connection in Power BI, using the access URL for your database's jurisdiction.

    If you don't know your database's jurisdiction, use a Redirection Service URL instead. For the full list of URLs, see Data Connector jurisdiction URLs.

  2. Select the LatestVehicleMetadata table and load it into the dashboard.

    Rename the table to LatestVehicleMetadata-1.

  3. Enter your credentials for this database when prompted.

    Use the username and password format described in Finding your Data Connector access URL.

  4. Repeat the previous three steps for each additional database, using a different access URL each time.
    Important:

    Each credential must be tied to one URL only. If you reuse a URL for a different database, the credential for that database is replaced.

  5. Go to the Transform Data section in Power BI.
  6. Select your second database's table, for example LatestVehicleMetadata-2, in the Queries pane.
  7. Insert a step after Source in the Applied Steps pane.
  8. With the new step selected, click Combine, then Append Queries.
  9. Select the table from your first database, for example LatestVehicleMetadata-1, as the table to append to.

    LatestVehicleMetadata-1 now includes data from both databases. Use the CompanyGUID field to tell the data from each database apart.

Repeat this process for each remaining database. If you use one of Geotab's ready-made templates, the tables already included in the template's data model must be the first table that every other table is appended to.

Important:

The Geotab Data Connector is available in seven jurisdictions, each with its own access URL. For the full list, see Data Connector jurisdiction URLs.

Data Connector jurisdiction URLs

Find the Data Connector URL for your area.

Each Data Connector jurisdiction has its own OData Connector URL, used to connect to a specific set of databases. You can also use a Redirection Service URL, which works for any jurisdiction without specifying an OData Connector URL directly.

Tip:

If you don't know your database's jurisdiction, use a Redirection Service URL instead of an OData Connector URL.

OData Connector URLs

JurisdictionOData Connector URL

EU

https://odata-connector-1.geotab.com/odata/v4/svc/

EU

https://odata-connector-eu-1.geotab.com/odata/v4/svc/

EU

https://odata-connector-eu-2.geotab.com/odata/v4/svc/

EU

https://odata-connector-eu-3.geotab.com/odata/v4/svc/

EU

https://odata-connector-eu-4.geotab.com/odata/v4/svc/

EU

https://odata-connector-eu-5.geotab.com/odata/v4/svc/

EU

https://odata-connector-eu-6.geotab.com/odata/v4/svc/

US

https://odata-connector-2.geotab.com/odata/v4/svc/

US

https://odata-connector-us-1.geotab.com/odata/v4/svc/

US

https://odata-connector-us-2.geotab.com/odata/v4/svc/

US

https://odata-connector-us-3.geotab.com/odata/v4/svc/

US

https://odata-connector-us-4.geotab.com/odata/v4/svc/

US

https://odata-connector-us-5.geotab.com/odata/v4/svc/

US

https://odata-connector-us-6.geotab.com/odata/v4/svc/

USGOV

https://odata-connector-7.geotab.com/odata/v4/svc/

USGOV

https://odata-connector-usgov-1.geotab.com/odata/v4/svc/

USGOV

https://odata-connector-usgov-2.geotab.com/odata/v4/svc/

USGOV

https://odata-connector-usgov-3.geotab.com/odata/v4/svc/

USGOV

https://odata-connector-usgov-4.geotab.com/odata/v4/svc/

USGOV

https://odata-connector-usgov-5.geotab.com/odata/v4/svc/

USGOV

https://odata-connector-usgov-6.geotab.com/odata/v4/svc/

CA

https://odata-connector-3.geotab.com/odata/v4/svc/

CA

https://odata-connector-ca-1.geotab.com/odata/v4/svc/

CA

https://odata-connector-ca-2.geotab.com/odata/v4/svc/

CA

https://odata-connector-ca-3.geotab.com/odata/v4/svc/

CA

https://odata-connector-ca-4.geotab.com/odata/v4/svc/

CA

https://odata-connector-ca-5.geotab.com/odata/v4/svc/

CA

https://odata-connector-ca-6.geotab.com/odata/v4/svc/

AU

https://odata-connector-6.geotab.com/odata/v4/svc/

AU

https://odata-connector-au-1.geotab.com/odata/v4/svc/

AU

https://odata-connector-au-2.geotab.com/odata/v4/svc/

AU

https://odata-connector-au-3.geotab.com/odata/v4/svc/

AU

https://odata-connector-au-4.geotab.com/odata/v4/svc/

AU

https://odata-connector-au-5.geotab.com/odata/v4/svc/

AU

https://odata-connector-au-6.geotab.com/odata/v4/svc/

BR

https://odata-connector-4.geotab.com/odata/v4/svc/

BR

https://odata-connector-br-1.geotab.com/odata/v4/svc/

BR

https://odata-connector-br-2.geotab.com/odata/v4/svc/

BR

https://odata-connector-br-3.geotab.com/odata/v4/svc/

BR

https://odata-connector-br-4.geotab.com/odata/v4/svc/

BR

https://odata-connector-br-5.geotab.com/odata/v4/svc/

BR

https://odata-connector-br-6.geotab.com/odata/v4/svc/

AS

https://odata-connector-5.geotab.com/odata/v4/svc/

AS

https://odata-connector-as-1.geotab.com/odata/v4/svc/

AS

https://odata-connector-as-2.geotab.com/odata/v4/svc/

AS

https://odata-connector-as-3.geotab.com/odata/v4/svc/

AS

https://odata-connector-as-4.geotab.com/odata/v4/svc/

AS

https://odata-connector-as-5.geotab.com/odata/v4/svc/

AS

https://odata-connector-as-6.geotab.com/odata/v4/svc/

Redirection Service URL

JurisdictionRedirection Service URL

Any jurisdiction

https://data-connector.geotab.com/odata/v4/svc/

Any jurisdiction

https://data-connector-1.geotab.com/odata/v4/svc/

Any jurisdiction

https://data-connector-2.geotab.com/odata/v4/svc/

Any jurisdiction

https://data-connector-3.geotab.com/odata/v4/svc/

Any jurisdiction

https://data-connector-4.geotab.com/odata/v4/svc/

Any jurisdiction

https://data-connector-5.geotab.com/odata/v4/svc/

Any jurisdiction

https://data-connector-6.geotab.com/odata/v4/svc/