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: Dat...
Need Help
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.

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

        Analitika , Clear Permission.  Clear cache from option and setting. Save file without new credentials. means with clear permission. Close all power bi instance. Open the file again. Provide credentials and check.

         

        Also check if this issue is because on August 2021, then log a new issue - https://community.powerbi.com/t5/Issues/idb-p/Issues