Forum Discussion

Analitika's avatar
Analitika
Post Prodigy
5 years ago

DataSource.Error: Sybase SQL Anywhere: Integrated login failed in Power BI

Hi,   I would like to ask how I could solve this issue? Whenever I am trying to refresh report in Power BI, I am getting this  DataSource.Error: Sybase SQL Anywhere: Integrated login failed Deta...
Need Help
v-luwang-msft's avatar
v-luwang-msft
Community Support
4 years ago

Hi  Analitika ,

If you are connecting the data base by Sybase database in Desktop, there are some prerequisites for SAP Sybase SQL Anywhere. "This connector requires one or more additional components to be installed before it can be used. "If you have configured ODBC for Sybase, you can use ODBC connector in Desktop to connect data source. And you need make sure the server name and database name correct.

You can check against the prerequisites.

 

Best Regards

Lucien

Analitika's avatar
Analitika
Post Prodigy
4 years ago

Still not works getting syntax error - 

Also this: DataSource.Error: ODBC: ERROR [42601] ERROR: syntax error at or near "[";.  Error while executing the query. 

  • Analitika's avatar
    Analitika
    Post Prodigy
    4 years ago

    Hello,

     

    My report is based on Sybase Anywhere but I also need connect to PostgreSQL. How to achieve this? Because I am still getting this error message:

    And also:

     

    OLE DB or ODBC error: [DataSource.Error] Sybase SQL Anywhere: Connection error: Connection was dropped (may not be a SQL Anywhere server) .

     

    How to solve these issues and properly use Sybase Anywhere and PostgreSQL at the same time in same report in Power BI?

    • Analitika's avatar
      Analitika
      Post Prodigy
      4 years ago

      Hello,

       

      I am getting error OLE DB or ODBC error: [DataSource.Error] Sybase SQL Anywhere: Connection error: Connection was dropped (may not be a SQL Anywhere server) . An unexpected exception occurred.

       

      This happens when I am trying to refresh the report in Power BI. So how to resolve this?

      • Analitika's avatar
        Analitika
        Post Prodigy
        4 years ago

        I am also connected it via ODBC 

        But when refreshing is run I am getting:

        OLE DB or ODBC error: [DataSource.Error] Sybase SQL Anywhere: Connection error: Connection was dropped (may not be a SQL Anywhere server) . An unexpected exception occurred.

         

        So how to resolve that issue?

         

    • Analitika's avatar
      Analitika
      Post Prodigy
      4 years ago

      Hello, 

       

      How to resolve this issue? 

       

      I was entered in advanced editor but didn;t find errors in pane.