Forum Discussion

EaglesTony's avatar
EaglesTony
Icon for Post Prodigy rankPost Prodigy
1 year ago
Solved

Cannot execute a stored procedure

Hi,     I have a stored procedure RPT.MarketValue.     When I go to Get the SQLServer data, I enter the server, the database and Import and put "EXEC  RPT.MarketValue" , but it gives me the error...
Need Help
  • KNP's avatar
    KNP
    1 year ago

    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.

     

EaglesTony's avatar
EaglesTony
Icon for Post Prodigy rankPost Prodigy
1 year ago

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.

KNP's avatar
KNP
Icon for Super User rankSuper User
1 year ago

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.