Connect Microsoft Power BI to Exact Online

(Self-answered)

The typical connection string for Exact Online XML and REST APIs would be:

provider=ExactOnlineAll;apiUrl=https://start.exactonline.nl;

Please replace '.nl' by the Exact Online country of the data center, such as '.co.uk' for United Kingdom and '.es' for Spain.

The provider attribute specifies the backend driver.

You can also use databases built up using multiple globally separated data containers using settings.xml. In that case you will need to manually configure settings.xml and then refer to the group and database name instead of the provider:

database=GROUP\DATABASE

And all connections, whether from Visual Studio, Telerik or Power BI, can use:

User ID

log on code to use.

Password

password.

loggingFileName=PATH\FILENAME

specify log file location. Activated when specified.

licensefile=PATH\FILENAME

specify location of file with license key.

All other connection string attributes and their values are forwarded to the master provider chosen. For example, xml-directories=c:\temp;d:\temp forwards to the XML file provider.