Power Bi : Huge Update!! Dynamic Parameters for Transact SQL

UPDATE: Here is a video of how to set up a basic Dynamic Parameter against a TSQL source.
• Power Bi : Setting up ...
This is one of the biggest updates to Power Bi in recent months. End users now have the capability (without knowing) to dynamically change a query against the data source based on regular slicers and filters.

[@spendworx6978]

Yes, a very powerful update for Power BI. It closes the gap a bit on Tableau parameters in the area of end user self service what-if analyses.

[@markburns9538]

How would you do this with a where statement with an IN (), ie WHere column in ('black','white','red','green')? Can your parameter be linked with a slicer that is select multiple?

[@tARasKoni]

Cool news and very well explained! Thank you for sharing!

[@MrMan-ht6qf]

Agreed. I have been waiting for something like this for a few years. Nice to see it finally made it through development.

[@chriskeo392]

Can you do it with date format? I'm trying to use a date slicer

[@TrainerSamTing]

Is it still working? Btw, I am using get web data, I can't seems to see Bind to Parameter anymore under Advanced section in Model view ?

[@bmak6700]

I share your excitement, whooowhooooo, you don't know how I am happy

[@autochronicles8667]

OKAY.. how about using a "stored" proc in that query to allow the user to "update" as well as refresh the data... Power bi doesnt know what your doing in the stored proc right?

[@kembawxlker]

how do you do if area column is numeric?

[@OliveTreeAnalytics]

I have a huge fact table which i dont want to Import, How do i filter on fact table IDs, using DIM table "names" in the slicer ?

[@jbyxxx]

@2:37 Instead of parameters, is it possible to use a dynamic list (created by another query) so that I can get the subset of data from SQL Server?

[@Lemmy_at_home]

In my version "Power Bi Desktop (May 2022)" I cannot recreate this. Where am I making my mistake? The data connectivity mode I have also put DirectMode. But how can I build the table for Aerea manually? In your video at 04:50, the Data and Area tables are created in Mix data connectivity mode. How did you do that. Can you show how you did it? Thanks in advance. Greetings from Germany (Federal State of Hessen, in the district of Wetterau in the town of Karben) Frank

[@nilanjitroy3546]

If we pass multiple parameters against a sp, can end user provide dynamic input against those parameters?

[@raiedfanoosh4824]

I want to make the same parameter put from another source, but it dosnt work. Can you make another video for another database such as qwere that exist

[@soipunch6326]

Thanks for the news.

[@chicagobassplayer7175]

Great video! Can you provide a tutorial on how to do this but with Stored Procedures?

[@DaveJohnsonDBA]

Can I pull a parameter from page URL when I am hosting Power Bi report in an on that page?

[@DapperDash]

oooh that is tricky. If you are using PowerBi embedded (embedded capacity), you can leverage parameters, but if you are just embedding the report using html code, I don't think there is a way for PowerBi to read in a url parameter and leverage it as a Dynamic value.

[@sahuanalogchannel]

Is this feature available for snowflake databases

[@DapperDash]

When the feature was released in February 2022, it supported T-Sql based data sources, Terra data, oracle and Data flows. I use it with Azure SQL and SSMS. I have not tried it with snowflake, but if Snowflake is SQL based, you may be able to do it.

[@sahuanalogchannel]

@@DapperDash thank you

[@sayarakhatun5489]

When you are sharing your detailed video

[@DapperDash]

Hey Sayara, I just created a tutorial on setting this up. Thanks for reminding me to follow-up. kzbin.info/www/bejne/aajZn51-hayBh7M

[@ricardolizano8851]

Goob Bye Paginated Reports