Get Data from Stored Procedure in Power BI Tutorial (34/50)
HTML-код
- Опубликовано: 25 июл 2024
- How to get the Data from Stored Procedure in Power BI
How to write SQL queries to get data in Power BI
How to get data from Stored procedure in Power BI
How to get data from Stored procedure without parameter in Power BI
#PowerBI #PowerBITutorials #GetDataStoredProcedures
✉ Business Queries / Analytics Consulting ✉ : analyticswithnags@gmail.com
💬 For Learners Post queries and Interact 💬 : t.me/analyticswithnags
Complete Playlists
Power BI Tutorials - Complete Playlist 📚📖 • How to do Power BI Ins...
Power BI Desktop Tips and Tricks 📚📖 • How to Remove Top N ro...
Power BI DAX - Complete Playlist 📚📖 • What is DAX in Power B...
Power BI Project Dashboards - Power BI Realtime Projects - Playlist 📚📖 • Loan disbursement Anal...
Power Pivot 📚📖 • Power BI Tutorial (15/...
Power Query 📚📖 • Power BI Tutorial (15/...
Power BI Services Playlist 📚📖 • Introduction to Power ...
Power BI Tamil Tutorials 📚📖 • How to do Power BI Ins...
Power BI Telugu Tutorials 📚📖 • How to do Power BI Ins...
SQL Full Course | SQL Tutorial For Beginners 📚📖 • Learn SQL Complete | C...
SSAS Tutorials - SQL Server Analysis Services 📚📖 • Introduction to SQL Se...
MSBI Tutorials - SQL + SSAS + SSIS 📚📖 • Learn SQL Complete | C...
Data Analyst - Complete Reference - Playlist 📚📖 • Data Analytics For Beg...
BI Developer - Complete Reference - Playlist
📚📖 • Power BI Tutorial From...
BI Architect - Complete Reference - Playlist
📚📖 • Power BI Full Course -...
ETL Developer - Complete Reference - Playlist 📚📖 • Building an Enterprise...
Database Developer - Complete Reference - Playlist 📚📖 • SQL Tutorial - Full Da... 
Наука
![How to connect POWER BI with SQL and build an AUTOMATED Dashboard [SQL to Power BI]](http://i.ytimg.com/vi/WgE8pVLgWGs/mqdefault.jpg)
Amazing channel and content... Thank you!
Thanks for your feedback. Share this channel with friends and colleagues
Can we use slicer instead of doing an "edit parameter" and the selecting a value?
No. slicers concept is different from Parameters
Well presented
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
I hope you can implement this other paginated reports
Can we pass value to parameters from our main report then only able to see charts using resulting data of that stored procedure ?
You need to use the paginated reports
Can we put date slice in power BI all though SP doesn't have any date column
Not sure what is your question
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".
It should work without “
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.
Can’t help much since not sure about the issue
Can we use direct query with parameterized sp?
Never tried check it I hope it is possible
Hello, What should I do if I need to pass the parameter from powerapps portal. I have used publish to web option. kindly help
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
Hello there! Can I use it on my online dashboards? Greetings from Brazil!
Yes. Once you deploy in services you can use it
Do you have a video in there that can I see you doing this?
In the company where I work, It use a private server to publish the reports.
Can we send slicer selected value to Stored Procedure and extract data in Power BI?
Use the paginated reports
@@AnalyticswithNags thanks but o never used it...can you please suggest any link?
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?
I hope you asking two questions. One is related to Row level security refer this video ruclips.net/video/gT5-S3raIDo/видео.html
Didn't understand your first question . Write your queries in detail to analyticswithnags@gmail.com we will respond you.
@@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
@@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
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 ?
You need good RAM
If we publish this report in workspace, do a user with view access change these parameters value.
Yes
Can I pass Parameter to Azure SQL DB's Stored Procedure?
I never tried. It should be
We can't apply this parameterized SP in PowerBI Service, it applies only for desktop
Noted. We will investigate it
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.
Never tried. Mostly used oracle views/ tables as a source.
@@AnalyticswithNags logró realizarlo en oracle? Por favor si es que puedes realizarlo en Oracle o Mysql, gracias de antemano por tan buen contenido
Can we created a dynamic report?
Check playlists of this channel and explore topics on the similar line requested by you.
What about multiple parameter and Date parameters? Do you have any guidance videos for that?
Soon will make video on that
@@AnalyticswithNags any video on the question asked?
In bi where we store data?
Watch this video
ruclips.net/video/0YY7_k-Asmk/видео.html
Can we call a mysql procedure
Yes I think so
Can we call a cursor from power bi?
No
It is very tricky for me...........bro should i learn sql first to understand this??
Yes. Sql should be the foundation for data analytics
amazing information .. thanks but video is not clear picture low quality
Sorry for that
@@AnalyticswithNags no need to say sorry sir 🙏
simple thing u have showed it in a complex and confusing way
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
Actually, the "without parameters" case throws an error "Incorrect syntax near keyword EXEC" error when you apply.
Ok
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
If you cannot use a slicer, this function is pretty useless. No benefit for the end user. Thanks for the Video
Thanks
Blurry video.
Quick question:
What is the value of using Paramters? Why not use Slicers?
usage depends on the requirements , some cases can be achieved by both so can by only done by one.
Only MS could make such a relatively simple task and make it extremely convoluted. I swear M is the worst language ever created.
No comments 😀
You made a simple thing complicated. Bad tutor
It is difficult for beginners to understand this kind of video.
Keep learning to upgrade your knowledge