I would have been lost without your help. Thanks !
@taik18 Жыл бұрын
Glad it helped
@girmamoges9415 ай бұрын
Excellent work
@taik185 ай бұрын
Thank you 😊
@c.mdsalih Жыл бұрын
Thanks for the video, It's informative.
@taik18 Жыл бұрын
Thank you🙏
@user-kd6hl4hj6z3 ай бұрын
learned a lot! Thanks
@taik183 ай бұрын
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-gk8lg3ub2m8 ай бұрын
thanks a lot bro🤗
@taik188 ай бұрын
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
@sravanpesari114510 ай бұрын
Great explanation, can you please share how to implement this in Oracle stored procedure with parameters.
@arameshkumar5072 Жыл бұрын
Great Content
@taik18 Жыл бұрын
Thank you
@abcd720315 сағат бұрын
Can we execute the stored procedure using user parameters in PowerBI direct method?
@KaiDPTechnologies2 ай бұрын
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?
@Jacosonop4 ай бұрын
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
@sheshikumarausheni94283 ай бұрын
But stored procedure is not working in direct query as suggested
@azharshaik215 ай бұрын
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.
@anilmvn11 ай бұрын
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.
@inderpreetsingh265811 ай бұрын
how did it work for you? How did you coonect SP to power bi in direct query mode?
@taik1811 ай бұрын
For date try passing in the format of 'yyyy-Mm-dd' Using stored procedure As explained in the video..
@shreee198611 ай бұрын
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
@sravanpesari114510 ай бұрын
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?
@godgiftedlife940110 күн бұрын
I am not able to run this procedure
@paritoshkadam3671 Жыл бұрын
Error The OLE DB provider "MSOLEDBSQL" for linked server "(null)" reported an error. Authentication failed.
@navidarshad20884 ай бұрын
How can I do this when I have temp table in stored procedure?
@n.r.swapna773510 ай бұрын
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
@hugoespinosa135628 күн бұрын
Hi, did you use import or direct query mode?
@taik1828 күн бұрын
Direct query
@hugoespinosa135628 күн бұрын
Is it possible to use import mode as well?
@taik1827 күн бұрын
@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?
@shreee198611 ай бұрын
Yes. Same issue. Any luck after this?
@bummknack4 ай бұрын
@@shreee1986 Found a solution?
@inderpreetsingh265811 ай бұрын
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
@taik1811 ай бұрын
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.
@malathis1523 Жыл бұрын
I am getting error "Expression.SyntaxError: Invalid literal." on using the same procedure can i know what could be problem
@taik18 Жыл бұрын
is this problem solved.?
@user-fx8wu6yt5v11 ай бұрын
denied because no login-mapping exists. I got this error message.
@anupamjha827 Жыл бұрын
How will you show million and billion unit in tooltip by converting the original value