Forum Discussion

eferreira's avatar
eferreira
New Member
10 years ago

Use SQL Store Procedure in Power BI

I have created a basic stored procedure without parameters in SQL Server, when I use the store procedure in Power Bi Desktop the return is ok in design but when I click on Save and Close in datasourc...
dsilveira's avatar
dsilveira
Advocate I
9 years ago

@radz  

Hi, I had the same problem and found a way to use the parameters

 

DECLARE @sqlCommand varchar(1000)
SET @sqlCommand = 'sp_name'
EXEC @sqlCommand @Parameter1= 39, @Parameter2= 'myString', @Parameter3 = 'myString2'

I hope it helps somebody.

 

Regards.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

dsilveira Nice! Thanks for sharing.