I'm setting up an excel reporting using Excel 2013 for that.

The spreadsheet is retrieving data, through an odbc connection that I need to set on every computer in order to retrieve the data.

I tried to change the following:

Data > Query > Change the property of the connection chain

This is the connection string


Is there a way to remove the DSN=BI_AZURE and put a static string, that won't use the DSN and yet will be able to connect the reporting, to any machine, regardless if the odbc connection is existing?



1 Answer 1


You want to make sure you have an existing odbc driver in order to do this.

And tick the following box (mind the french system language) enter image description here

Change your code with the following:

DRIVER={PostgreSQL UNICODE};DATABASE=dw;SERVER=mydb.postgres.database.azure.com;PORT=5432;UID=sqladmin@username;

And everything should be working.

Connection string source

Helpful source

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .