Mesej yang jelas, struktur yang jelas, mudah difahami, terima kasih
@Hardivh7 ай бұрын
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
@Alex_Xela23 ай бұрын
hi,i m loking for same.
@QinZhang-xd7cu3 ай бұрын
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)?
@balajiawari97403 жыл бұрын
Hi Antariksh, very useful, and one doubt is how can this parameters work as dynamic on daily refresh.
@reynaldomorillo42712 жыл бұрын
Clear and simple. Thank you!
@simbadtr6630 Жыл бұрын
My salvation after hours of searching. I was not giving the proper database name so I couldnt connect. Thank you man
@anilkumar-rg9jk2 жыл бұрын
Do one more video on parameters how to use in different ways and where to use
@sands7779 Жыл бұрын
With European local settings, reformatted dates in variables to pass to executing sp to US format mm/dd/yyyy. Worked on service.
@muralikrishna67612 жыл бұрын
Hi Antariksh, very useful video, Can you please tell how to use this in PowerBI Service
@silicatoss Жыл бұрын
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?
@theresarupinski98932 жыл бұрын
Character In the video It's great, I like it a lot $$
@adlaimaschiach2 жыл бұрын
Great video , but how do I connect this to the final report ? , and let the user choose the dates by himself ?
@girmamoges9415 ай бұрын
Good one
@HungNnguyenn2 жыл бұрын
I would love to shake your hand for this
@pthapa557 ай бұрын
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?
@madhusoodhanan1822 жыл бұрын
Nice
@akshatamalvi28422 жыл бұрын
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??
@irmdev5952 жыл бұрын
use a slicer and bind parameter in the modelling mode
@rocklemon49482 ай бұрын
Thank you that was great help
@rajivjani8594 Жыл бұрын
Awesome! Thank you for sharing!
@cabroncito296 ай бұрын
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?
@rebagaines833110 ай бұрын
This was exactly what I needed
@chala113 жыл бұрын
Hi Antriksh, How can we publish to service have users select the date parameters
@fildude11 ай бұрын
Awesome tutorial, straightforward!
@lavleenkaur24052 жыл бұрын
This works in desktop but not in service. Am i making mistake or its not supported in service?
@mayasandler4226 Жыл бұрын
Can you then change the parameters from the viz dashboard? I would love to learn more. Thanks!
@Mahesh71710 ай бұрын
The changes to be made in M code is mandatory, is there any other method to do the same ?
@abdullahquhtani4247 Жыл бұрын
Could that be done in Excel power query as well? If yes, kindly make a short tutorial. Thank you 🙏🏻
@miestudiolm93903 жыл бұрын
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.-
@guniabroudj18682 жыл бұрын
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?
@BISimplifier Жыл бұрын
Your syntax is wrong.Type exactly as Text.From ...
@alirezamogharabi8733 Жыл бұрын
Helpful thank you ❤
@EndlessEnt Жыл бұрын
How can you update parameter values using slicer visuals and query new data? Thanks
@lovedeepsinghvasant4363 Жыл бұрын
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
@MichaelGiusto6 ай бұрын
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.
@ridzuankay2 жыл бұрын
Very useful. Thanks a lot!
@swapnilgharat77742 жыл бұрын
You have helped me a great deal, thanks a ton!
@ryzen71099 ай бұрын
Thanks 🎉🎉🎉
@Munichandra_Reddy2 жыл бұрын
Please attached SQL server database, as early as possible
@rushikesh58402 жыл бұрын
Sir not work on hana database call to store procedure
@sudipchakraborty92839 ай бұрын
Getting error message: Expression.Error: A cyclic reference was encountered during evaluation.
@kayalvizhisundaram84482 жыл бұрын
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?
@nilanjitroy35462 жыл бұрын
Can end user select the start date or end date from report level?
@srimallikavlogs7646 ай бұрын
did you find answer for your question ?
@vikasrajole494 Жыл бұрын
When we select 1 month data error- come converting data type varchar to date
@sharmadiw Жыл бұрын
how to pass datetime
@johnbautista99252 жыл бұрын
Anda boleh memilih untuk salah satu daripada hadiah di atas
@jeffski9500 Жыл бұрын
I tried this exactly as you did and I get an error