Forum Discussion
Embed a button on Power BI desktop application to execute stored procedure
In our Power BI report we are using a table/view which is refreshed by a stored procedure. Inorder to update data, user need to execute stored procedure manually and then load the report.
Is it possible to integrate button (or any other control) in Power BI desktop application and execute the stored procedure on click of that button?
OR
Is there any other possible way to execute the stored procedure from power bi desktop application?
SFerro wrote:
In our Power BI report we are using a table/view which is refreshed by a stored procedure. Inorder to update data, user need to execute stored procedure manually and then load the report.
Is it possible to integrate button (or any other control) in Power BI desktop application and execute the stored procedure on click of that button?
OR
Is there any other possible way to execute the stored procedure from power bi desktop application?
Power BI only cares the table/view connected in your case. As to updating work on the table/view with a stored procedure or any other approaches, in my opinion, it is out of the scope of Power BI.
Technically you can call the stored procedure before getting data from a table by specifying certain SQL statements when getting data in Import Mode. The downside would be, if the updating stored procedure running for long, then you just get forever spinning when refreshing data.
So I'd suggest you schdule an external SQL agent Job to run the stored procedure in certain interval(5,10 minutes or whatever fit for your bussiness) to update the connected table. In Power BI, just connect to that table, no more updating work.
1 Reply
Eric_ZhangMicrosoft Employee
SFerro wrote:
In our Power BI report we are using a table/view which is refreshed by a stored procedure. Inorder to update data, user need to execute stored procedure manually and then load the report.
Is it possible to integrate button (or any other control) in Power BI desktop application and execute the stored procedure on click of that button?
OR
Is there any other possible way to execute the stored procedure from power bi desktop application?
Power BI only cares the table/view connected in your case. As to updating work on the table/view with a stored procedure or any other approaches, in my opinion, it is out of the scope of Power BI.
Technically you can call the stored procedure before getting data from a table by specifying certain SQL statements when getting data in Import Mode. The downside would be, if the updating stored procedure running for long, then you just get forever spinning when refreshing data.
So I'd suggest you schdule an external SQL agent Job to run the stored procedure in certain interval(5,10 minutes or whatever fit for your bussiness) to update the connected table. In Power BI, just connect to that table, no more updating work.