Loading blocked by failures with other queries.

[Analitika]

Hello,

I have tried make refresh in Power BI desktop report. But it lead to this error:

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

I have tried change database credentials it worked just part of tables in dataset. Also tried clear global permissions, also cleaned cache but it not helped in report refreshing.

[v-eqin-msft]

Hi @Analitika ,

Could you tell me if my post helps you a little? If it is, kindly Accept it as the solution to make the thread closed. More people will benefit from it.Hope to hear from you‌‌😀

Best Regards,
Eyelyn Qin

[v-eqin-msft]

Hi @Analitika ,

As the document said, the probable cause is that you may not have a system account on the server machine.

The login_mode database option accepts the following values:

• Standard   Standard logins are permitted. This is the default setting. Standard connection logins must supply both a user ID and password, and do not use the Integrated or Kerberos connection parameters. An error occurs if an Integrated or Kerberos login connection is attempted.

• Integrated   Integrated logins are permitted.

• Kerberos   Kerberos logins are permitted.

• CloudAdmin   This login mode is for internal use by the cloud.

For more information, please refer to:

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.sqlanywhere.12.0.1/dbadmin/da-dbc...

https://foxtrot.mgras.net/static/Documentation/SYBSsa50/00000103.htm

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