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...
Anonymous's avatar
Anonymous
Not applicable
10 years ago

stangellapallyeferreiranirajdubeyasocorro As a follow up to my previous post, i was testing this further due to another thread, and have discovered that you don't need to change any database settings or use OpenQuery. If you wrap your stored procedure in a variable you can import the data using a sproc (Doesn't work in Direct Query, only import)

 

example:

 

DECLARE @sqlCommand varchar(1000)

SET @sqlCommand = 'dbo.Testproc'
EXEC (@sqlCommand)

premjitsaha's avatar
premjitsaha
Frequent Visitor
9 years ago

How to use it if SQl stored procedure has a parameter?

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    premjitsaha Use dsilveira's solution above... Is there a different scenario you have in which it isn't working?

    • premjitsaha's avatar
      premjitsaha
      Frequent Visitor
      9 years ago

      thanks it worked