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)?
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?
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 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 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.-
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?
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?
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?
Mesej yang jelas, struktur yang jelas, mudah difahami, terima kasih
Very helpful , thank you so much.
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
hi,i m loking for same.
Clear and simple. Thank you!
Hi Antariksh, very useful, and one doubt is how can this parameters work as dynamic on daily refresh.
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)?
Awesome! Thank you for sharing!
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?
Hi Antariksh, very useful video, Can you please tell how to use this in PowerBI Service
Hi Antriksh, How can we publish to service have users select the date parameters
Awesome tutorial, straightforward!
This was exactly what I needed
Do one more video on parameters how to use in different ways and where to use
The changes to be made in M code is mandatory, is there any other method to do the same ?
Thank you that was great help
Nice
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?
Great video , but how do I connect this to the final report ? , and let the user choose the dates by himself ?
Good one
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??
use a slicer and bind parameter in the modelling mode
Character In the video It's great, I like it a lot $$
I would love to shake your hand for this
My salvation after hours of searching. I was not giving the proper database name so I couldnt connect. Thank you man
This works in desktop but not in service. Am i making mistake or its not supported in service?
Could that be done in Excel power query as well?
If yes, kindly make a short tutorial. Thank you 🙏🏻
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.-
Helpful thank you ❤
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?
Very useful. Thanks a lot!
You have helped me a great deal, thanks a ton!
Can you then change the parameters from the viz dashboard? I would love to learn more. Thanks!
How can you update parameter values using slicer visuals and query new data? Thanks
Thanks 🎉🎉🎉
With European local settings, reformatted dates in variables to pass to executing sp to US format mm/dd/yyyy. Worked on service.
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
Can end user select the start date or end date from report level?
did you find answer for your question ?
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.
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?
Your syntax is wrong.Type exactly as Text.From ...
Please attached SQL server database, as early as possible
When we select 1 month data error- come converting data type varchar to date
Anda boleh memilih untuk salah satu daripada hadiah di atas
Getting error message: Expression.Error: A cyclic reference was encountered during evaluation.
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
Type exactly as Text.From ...