SQL Server agent job that processes SSAS database gets warning 1092091904

Question

Message
Executed as user: xxxxxx. <return xmlns="urn:schemas-microsoft-com:xml-analysis"><root xmlns="urn:schemas-microsoft-com:xml-analysis:empty"><Messages xmlns="urn:schemas-microsoft-com:xml-analysis:exception"><Warning WarningCode="1092091904" Description="Note. Analysis Server has persisted any security information specified as part of the Connection string portion of the Datsource object definition." Source="Microsoft SQL Server 2017 Analysis Services" HelpFile="" /></Messages></root></return>. The step failed.

Answer 1

Hi,
With this warning message , we could find some similar issue that indicate it is a permission related warning. Check the permission for the user that was mentioned in the message. Make sure it has the processing permission.
See similar thread : Processing tabular model through SQL server agent Jobs

Regards,
Lukas

Answer 2

Any resolution to this? I'm getting the same thing. The account doing the processing...or attempting to, does have process permission.

Answer 3

I found a solution to this problem on a Oracle connection. But in my case the problem was when i tried to refresh a partition of a specific table. The refresh on the table worked perfectly, but on the partitions were problems.

Please check the file Model.bim. Open it in Notepad or Notepad++.

Then please see that the line with the connection string to have

"Persist Security Info=true".

Hope to solve the problems.

Regards,

Silviu