Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Pass two params from embedded report , to powerbi , to Azure-SQL stored proc.

I need to pass two params from embedded report , to powerbi , to Azure-SQL stored proc.

 

Problem:   I have a report that runs a query upon every request.  The query takes too long to generate the dataset.   The webpage with the embedded report times outs.    The dataset is retrieved, then filtered.

 

Basically, rather than retrieving the entire dataset, I want to call a stored proc to get the one row of data.  

I want to pass parameters from the webApp, to PowerBI that calls a stored procedure that retrieves desired data.

 

Thanks,

Michael

 

 

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    ...bump...