Forum Discussion
Data Update on SQL Server using a PowerBI Enterprise Gateway
Anonymous Have you tried dynamically generating the parameters in the stored procedure so you don't have to hardcode them?
For instance. Build a calling sproc that handles the hardcoded parameters or dynamically generate them in Sproc 1, and have sproc 1 call sproc 2.
A psuedo code example:
CREATE PROCEDURE dbo.RunExcelActividadesPrevisaoFaturacao
as
declare @begindate date = begindate
declare @enddate date = enddate
declare @query int = 5
Execute dbo.ExcelActividadesPrevisãoFaturação @begindate, @enddate, @query
Did you get this fixed at all? I'm getting exactly the same issue at my end.
Thanks.
No! Not yet. I think the problem is executing a SQL stored procedure with paramenters :(
Anonymous Have you tried dynamically generating the parameters in the stored procedure so you don't have to hardcode them?
For instance. Build a calling sproc that handles the hardcoded parameters or dynamically generate them in Sproc 1, and have sproc 1 call sproc 2.
A psuedo code example:
CREATE PROCEDURE dbo.RunExcelActividadesPrevisaoFaturacao
as
declare @begindate date = begindate
declare @enddate date = enddate
declare @query int = 5
Execute dbo.ExcelActividadesPrevisãoFaturação @begindate, @enddate, @query
Thanks, That's a good workaround, hardcoded is limited but its a way to solve it! As you can understand I would like that the Enterprise Gateway had the same behavior as the Personal, accpting the call of a SQL stored procedure with parameters.
Thanks again