SQL Stored Procedure With Dynamic Parameter In Power BI Service

No video

SQL Stored Procedure With Dynamic Parameter In Power BI Service

Рет қаралды 15,760

taik18 - Mohammed Adnan

Күн бұрын

Пікірлер: 62

@wernerzirkel2753 Жыл бұрын

I would have been lost without your help. Thanks !

@taik18 Жыл бұрын

Glad it helped

@girmamoges941 5 ай бұрын

Excellent work

@taik18 5 ай бұрын

Thank you 😊

@c.mdsalih Жыл бұрын

Thanks for the video, It's informative.

@taik18 Жыл бұрын

Thank you🙏

@user-kd6hl4hj6z 3 ай бұрын

learned a lot! Thanks

@taik18 3 ай бұрын

Thank you for your valuable feedback ☺️

@JegErAlan Жыл бұрын

Very helpful, thanks!

@taik18 Жыл бұрын

Thank you

@jenstoll97 Жыл бұрын

Thanks for the video! Can you share an example of the syntax for adding multiple dynamic parameters?

@user-gk8lg3ub2m 8 ай бұрын

thanks a lot bro🤗

@taik18 8 ай бұрын

Thanks for your support 🙂

@abhishek12865a Жыл бұрын

You Got content but your explanation can be more better you are running and people slow as me unable to grasp it Take it in positive way Thanks

@taik18 Жыл бұрын

Noted, thanks a lot for your feedback, really helpful

@sravanpesari1145 10 ай бұрын

Great explanation, can you please share how to implement this in Oracle stored procedure with parameters.

@arameshkumar5072 Жыл бұрын

Great Content

@taik18 Жыл бұрын

Thank you

@abcd7203 15 сағат бұрын

Can we execute the stored procedure using user parameters in PowerBI direct method?

@KaiDPTechnologies 2 ай бұрын

Accessories , bikes , clothes , Components these parameter represent different Databases ? then we select the value it fetch the databases ?

@zafarpat Жыл бұрын

This is very good session. can you please suggest how do we pass this parameter from client web application to power bi report

@rubinasarkar5385 Жыл бұрын

That is a great video, thankyou very much also, can you please tell us how to multiselect the dynamic parameters in Power BI?

@Jacosonop 4 ай бұрын

Hi, Is there any feedback how to modify the connection to include select all and multi select ?

@cuarin Жыл бұрын

I m having error in azure sql database, its not working even used openquery instead openrowset

@sheshikumarausheni9428 3 ай бұрын

But stored procedure is not working in direct query as suggested

@azharshaik21 5 ай бұрын

Hi Adnan, how this parameter will applicable for date column ? I have the data of 10 years to till date means 2024. Appreciate if you can advise.

@anilmvn 11 ай бұрын

Hello, This is great. Can you please let me know how can we pass date parameters dynamically form the front end report as like the Category in your video.

@inderpreetsingh2658 11 ай бұрын

how did it work for you? How did you coonect SP to power bi in direct query mode?

@taik18 11 ай бұрын

For date try passing in the format of 'yyyy-Mm-dd' Using stored procedure As explained in the video..

@shreee1986 11 ай бұрын

Good one. But stored procedure that gives resultset from #temp table is not working in Power BI. Any idea?

@kdll1000 Жыл бұрын

We have 5 million unique rows for Primary ID. Can you please suggest the workaround for this scenario where we need to filter or the display the data with help of primary ID as parameter

@TrangNguyen-su9jv Жыл бұрын

thanks so much for your video. It worked like a charm. Besides, does it work for date slicer type when I filter from date to date?

@taik18 Жыл бұрын

thanks, It should work

@sravanpesari1145 10 ай бұрын

I tried this approach but didn’t work in Oracle, can you please provide the steps to How to implement this with Oracle stored proc?

@godgiftedlife9401 10 күн бұрын

I am not able to run this procedure

@paritoshkadam3671 Жыл бұрын

Error The OLE DB provider "MSOLEDBSQL" for linked server "(null)" reported an error. Authentication failed.

@navidarshad2088 4 ай бұрын

How can I do this when I have temp table in stored procedure?

@n.r.swapna7735 10 ай бұрын

Hi, How the end user can pass the parameters if we connect in import method as I am not seeing dind option in data modelling.pls help me with this

@suktvm Ай бұрын

i am missing this binding parameter option . which version support this

@taik18 Ай бұрын

It is available from very long time.. Pls follow the video

@jeffski9500 Жыл бұрын

I tried your example but I get an error with the exec and parameter. Help

@hugoespinosa1356 28 күн бұрын

Hi, did you use import or direct query mode?

@taik18 28 күн бұрын

Direct query

@hugoespinosa1356 28 күн бұрын

Is it possible to use import mode as well?

@taik18 27 күн бұрын

@hugoespinosa1356 i doubt.. because during import the load in Power BI

@beingcreativee4u618 Жыл бұрын

It's working properly for simple stored procedure but I tried with temp table in stored procedure it's giving the error regarding metadata. Could you please suggest the solutions for that?

@shreee1986 11 ай бұрын

Yes. Same issue. Any luck after this?

@bummknack 4 ай бұрын

@@shreee1986 Found a solution?

@inderpreetsingh2658 11 ай бұрын

how is anyone able to import stored procedure in the first place? I'm getting an error Microsoft SQL: Incorrect syntax near the keyword 'exec'. Incorrect syntax near ')'. It's clearly mentioned everywhere that SP only works with import mode

@taik18 11 ай бұрын

Pls check the video

@kdll1000 Жыл бұрын

Hello, I have more than 13 million records in one column and I want to pass those values to parameter but import is not possible for this scenario and so slicer is also not useful. Can you please provide the workaround how can user manually enter the value to the parameter

@taik18 Жыл бұрын

You can import the data and apply slicer

@kdll1000 Жыл бұрын

@@taik18 I have power bi pro licence. So power bi will not allow to import more than 1 million

@taik18 Жыл бұрын

Limitations are only on the size of the file 1 GB, not the number of rows.. Try to convert it into a star schema to reduce the file size.