Power BI Web connector for ArangoDB

This is an example Power BI connector for ArangoDB.

Installation

The PowerBI connector can be installed as a Foxx service using the ArangoDB web interface or the Foxx CLI:

$ npm install --global foxx-cli
$ foxx install -u root -P -H http://localhost:8529 -D _system /powerbi \
https://github.com/arangodb-foxx/powerbi-connector/archive/master.zip

# or without installing foxx-cli:

$ npx foxx-cli install -u root -P -H http://localhost:8529 -D _system /powerbi \
https://github.com/arangodb-foxx/powerbi-connector/archive/master.zip

Configuration

Before you can use the ArangoDB connector in Power BI you need to configure the service using the web interface or the Foxx CLI.

To configure the service in the ArangoDB web interface, open the service details and then navigate to the Settings tab in the top bar.

• collections: list of names of collections that will be exposed to Power BI, as a comma-separated list, e.g. payments,timeouts will expose the collections payments and timeouts in the database the service was installed.

• username and password: credentials that will be used by Power BI to authenticate against this service.

  Note: These credentials will only be used by Power BI and should not match the ArangoDB user credentials used to access ArangoDB itself.

Adding the data source

To add the connector as a data source in Power BI, open the Get Data dialog and select the Other > Web data source.

Set URL to the URL of the service followed by the name of the collection you wish to import, e.g. http://localhost:8529/_db/_system/powerbi/timeouts.

When prompted for authentication, set the authentication mechanism to Basic and use the credentials from the service configuration.

License

This code is licensed under the Apache License, Version 2.0.