Forum Discussion

Analitika's avatar
Analitika
Icon for Post Prodigy rankPost Prodigy
5 years ago

Power BI report refreshing

Hello,

 

I am facing with a problem - when I am trying to refresh report Power BI desktop, I am getting this error:

 

DataSource.Error: Sybase SQL Anywhere: Integrated login failed
Details:
DataSourceKind=Sybase
DataSourcePath=182.5.6.70;dbname
Message=Integrated login failed
ErrorCode=-2147467259

That error appears in several dataset tables.

 

I have tried to change a password in data source settings but also not helped. I am sure I am setting a correct password but seems data source settings keeps old incorrect password. I tried to clear global permissions but seems not helpfull. What be solution for this issue?

 

Need Help

14 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    Analitika , Please open power query check any error on a specific table. Or refresh tables one by one and check for errors on the dahboard.

  • Analitika's avatar
    Analitika
    Icon for Post Prodigy rankPost Prodigy
    5 years ago

    I am in power query editor and see tables with errors which I have described below.

     

    I have tried to refresh tables but each of them shows same error: 

    DataSource.Error: Sybase SQL Anywhere: Integrated login failed
    Details:
    DataSourceKind=Sybase
    DataSourcePath=182.5.6.70;dbname
    Message=Integrated login failed
    ErrorCode=-2147467259

    • amitchandak's avatar
      amitchandak
      Icon for Super User rankSuper User
      5 years ago

      Analitika , is it SSO or DB credetitals.

      First of all create a new connection in a new file and check if that is working.

       

      If yes, then clear permission in data source and try again.

       

      If No, check that does the current system can access the server(Ip/VPN issue)

      • Analitika's avatar
        Analitika
        Icon for Post Prodigy rankPost Prodigy
        5 years ago

        It is DB credentials. I have cleared pemissions already and tried to setup a new password (correct). After that I have tried to refresh again but seems error remained.

  • V-lianl-msft's avatar
    V-lianl-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    The Windows integrated login feature allows you to maintain a single user ID and password for operating system and network logins, and database connections. To create an integrated login:

    • Enable the integrated login feature. See Enable the integrated login feature.

    • Create a database user to map the integrated login to (if one does not already exist).

    • Create an integrated login mapping between a Windows user or group profile and an existing database user. The Login Mappings folder in Sybase Central lists all users with integrated login permissions. See Login mappings.

    • Connect from a client application and test the integrated login facility.