Forum Discussion

Anonymous

Not applicable

3 years ago

Is it possible to Invoke a Stored Procedure in SQL Server from within Power BI to store data in SQL?

Hi, my data source is coming from Microsoft Dynamics using a REST API. For some reason, it is not possible to call REST API within our SQL Server where our Database is currently stored. How...

Need Help

amitchandak

Super User

3 years ago

Anonymous , to send the data back, you have consider power app or power automate

Power App - https://www.youtube.com/watch?v=LxuRzj0X348

https://visualbi.com/blogs/microsoft/powerbi/write-back-into-sql-database-using-power-bi-with-power-apps/

Power automate

https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-automate-visual?tabs=powerbi-desktop

Forum Discussion

Is it possible to Invoke a Stored Procedure in SQL Server from within Power BI to store data in SQL?

Related content

Invoke Pipeline vs Invoke Pipeline (Legacy)

Invoke Pipeline

Stored Procedure to Manipulate Tables

Invoke pipeline error

Invoke Pipeline Performance