Execute SQL Server Stored Procedure With User Parameter In Power BI

Thanks for sharing above info for connection build. It helps a lot but how to enable users to select dynamic values using slicers?

Hi Dhruvin,

Hi Dhruvin, Thanks

I've created the Parameters and created a test report. Now how I can run for different parameters as well as when I hand over this to Business users in PowerBI Service, will it prompt them to input the parameters when they try to run?

HI Dhruvin, thanks for sharing this article, very informative. Currently I have the same requirement to convert Cognos to PowerBI which has a SP with parameters, will definitely try this out. Can you please help here how we can do Burst in the powerBI service the same way we do in the cognos, Burst to a shared folder.

Hi. Is it possible to run SQL procedure with parametrs - when I click on the controls of the dashboard report in Power BI? I mean when I click differnt controls - procedure gets differnt parameters and run when I click on last button- for expample with name 'Get actual Data'

Can u pls share ur contact number

Hi Bro i have try this once published how to select the from and todate

Thanks for your explanation, Dhruvin Shah. The point is: the real benefit of parameterization would be that slicers on your dashboard change the value of the parameters and fire the stored procedure with new values every time you change them, in directQuery mode. That seems to be pretty complicated in PowerBI.

Can we pass dropdown selected value to a native big query?

Can we pass parameters into the query from a visualization?

Hi Dhruvin, We are showing Power BI report in powerapps portal. Here we pass parameter to a flow where the stored procedure gets executed. But unfortunately dataset is not getting refreshed with new data associated with the parameters. Please help

I followed the same approach, instead 2 inputs, mine is only one input to SP, that too it is a string. But the value which is given at time of invoke only giving the report, if i pass another value via filter it is not getting applied and the report is empty for new values.

Hi Dhruvin, This is JaiRam. The above parameters concept is working fine in Power BI Desktop only. However after publishing the report to Power BI Service or Report Server, i could not find any option asking to pass the parameter values like an SSRS report. Can you please help me on this !! Thank you.

I want to pass two dates and one text to a stored procedure please help me

What does (lf)#(lf)#(lf) #(lf)" this value refer

Hi, Dhruvin After Embedding the report to the application after that I'm unable to see the parameters box on my application.

Hi Dhruvi, I am getting the error in SQL server too. Microsoft SQL: Incorrect syntax near the keyword 'exec'.Incorrect syntax near ')'.

Bonjour, Comment faire pour que l'utilisateur change lui m?me les valeurs de param?tre? Merci par avance

Hi Dhruvin, i am unbale to do this in Oracle data base it shows me the error Details: "Oracle: ORA-00900: invalid SQL statement"

Hi Dhruvin, just wanted to say thanks for putting this together - nice and clear and saved me a lot of time.

Hi Dhruvin, It's one of the best article ever i seen. it's so simple and easy. I have question that how i can make dynamic selection of date? For example I have created startdate and enddate and created the gateway connection. Pulled the data from 1st Feb'19 to 28th Feb'19. Now suppose if i want to pull the data for March month but i don't want give date again. it should take current month date. How can I do this?

Will there be any problem in running native sql server because it shows it can alter database?

Let Source = Sql.Database(MyServer, MyDatabase, [Query="EXEC [dbo].[spEmployeesRead] '" & ActionCode & "', '" & UserID & "', NULL, NULL, NULL, NULL, '" & Alphabet & "'"]) in Source Above is my Stored Procedure in Query Editor its running fine and gettting data as i am passing all parameters dynamically. My Question I have Saved and Publish the Report to Power BI Service and then Open the Report and from File Menu get Embed Code and pass parameters to this Report URL so i can access this from other Applications and that Application will pass the parameter values dynamically but seems like things are not working correctly. Can you check where i am wrong. https://app.powerbi.com/reportEmbed?reportId=341f891b-93f8-490a-9a91-62f12f783e2c&groupId=4791121d-01f2-49ad-99fc-9fa3bab7fc3f&autoAuth=true&filter=MyServer eq 'MSSQLSERVER2017' and MyDatabase eq 'TestDB' and EmployeesList/ActionCode eq '1' and EmployeesList/UserID eq '1' and EmployeesList/Alphabet eq 'All'

Can i pass parameter to procedure directly through URL and return data to power bi ?Let me know if there is any other way to achieve this. Thanks in Advance!!!

How can I pass startdate as firstdate of the year and enddate alway as today's date?

Hi, first of all thanks for the article and step by step info. I have followed your steps and able to get the data however i have a slicer control which acts as a Month dropdown and all the data is being filtered based on the month selection. My question is how do I make sure that the selected Month is also passed to stored procedure ? Or how do I make sure that the selected month value is being passed to parameter?? Please assist. Thanks in advance.

Can we Pass parameter from Any Web Application

Hello, have you found a way to pass the authenticated user?

Is there a way to set the date to today's current date? It seems you can't set vStartDate = DateTime.Date(DateTime.LocalNow()) in the function parameter page easily

I find the blog really helpful Thanks. Is there a way to display store procedure with multiple result set?

I really loved your blog, simple and easy, and i loved the way you run and test the SP as in OLD and NEW, and changing the code line by line (not rushing into it)

This is very informative article.How to add this in webapi

Thanx sir is a very good article , can you help me to connect with web service and pass a parameters