Does a user need to have Admin rights to the SSAS server to successfully schedule a refresh on a snapshot of this data? The user is an admin to the tabular model but not the server itself and they get this kind of error
"detail":{"type":1,"value":"AnalysisServices:
The '[email protected]' value of the 'EffectiveUserName' XML for Analysis property is not valid."}},Seems odd to me that they have to be admins to the server to schedule this. The gateway connects with no issues but fails on the authentication when refreshing (whether on schedule or on demand).
5 Comments
Hi mmheath
What do you mean by scheduled refresh the data from SSAS? Your data source is SSAS, then you create a report to upload to the Service and refresh that report on the Service right?
If that's the case, you can refresh the report on Service as long as you have read access to SSAS, but the credential you enter when you create the gateway needs to be the account of SSAS admin to work.
Best Regards,
Community Support Team _ Ailsa TaoSo if the developer of the report is setup as a admin to the tabular model then it still will not work since she is not an admin to the SSAS server? Did I get this correctly. Which would mean that the SSAS Server admin would need to own the gateway connections for this source if this is a correct statement.
Hi mmheath
Yes, you will also need administrative access to the gateway. Those permissions are managed elsewhere, independent of workspace roles and permissions. For details, see Manage an on-premises gateway.
Best Regards,
Community Support Team _ Ailsa TaoThank you for the reply and completely undertand about being an admin to the Gateway. The point above that is puzzling is the requirement to be an Admin on the SSAS Server itself. You would think that being a admin to the connection on the gateway and read access to the tabluar model would suffice. This does work for other connections such as a simple SQL tabular database. But for SSAS, it sounds like the only people that can setup the gateway connection is the SSAS Server admin. However, in the real world, the SSAS Server admin is not the one develping and maintaining gatewaway connections on the PBI Service - the report developer is. So from what I am reading here, for any SSAS connections the SSAS Server admins have to jump into this report developer space which is not generally their job description or responsibility.
I agree with mmheath. Why would a Tabular Server Admin need to be involved in such a way? Also, it is strange that a "Live" SSAS connection through the Gateway does NOT require the Tabular Server Admin's involvement while an "Import" SSAS connection does.
