How To Load Data In Power BI With Stored Procedure and Parameters | Power BI Tutorial

[@cicaasim9930]

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

[@Hardivh]

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_Xela2]

hi,i m loking for same.

[@QinZhang-xd7cu]

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)?

[@balajiawari9740]

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

[@reynaldomorillo4271]

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-rg9jk]

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.

[@muralikrishna6761]

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?

[@theresarupinski9893]

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

[@adlaimaschiach]

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

[@girmamoges941]

Good one

[@HungNnguyenn]

I would love to shake your hand for this

[@pthapa55]

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?

[@madhusoodhanan182]

Nice

[@akshatamalvi2842]

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??

[@irmdev595]

use a slicer and bind parameter in the modelling mode

[@rocklemon4948]

Thank you that was great help

[@rajivjani8594]

Awesome! Thank you for sharing!

[@cabroncito29]

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?

[@rebagaines8331]

This was exactly what I needed

[@chala11]

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

[@fildude]

Awesome tutorial, straightforward!

[@lavleenkaur2405]

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!

[@Mahesh717]

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 🙏🏻

[@miestudiolm9390]

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.-

[@guniabroudj1868]

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

[@MichaelGiusto]

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.

[@ridzuankay]

Very useful. Thanks a lot!

[@swapnilgharat7774]

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

[@ryzen7109]

Thanks 🎉🎉🎉

[@Munichandra_Reddy]

Please attached SQL server database, as early as possible

[@rushikesh5840]

Sir not work on hana database call to store procedure

[@sudipchakraborty9283]

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

[@kayalvizhisundaram8448]

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?

[@nilanjitroy3546]

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

[@srimallikavlogs764]

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

[@johnbautista9925]

Anda boleh memilih untuk salah satu daripada hadiah di atas

[@jeffski9500]

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

[@BISimplifier]

Type exactly as Text.From ...

[@jeffski9500]

Nevermind, I misse the very end of the video