Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

Data Update on SQL Server using a PowerBI Enterprise Gateway

We define a source data to a SQL Server on a PowerBI Enterprise Gateway with sucess. But when we try to update the data using the following source data: let     Source = Sql.Database("<SQL server>...
Need Help
  • Anonymous's avatar
    Anonymous
    10 years ago

    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

ankitpatira's avatar
ankitpatira
Icon for Community Champion rankCommunity Champion
10 years ago

Anonymous can you please provide some more information? I am guessing you're trying to update from powerbi desktop if you're using source data because you can't manually type in powerbi.com ? But if you are using powerbi desktop then why you need enterprise gateway? 

 

please provide some more information and then i will be able to help.