I have a requirement to migrate the legacy reporting application to Azure Embedded Power BI.
The existing flow is .net web application takes input from user and it will call to stored procedures accordingly those resided in SQL server and it returns the data and displays in UI.
I need to migrate this to Azure embedded power BI reporting tool. Here embedded power BI should fetch data from the existing SQL server by calling the stored procedures.
Now my question is, if we integrate Embedded power BI to some azure webapplication then can we call stored procedure directly from embedded power BI and generate reports?
Thank you in Advance.