Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

gateway doesn't work with SQL server Stored procedure

The gateway option is greyed out on the Dataset settings window. A stored procedure is used to get the data from SQL server. Data connectivity mode is set as 'Impoort'.   Can anybody help?   than...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    AnonymousAnonymous

     

    Thanks, and it works now. I changed the server of the connection on the desktop to match what is on the list of gateway setting while add the real server in the query.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

AnonymousCould you tell me more about how to setup the datasource in the service to get the SP work? screenshot would be great. Thanks!

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Anonymous Which gateway did you deploy? Are you just executing a stored procedure or are you trying to pass a parameter?

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Anonymouspublic gateway, just a Sp without paramter...

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi Anonymous,

       

      What connection mode you use? If you mean 'direct query', current you can invoke stored procedure in power query, but it not works on direct query mode.

       

      Regards,
      Xiaoxin Sheng

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        AnonymousAnonymous

         

        Thanks, and it works now. I changed the server of the connection on the desktop to match what is on the list of gateway setting while add the real server in the query.