Forum Discussion
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...
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.
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
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.