cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sajal161292 Member
Member

how to execute a stored procedure in Power BI desktop file

Need help in creating a button in power bi that should perform the action of truncating a table in Power BI desktop file.

I am using the DirectQuery mode and trying to execute a stored procedure for truncating the data but with no success in it till now.

 

Please help me with your inputs for it.

1 REPLY 1
Community Support Team
Community Support Team

Re: how to execute a stored procedure in Power BI desktop file

Hi @sajal161292,

 

You may have a reference to the similar post below that makes use of OPENROWSET.

 

Calling SQL stored procedure with Direct Query

 

Best  Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.