Problem to connect Sybase ODBC driver

[tlamoureux]

Hello,

I'm trying to migrate Qlik Sense report to PowerBI and I have a problem to access to the ODBC Driver.

I use the 64 bit driver provided by Devart. This driver works well with Qlik Sense.

I've no problem to connect to the ODBC source but, I see the databases, tables but when PowerBI tried to browse the content of a table I have the following message :

DataSource.Error : ODBC: ERROR [HY000] [Devart][ODBC][Adaptive Server Enterprise]Incorrect syntax near the keyword 'FOR'.

Détails :
    DataSourceKind=Odbc
    DataSourcePath=dsn=Topaze64
    OdbcErrors=[Table]

Here is what I have in the Advanced editor :

let
    Source = Odbc.DataSource("dsn=Topaze64", [HierarchicalNavigation=true]),
    Diamant_Database = Source{[Name="Diamant",Kind="Database"]}[Data],
    dbo_Schema = Diamant_Database{[Name="dbo",Kind="Schema"]}[Data],
    SAM_SAVMAB_Table = dbo_Schema{[Name="SAM_SAVMAB",Kind="Table"]}[Data]
in
    SAM_SAVMAB_Table

This is mandatory for me to go further in my migration.

Thank you very much for you help.

Regards,
Thierry

[apentyala]

Dear,

Try to connect the Sybase directory from Power BI and access the tables?? The Sybase client is instead?

Regards,

[tlamoureux]

I did not use the sybase client because I seems not to work with my sybase ASE database.

So I try to use direct ODBC driver. I have the 32bits version with works with PowerBI 32bits. Because I wanted to use PowerBI 64bits (the 32bits version crashes all the time...) I tried the 64bits driver version provided by Devart.

This driver works well with QlikSense but not with powerBI. I can browse databases and table name but not table content.

[Anonymous]

you solved it?