Forum Discussion
Cannot execute a stored procedure
If the stored proc provides the data you need, I would get permissions added to the account that is going to be refreshing the data. If that's going to be a service principal, you may need execute access added to your account, at least temporarily, while you are developing.
It sounds like your account doesn't have EXECUTE permission on the database.
Have you tried executing the stored procedure in SSMS/Azure Data Studio?
I suspect you'll get the same error.
You'll need to get your DBA to alter your permissions.
I think your are correct, as I am trying to convert an SSRS report to PowerBI and think the SSRS was running under a service account, where I am running under my windows login assigned to a AD-Group which has certain permissions.
I can run views though or copy/paste the sql from the stored procedure and that works.
If the stored proc provides the data you need, I would get permissions added to the account that is going to be refreshing the data. If that's going to be a service principal, you may need execute access added to your account, at least temporarily, while you are developing.
