Execute permissions denied on Stored Procedure connection

[Anonymous]

Hi, 

         if I get data from SSMS(SQL Server Analysis Service), can I call stored procedures from connect live model? Thanks!

[v-yuta-msft · Accepted solution]

@Anonymous ,

No, you can not implement stored procedure when connecting to SSAS. You can only input DAX/MDX query when connecting to SSAS in import mode, but you can't even input any DAX/MDX query in live connection mode.

 

Community Support Team _ Jimmy Tao

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