How can I call a stored procedure in SQL Statement

[akosiRandy]

In Ssrs, we can call a stored procedure with dynamic parameters,

EXEC usp_Client_Day @Start, @End, @MainCLient, @Client, 'CS,COS','NPG'

Quetion? How do you call a stored procedure with dynamic parameters in powerbi sql statement similar to the above code?

[Idrissshatila]

Hello @akosiRandy ,

Power bi doesn't support stored procedures, you must create it as a view and then connect to it through Power BI.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea 💡

[akosiRandy · Accepted solution]

Thanks. I guess by default i should just create the data range parameter within sql statement and create the other parameters in powerbi visual.

[ThxAlot]

= Value.NativeQuery( Sql.Database("SqlSvr", "db"), "EXEC usp_Client_Day", {@Start, @End, @MainCLient, @Client, "'CS,COS'","'NPG'"} )

[akosiRandy]

Thanks. Do you enter that code in SQL Statement dialog?

[marcelsmaglhaes]

Hey @akosiRandy 
Take a look into this link: Power BI. Execute SQL Server stored procedure with a user parameter - Stack Overflow

Regards,
Marcel

[foodd]

SQL Stored Procedure With Dynamic Parameter In Power BI Service by TAIK18