ODBC Sybase connection in Power BI

[Analitika]

Hello,

How to write odbc query for Sybase without giving DSN name, like providing a path of excel file getting database name from column?

[Anonymous]

Hi @Analitika ,

This tutorial explores how to connect to ASE and import data into Power BI Desktop using an ODBC driver. It is assumed that you have already installed and configured a DSN for ODBC driver for ASE.

1. Run Power BI Desktop and click Get Data.
2. Select the Other category in the Get Data dialog box, then select ODBC. Click Connect to confirm the choice.
3. In the From ODBC dialog box, expand the Data Source Name (DSN) drop-down list and select the previously configured DSN for ASE
4. If you would like to enter a SQL statement to narrow down the returned results, click the Advanced options arrow, which expands the dialog box, and type or paste your SQL statement.
5. Click OK. If your data source is password-protected, Power BI will prompt you for user credentials. Type your Username and Password in the respective fields and click.
6. Now you should see the data structures in your data source. You can preview the contents of the database objects by clicking on them.
7. To load the ASE data into Power BI for analysis, select the needed table and click Load.

Reference: Importing ASE Data into Power BI Through an ODBC Connection

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

ODBC DSN and connection string keywords - ODBC Driver for SQL Server | Microsoft Docs

Pretty sure Sybase have a similar document.

Good luck - this field has a character limit that you will likely hit quickly at which point you have to revert back to the dsn= format.