Hello, you have made Informative Videos on Power BI, i have one question please let me know why we need to convert a table into add as new query? can you please brief me more with that? thanks in 7:05 video time.
@sandeep_okАй бұрын
Can I use the Same logic for Dynamic Logged-in Users for different Hierarchy(Like region manager, district manager, area manager)???
@vishalbhomia82303 жыл бұрын
Can we use slicer instead of doing an "edit parameter" and the selecting a value?
@AnalyticswithNags3 жыл бұрын
No. slicers concept is different from Parameters
@Ravi-ce6th Жыл бұрын
Can we use direct query ?so that we can put filter selection for parameter, based on selection the table will change dynamically will this work? because for import mode it is not flexible like filter selection when we publish the report. Can you pls answer it
@AnalyticswithNags Жыл бұрын
I hope you can implement this other paginated reports
@anaghadamame1962 жыл бұрын
Can we pass value to parameters from our main report then only able to see charts using resulting data of that stored procedure ?
@AnalyticswithNags2 жыл бұрын
You need to use the paginated reports
@khushigarg98472 жыл бұрын
If we publish this report in workspace, do a user with view access change these parameters value.
@AnalyticswithNags2 жыл бұрын
Yes
@arpansen62312 жыл бұрын
Amazing channel and content... Thank you!
@AnalyticswithNags2 жыл бұрын
Thanks for your feedback. Share this channel with friends and colleagues
@vijiv7842 Жыл бұрын
If the parameter is an integer type and not varchar then how value will be given to the Exec GetEmployeePer. It's showing me Invalid Literal while giving the value as 2 or '2' or ,"2".
@AnalyticswithNags Жыл бұрын
It should work without “
@bhaveshdevra2 жыл бұрын
Can we put date slice in power BI all though SP doesn't have any date column
@AnalyticswithNags2 жыл бұрын
Not sure what is your question
@asd-ed8ty2 жыл бұрын
Hello Sir thank u for this video , While implimenting it I am gettin error ......... "without parameters" case throws an error "Incorrect syntax near keyword EXEC" error when you apply.
@AnalyticswithNags2 жыл бұрын
Can’t help much since not sure about the issue
@kateworkman40403 жыл бұрын
What about multiple parameter and Date parameters? Do you have any guidance videos for that?
@AnalyticswithNags3 жыл бұрын
Soon will make video on that
@sarveshnundram8663 жыл бұрын
@@AnalyticswithNags any video on the question asked?
@chriskelley340516 күн бұрын
I would like to see that as well
@sinvalfelisberto3 жыл бұрын
Hello there! Can I use it on my online dashboards? Greetings from Brazil!
@AnalyticswithNags3 жыл бұрын
Yes. Once you deploy in services you can use it
@sinvalfelisberto3 жыл бұрын
Do you have a video in there that can I see you doing this?
@sinvalfelisberto3 жыл бұрын
In the company where I work, It use a private server to publish the reports.
@faiz.ahmad652 жыл бұрын
Can we send slicer selected value to Stored Procedure and extract data in Power BI?
@AnalyticswithNags2 жыл бұрын
Use the paginated reports
@faiz.ahmad652 жыл бұрын
@@AnalyticswithNags thanks but o never used it...can you please suggest any link?
@lavleenkaur24052 жыл бұрын
Can we use direct query with parameterized sp?
@AnalyticswithNags2 жыл бұрын
Never tried check it I hope it is possible
@SammyMachethe57162 ай бұрын
Well presented
@AnalyticswithNagsАй бұрын
Thank you 🙂
@stoneage8810 Жыл бұрын
is this taking all data out of DWH and store in your laptop's memory ? i guess performance is a big problem if you scale up ?
@AnalyticswithNags Жыл бұрын
You need good RAM
@miiihiir2 жыл бұрын
It is very tricky for me...........bro should i learn sql first to understand this??
@AnalyticswithNags2 жыл бұрын
Yes. Sql should be the foundation for data analytics
@athiiammu68143 жыл бұрын
We can't apply this parameterized SP in PowerBI Service, it applies only for desktop
@AnalyticswithNags3 жыл бұрын
Noted. We will investigate it
@shoeb13592 күн бұрын
@@AnalyticswithNags Just checking if you find solution. if yes please explain
@ArpitSharma-kk9tl3 жыл бұрын
Can you please let me know how user will perform this operation because here developer is able to perform these operation can we bind condition in power bi service with role level security. Is it possible?
@AnalyticswithNags3 жыл бұрын
I hope you asking two questions. One is related to Row level security refer this video kzbin.info/www/bejne/nYWYXoZpp8Z8etE Didn't understand your first question . Write your queries in detail to analyticswithnags@gmail.com we will respond you.
@ArpitSharma-kk9tl3 жыл бұрын
@@AnalyticswithNags see in the video we can see that we are able to change parameter according to our condition. If we want to provide this feature to user how can we do that since in power BI desktop that parameter option is available but in user end it is not
@itzaruns3 жыл бұрын
@@ArpitSharma-kk9tl Thanks for the query, I was also searching for same answer you are looking for, If it works I need to try with dates as parameters will be a great advantage
@eshwarkoti3 жыл бұрын
How to call oracle stored procedure from power bi. It is showing error like "Oracle: ORA-00900: invalid SQL statement" while trying to call simple procedure without parameters.
@AnalyticswithNags3 жыл бұрын
Never tried. Mostly used oracle views/ tables as a source.
@davidtc33733 жыл бұрын
@@AnalyticswithNags logró realizarlo en oracle? Por favor si es que puedes realizarlo en Oracle o Mysql, gracias de antemano por tan buen contenido
@harshalwadaskar19413 жыл бұрын
Can I pass Parameter to Azure SQL DB's Stored Procedure?
@AnalyticswithNags3 жыл бұрын
I never tried. It should be
@rollarhockeyAnviKalra Жыл бұрын
amazing information .. thanks but video is not clear picture low quality
@AnalyticswithNags Жыл бұрын
Sorry for that
@rollarhockeyAnviKalra Жыл бұрын
@@AnalyticswithNags no need to say sorry sir 🙏
@arunkoshyg10 ай бұрын
Can we created a dynamic report?
@AnalyticswithNags5 ай бұрын
Check playlists of this channel and explore topics on the similar line requested by you.
@rajashreekamath7133 жыл бұрын
Hello, What should I do if I need to pass the parameter from powerapps portal. I have used publish to web option. kindly help
@AnalyticswithNags3 жыл бұрын
We never worked on power apps. anyway, kindly email the requirement in detail what you actually want to acheive. If time permits we will respond you back
@snehalnalawade96812 жыл бұрын
In bi where we store data?
@AnalyticswithNags2 жыл бұрын
Watch this video kzbin.info/www/bejne/Zoq8aJKhYqamo80
@user-in9ix2cm2r6 ай бұрын
Can we call a mysql procedure
@AnalyticswithNags6 ай бұрын
Yes I think so
@JabWeMeth2 жыл бұрын
Can we call a cursor from power bi?
@AnalyticswithNags2 жыл бұрын
No
@dougkimzey45182 жыл бұрын
Actually, the "without parameters" case throws an error "Incorrect syntax near keyword EXEC" error when you apply.
@AnalyticswithNags2 жыл бұрын
Ok
@anaghadamame1962 жыл бұрын
Select "Import" option in Data connection mode whle connecting SQL server. See 2.17 part of this video carefully...I hope it will solve your error
@marnitztaylor95092 жыл бұрын
If you cannot use a slicer, this function is pretty useless. No benefit for the end user. Thanks for the Video
@AnalyticswithNags2 жыл бұрын
Thanks
@mohitupadhayay14392 жыл бұрын
Blurry video. Quick question: What is the value of using Paramters? Why not use Slicers?
@AnalyticswithNags2 жыл бұрын
usage depends on the requirements , some cases can be achieved by both so can by only done by one.
@madhusudhanreddyt28383 жыл бұрын
simple thing u have showed it in a complex and confusing way
@AnalyticswithNags3 жыл бұрын
This is odd topic and I haven't prepared well. Also this is not used in most of the analytics projects Don't judge the channel with single video. Keep learning other topics
@chriskelley340516 күн бұрын
@@AnalyticswithNags I think you have shown a complex thing in a simple and intuitive way
@raymondjolly282 Жыл бұрын
Only MS could make such a relatively simple task and make it extremely convoluted. I swear M is the worst language ever created.
@AnalyticswithNags Жыл бұрын
No comments 😀
@Amanomegle3 жыл бұрын
You made a simple thing complicated. Bad tutor
@AnalyticswithNags3 жыл бұрын
It is difficult for beginners to understand this kind of video. Keep learning to upgrade your knowledge