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

[HassanAshas]

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. 

However, we are able to retrieve the data using REST API in our Power BI. So, what I am trying to find out that is it in any way possible to send the data into SQL Server from Power Query or Power BI? 
I had an idea that we could maybe call a Stored Procedure from Power BI that would send the complete data from Power BI into a Table in SQL Server. 

Can anyone guide regarding this? Thank you. 

[amitchandak]

@HassanAshas , 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-...

Power automate

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