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

[@reynaldomorillo4271]

Clear and simple. Thank you!

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

[@balajiawari9740]

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

[@simbadtr6630]

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

[@fildude]

Awesome tutorial, straightforward!

[@rajivjani8594]

Awesome! Thank you for sharing!

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

[@muralikrishna6761]

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

[@anilkumar-rg9jk]

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

[@SaraKhan-cv9sj]

Very helpful , thank you so much.

[@rebagaines8331]

This was exactly what I needed

[@chala11]

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

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

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

[@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

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

[@Mahesh717]

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

[@swapnilgharat7774]

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

[@rocklemon4948]

Thank you that was great help

[@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

[@theresarupinski9893]

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

[@HungNnguyenn]

I would love to shake your hand for this

[@ridzuankay]

Very useful. Thanks a lot!

[@alirezamogharabi8733]

Helpful thank you ❤

[@mayasandler4226]

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

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

[@lavleenkaur2405]

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

[@madhusoodhanan182]

Nice

[@sands7779]

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

[@abdullahquhtani4247]

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

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

[@EndlessEnt]

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

[@PS65501]

How to pass slicer values to those parameters?

[@ryzen7109]

Thanks 🎉🎉🎉

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

[@rushikesh5840]

Sir not work on hana database call to store procedure

[@nilanjitroy3546]

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

[@srimallikavlogs764]

did you find answer for your question ?

[@noueruz-zaman7894]

at 4:43 it is strange because you should be able to use direct query with store procedure.

[@Munichandra_Reddy]

Please attached SQL server database, as early as possible

[@VibeShiftChroniclesGA]

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

[@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

[@sadhanasawant7135]

I have around 10 parameters for my visual store procedure, following same process but getting error like this: Expression.Error: We cannot apply operator & to types Text and Table. Details: Operator=&

[@vikasrajole494]

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

[@sudipchakraborty9283]

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

[@johnbautista9925]

Anda boleh memilih untuk salah satu daripada hadiah di atas

[@sharmadiw]

how to pass datetime

[@jeffski9500]

Nevermind, I misse the very end of the video

[@jeffski9500]

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

[@BISimplifier]

Type exactly as Text.From ...