Forum Discussion
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...
Its a late reply, but it may help some body else, you can use openquery. Follwoing syntax will work with both import data and direct query
SELECT *
FROM OPENQUERY ([server name],
'EXEC dbname.dbo.spname @parametername = ''R1''');
nirajdubey Thank you. I succeeded in using the SP by OpenQuery as you introduced.