Connect Microsoft Power BI to Exact Online

What connection string should I use to connect to Exact Online from Microsoft Power BI using Invantive SQL?

0
edit delete
are you sure?
asked Guido Leenders

1 answer

(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.

1
edit delete
are you sure?
answered Guido Leenders

Post an answer but please log in first

Post Answer
  1. Please log in to post answer

Similar Questions

Tagsfor this question

Forumall questions