Clear and simple. Thank you!

Mesej yang jelas, struktur yang jelas, mudah difahami, terima kasih

My salvation after hours of searching. I was not giving the proper database name so I couldnt connect. Thank you man

Awesome! Thank you for sharing!

I would love to shake your hand for this

Do one more video on parameters how to use in different ways and where to use

Thank you that was great help

Awesome tutorial, straightforward!

Character In the video It's great, I like it a lot $$

This was exactly what I needed

Hi Antariksh, very useful, and one doubt is how can this parameters work as dynamic on daily refresh.

Hi Antriksh Sharma! How are you? Thank you so much for this amazing presentation. Please, I'm wondering if this example you demonstrated can be published to PowerBI online? Wouldn't PowerBI online block the this dataflow/dataset dure to firewall rules?

Hi Antariksh, very useful video, Can you please tell how to use this in PowerBI Service

You have helped me a great deal, thanks a ton!

This is awesome! Excellent video. Question for you: is it possible to use a formula for the EndDateParam value? For example, to always have it be today's date?

I need to do something like this but using the parameters on the Report part, not on the power query part, like a prompt the end user selects

Very useful. Thanks a lot!

This is useful for report developer. How do we let users change parameters? The import mode does not allow to bind parameters then to be used in a slicer or a filter. Or the requestion is how do we call stored procedure in Direct Query mode (this will allow to bind parameters then set up a user facing slicer or filter to update parameters)?

Helpful thank you ❤

With European local settings, reformatted dates in variables to pass to executing sp to US format mm/dd/yyyy. Worked on service.

Great video , but how do I connect this to the final report ? , and let the user choose the dates by himself ?

Could that be done in Excel power query as well? If yes, kindly make a short tutorial. Thank you 🙏🏻

Hi Antariksh.... very useful one...can you please tell how can we use the parameters dynamically in report. Mean to say can we pass the value from report to those parameters??

Hi Antriksh, How can we publish to service have users select the date parameters

This works in desktop but not in service. Am i making mistake or its not supported in service?

Can you then change the parameters from the viz dashboard? I would love to learn more. Thanks!

Is it possible for the user to select from the dropdown on the report visual to change the parameter values for Start date and end date? For example I want my user to be able to filter down and select the date range for Start date and end date on the visual, so based on those selection, report needs to be updated. How can I do it if possible?

Thanks 🎉🎉🎉

The changes to be made in M code is mandatory, is there any other method to do the same ?

Nice

Hi Antariksh, question... I have a store with a parameter but i need to call that parameter from other query, for example exec proc_Test where Date = @date Then i call that parameter from other querie that contains only dates so when i modify that date from the other query the Store will be refreshed. that date paramater will be in a filter for example, i tried everything...can you help me? I have Pro license.-

How can you update parameter values using slicer visuals and query new data? Thanks

Can you put a video on how to access a function that is in database from power bi? the current version of postgresql we are using doesnt support stored procedures. so the other option i have is function. could you please suggest how to access a function by using a slicer selection as a input?

Sir not work on hana database call to store procedure

Please attached SQL server database, as early as possible

How can we import data from multiple sql queries returning the same number and type of columns into a new table using power bi? For example i have 10 sql select queries. They return 3 columns Result, Tests, Quantity I want to create a new table in power bi with columns Result, Tests, Quantity. This new table should be populated from the 3 sql queries

I am getting an error " Expression.Error: The name 'Text.from' wasn't recognized. Make sure it's spelled correctly. StartDate = Text.from ( StartDate_P ), EndDate = Text.from ( EndDate_P ), How do I fix it?

OK, now let's see you add slicers so a user can set the parameters then click "Apply All Slicers" and have your stored proc run and return the data.

Can end user select the start date or end date from report level?

Getting error message: Expression.Error: A cyclic reference was encountered during evaluation.

When we select 1 month data error- come converting data type varchar to date

Anda boleh memilih untuk salah satu daripada hadiah di atas

how to pass datetime

Nevermind, I misse the very end of the video

I tried this exactly as you did and I get an error