How did you find this process? Are you using a different process to automate your work? Please let me know in the comments below!
@norpriest5213 жыл бұрын
Hi thank you. This is the closest thing to the way I want it to work. The only thing is that I still have to open Power Bi and click "Get Data" button. Is there a way to fully automate data from Sql Server to Power Bi Desktop without us having to open Power Bi? I have the idea of automate the whole thing from Sql Server (select * from) -> Power bi desktop(data cleaning with Pandas & create dashboards) -> Publish to Power bi online I just want to automate the whole thing. Can you suggest the solution?
@Data360YP3 жыл бұрын
@@norpriest521 You will have to investigate the live connections. There is a few options. One of them I use is Analysis Services via Visual studio
@AzizRehman01113 жыл бұрын
Yes you can set refresh option from power bi for sql server data to automatically refresh from page option pane in power bi.
@thanasisathanasi4965 Жыл бұрын
Είμαι του linux εγώ. Κάμνω τα ρεπορτσ μου MySQL + PHP τζιαι πιάνω τα που του Browser ! H mySQL έσιει Stored Procedures αλλά σπάνια χρησιμοποιώ τα. Τωρά οι καρακιόζηδες της δουλείας μου εφέραν το PowerBI τζιαι προσπαθώ να πιάσω access σε αντίγραφο της SQL τους. Νομίζω θα παραιτήσω. Εβαρέθηκα τους. ΨΩΜΙ ΠΑΙΔΙΑ ΚΑΙ ΛΙΝΟΥΞ ΣΤΑ ΣΧΟΛΕΙΑ φίλε μου. Τα άλλα ούλλα εν για τους νταβαντζίδες των μεγάλων εταιρειών !
@Karenshow Жыл бұрын
SSIS packages to do the data load.
@ayencoscolfield33123 жыл бұрын
Wa ohh this is exactly what have been looking for how to create jobs in SQL and automating sql and with power bi, thank you so much always a God sent you are
@Data360YP3 жыл бұрын
Glad it was helpful!
@karendavis23802 жыл бұрын
I appreciate how quickly you run through this tutorial. Tons of information packed into a short period of time. You put this puzzle together better for me than any other video. Good job.
@anthonyd4539 Жыл бұрын
If all youtube instructional videos were like this I would be a Rocket Scientists by now. Thank you!
@gabriellazaromoran17673 жыл бұрын
i liked this video without unuseless information and the realy important information!
@donjoncho5878 Жыл бұрын
This has been one of the most helpul videos i have found about Power BI and SQL! This is amazing! Thank you for all this information.
@tinypandas4 жыл бұрын
I had been looking for this kind of content from such a long time...Thank you so much for your efforts and this video. I have found this extremely helpful!!!!!!!!!!!!!
@Data360YP4 жыл бұрын
Glad it was helpful!
@garciaoscar7611 Жыл бұрын
Thank you for taking the time to create this video. Ive used it many times now for projects Ive created!
@theghostrisa2745 Жыл бұрын
You r teaching skills and the method is really a attractive and understandable. Keep it up
@KalugampitiyaJayakody8 ай бұрын
Extremely good video for Power BI with SQL server Agent , Execute Procedure , Thank you very much
@alexanderpotapkin20743 жыл бұрын
Thank You man! No idle talk, just practice!
@kwesi74102 жыл бұрын
wonderful video for beginner to Power BI -- was able to produce my first report :-) Thank you !!
@shekharsrivastava55354 жыл бұрын
Thanks a lot for this wonderful tutorial. You are such an amazing teacher.
@Data360YP3 жыл бұрын
Glad it was helpful!
@AugustaPromise Жыл бұрын
Short but really detailed and I understood perfectly what I was looking for. Thank you
@user-ex5xp5mk1u Жыл бұрын
Fantastic Power BI tutorial! Your explanation is excellent and much needed. Thank you for sharing your expertise!
@SunshineDT20102 жыл бұрын
Great video! I’ve subscribed!!! I was looking for a piece to walk me through the actual process of linking to Power BI and this does that perfectly!! Thanks
@khayolnoranjov9183 жыл бұрын
Topics for beginners, but you explain very cool. I watched to the end. Thanks!!!
@Data360YP3 жыл бұрын
Glad you liked it!
@musajallow50134 жыл бұрын
You're the best hands down!!!!! I need help how to create HTML/CSS dashboard from SQL data
@ejazsiddiqui68203 жыл бұрын
did you found that??
@annajichanatu33 жыл бұрын
Thanks a lot for putting this video. I am delighted with this video. You explained every single bit precisely without rushing and taking any short cuts. There are very few videos where SQL connectivity is shown using the stored procedure. Most of the videos use Excel spreadsheet to explain the concept. In this tutorial, you did touch the scheduling the SQL job to run at a set frequency and this was really good to know. Power BI presentation was also very good. Good on you mate. Please keep posting similar videos. You may start new tutorials on how to use DAX to create measures in the power bi.
@mioindelululand9 ай бұрын
I needed this for work but all the tutorials were showing from excel sheet. He did a great job!
@April417Baby Жыл бұрын
my favourite video so far thank you for the process
@kennethstephani6923 жыл бұрын
This is a terrific video!! Great work!!
@DianethLizarraga3 жыл бұрын
Gracias por el tutorial! es un éxito! Lo estoy implementado en mi tesis. Saludos desde Perú
@amit2888 Жыл бұрын
Super informative and crisp video. Thanks a lot for your efforts!
@user-lm5wb8vi1x3 ай бұрын
Finished Watching
@nickarrigo55403 жыл бұрын
excellent demonstration!
@Data360YP3 жыл бұрын
Thank you! Cheers!
@sunilnallagonda13894 жыл бұрын
Excellent. Understood each and every word.
@Data360YP4 жыл бұрын
Glad you liked it!
@LIV-FREE-VET8 ай бұрын
Really good, looking to implement this with my new data role. Thanks for the video! Hope mines works :P
@CMKaplan4 жыл бұрын
Thank you for this high quality free content.
@Data360YP4 жыл бұрын
Glad you enjoy it!
@andreasp.1894 жыл бұрын
Excellent and very informative video Yiannis. Keep it up!
@eslamabdelfattah8721Ай бұрын
very informative video and i like your English accent
@UU-ry6gt3 жыл бұрын
I wish my IT teacher was like you ;)
@JimRohn-u8c3 жыл бұрын
You’re amazing! God bless you and thank You so much!
@Data360YP3 жыл бұрын
Happy to help!
@srinigompadai8843 жыл бұрын
@ Yiannis Pitsillides.. Super video. I was searching for this and found it.. Thank you for all your efforts.
@Data360YP3 жыл бұрын
Glad it was helpful!
@ashishmohan47074 жыл бұрын
Wow great 👍👍👍👍👍 i learn more from ur video and power BI topic 👌👌👌👌👌 U r amazing
@Data360YP4 жыл бұрын
Glad you find my videos useful!!
@manideepgupta24333 жыл бұрын
Bro, You are amazing, thanks for the unique, wonderful automated tutorial.
@Data360YP3 жыл бұрын
Glad you liked it!
@matheusesteves46363 жыл бұрын
Thank you! Excellent video
@Data360YP3 жыл бұрын
Glad it was helpful!
@thanasisathanasi4965 Жыл бұрын
¨Ελα ρε κυπραίο! Καλή η δουλειά σου !
@marioestrada22333 жыл бұрын
This was really insightful! Thanks!
@bouseuxlatache41403 жыл бұрын
discovered your channel. very pedagogic. thanks
@ponchyponchy6873 жыл бұрын
Great, well explained, sounds easy with you teaching Many thanks
@nicolascortes66313 жыл бұрын
Thanks mate, this is very helpful. In addition, I didn't know that Henrikh Mkhitaryan was good at Databases. Greetings!
@Data360YP3 жыл бұрын
Glad it was helpful!
@imsynyster16363 жыл бұрын
Gracias, pude postular a un trabajo gracias a esto, un genio!
@nicolethornsbury42632 жыл бұрын
Thank you! This video helped a lot...after I slowed it down to 3/4 speed lol
@easylifewithchaimae56873 жыл бұрын
good job , the tutoriel was so clear
@Data360YP3 жыл бұрын
Glad to hear that!
@alextagbo7504 Жыл бұрын
Great Tutorial, many thanks 👏👏👏👏
@sepidehzamani74163 жыл бұрын
Thank you so much for this great video!
@Data360YP3 жыл бұрын
You are so welcome!
@christianlira12593 жыл бұрын
Great video and thank you.
@Data360YP3 жыл бұрын
Glad you enjoyed it
@anuj1526 Жыл бұрын
thanks for creting this video please make one video on python with sql also
@spicer72083 жыл бұрын
Great tutorial - Like the SQL view details!!!
@Data360YP3 жыл бұрын
Glad it helped!
@yutianwanggg Жыл бұрын
Very well-explained! Thank you:)
@Yassou1985 Жыл бұрын
Thx bro for your video, it was very interesting =)
@ruesaintdenis4 жыл бұрын
so grateful, thank you
@Data360YP4 жыл бұрын
You are so welcome
@AMATAKEYCHANNEL3 жыл бұрын
Clear and helpful for me -Thanks
@Data360YP3 жыл бұрын
Glad it helped
@chaudiep8274 Жыл бұрын
thank you so much
@claudiosilva76973 жыл бұрын
Excellent content. Thanks
@favoh963 жыл бұрын
Thanks a lot. This was so useful for me. Can we have the kaggle page where you get the data, please?
@svrkraju6543 жыл бұрын
Wonderful explanation
@Data360YP3 жыл бұрын
Glad you think so!
@patansadathalikhan23503 ай бұрын
GOAT 🐐🐐🐐🐐🐐VIDEO
@jaffeth49542 жыл бұрын
Thanks, great work
@adewalem5474 Жыл бұрын
This is awesome 👌🏿
@tubeitz4 жыл бұрын
Amazing video, thank you for such brilliant content
@Data360YP4 жыл бұрын
Glad you like it!
@zouhairarroud93153 жыл бұрын
Thank u so much for that explanation
@Data360YP3 жыл бұрын
Glad it was helpful!
@jhanvipatel-zl6wb Жыл бұрын
The video is amazing and has helped to understand lots of concept. Unfortunately, when I try same code I have an Error while BULK INSERT can someone help me with it, please
@manasijoshi7145 Жыл бұрын
Thank you for amazing work. Why do we have to create a stored procedure in SQL?
@hugobohorquez74503 жыл бұрын
excellent! thanks
@soumyasanjeevkumar60603 жыл бұрын
I wanted to understand, why didn't we directly connect excel to power bi? Does using SQL in between has some advantage in terms of speed or flexibility?
@vatsal7152 жыл бұрын
hi @Data360YP please revert on this?
@TheDrawingExpress Жыл бұрын
As per my understanding you can directly connect to the excel . There maybe many scenarios where you want to create new tables in db to load the excel or other files and pull reports from warehouse . This is the scenario he is explaining .
@levichase5279 Жыл бұрын
SQL makes it much easier to input and pull data from a database! I like it better than excel
@gopichand5717 Жыл бұрын
Enterprise data will be stored in SQL or data data wherehouses,as he is trying to explain that scenario
@manishvlogs2800 Жыл бұрын
Sql is better to extract data from multiple tables than in excel
@Malebuza3 жыл бұрын
In power bi there’s a schedule refresh, what’s the difference with what you’ve just presented. Wouldn’t it be possible to schedule a refresh for an csv file?
@NickArchiverd52519 ай бұрын
Is 'Indicator' a table you have setup in your database? That is confusing me. Thank you for this video.
@edge61922 жыл бұрын
Amazing
@MVZNMJ Жыл бұрын
I have one question over here. So, what if the excel raw data consists of any formulas in the cells. Would it be able to pick the same values in power bi as well ? Appreciate if anyone can clear my doubt..
@ilikedigitallogic50594 жыл бұрын
Thanks
@aschaithra7752 жыл бұрын
What about the job opportunity in power bi how much salary can be expected can any one pls assist me
@annecage31993 жыл бұрын
Isn't there a way to scedule SQL Server so that it automatically updates when we make the changes to the Excel file without us having to run the command again?
@MoonShine-bs6cl10 ай бұрын
Hi if I have multiple tables in sql like 5 tables and i want to automate dashboard in power bi by using postgres sql, how can i do... Is this same way, or pls make a video, as before my data source was excel..
@ahmedkharrat17833 жыл бұрын
Great video. I have a question, Do we need to update manually the excel file each week? is there a way that the excel file will be automated automatically ? so no need to update it manually ? thank you
@Pasdpawn Жыл бұрын
Really helpful video. Is there a way to do the same with postgres? how can we create a postgres agent job that runs automatically?
@sia_ibk2 жыл бұрын
Hi. I really learnt a whole lot from this. Quick question, if the dataset was imported into sql as a table and not using query, can the automation still work. Because it seems like the "table creation" and "Bulk insert" from the URL in the stored procedure is what allows the automation to work.
@karthickkalaiarasu87363 жыл бұрын
Good one
@davidc20722 жыл бұрын
Could you provide a link to the Kaggle data you used?
@saleemmalik843 жыл бұрын
Hello. that's so cool. Clean and clearly explained. And I have one question over here. So, what if the excel raw data consists of any formulas in the cells. Would it be able to pick the same values in power bi as well ? Appreciate if anyone can clear my doubt. Thank you!!!
@juanneira71613 жыл бұрын
Great Thanks
@Data360YP3 жыл бұрын
You are welcome
@aravyaverma4637 Жыл бұрын
Hello, what if I have a live data connection with sql server and i want the month slicer to get updated and add a month at every 1st of next month and i also want to show it the previous months. How can i do it ? Please help
@creativeminichitra9802 Жыл бұрын
but i still see we have to manually refresh the dataset in power bi to get mssql data, can we automate to refresh without clicking on refresh button
@alexsamuel95023 жыл бұрын
This excellent video, can you also create some detailed videos on ssis and sql
@najah3244 Жыл бұрын
interesting video
@vishnu1139 Жыл бұрын
can we connect power bi with multiple views from sql and create multiple charts in same dashboard?
@adelsafou98502 жыл бұрын
Can we have the kaggle page where you get the data, please?
@user-ry4jd3mb7q Жыл бұрын
Using this method, if my excel file is populated with more data, will it update in my database?
@chandragiovanni86343 жыл бұрын
Any advice, what would be the difference if we connect excel to bi through SQL vs we connect excel to bi directly or via web like sharepoint/onedrive? Since I also able to automate the report with those 2 ways. I just need to refresh bi to update the data visualization. please advice.. Thanks.
@chenchang722 жыл бұрын
Great video. But can someone help me understand why the 'creat view' step does not need to be included in the procedure? Does it automatically re-run?
@zaheerbasha88152 жыл бұрын
thank you, this video is very helpful for me, can you share a CSV file for my practice
@jimmynov792 жыл бұрын
What would it be the process to connect a folder that contain multiples Excel files with the same format but newer data to be updated...?
@abedaarabi30144 жыл бұрын
Thank you for the great job, is possible to show how to insert data from web api in to sql :) ?
@Data360YP4 жыл бұрын
Yes ofc, usually, websites provide documentation on how to connect with their API
@Griffindor212 жыл бұрын
Great video! Will this only work on MSSQL, or other flavours such as MySQL?
@PakFan7863 жыл бұрын
Can you go over creating relationship of sql server tables in powerbi, and the date table, does setting it to direct query stop the relationship pane
@lulubee48263 жыл бұрын
Let's assume you do all of that with models in Databricks Clusters, and then you publish on Power BI Service, will it be as faster as it looks like? Is there any data stored on Power BI Service ? or everything stays in the Data Source (i.e. in your case SQL)
@Data360YP3 жыл бұрын
Hey, both solutions work but I would advice not to store any data in Power BI as it will be slower. There is also a limit in how much data you can store in Power BI
@sia_ibk2 жыл бұрын
I keep getting an error when trying to start the SQL server agent. "The request failed or the service did not respond in a timely fashion. Consult the event log or other applicable error logs for details" What do I do about this please?
@haider12972 жыл бұрын
I am unable to download the CSV file, kindly suggest.
@santiagoalonso72573 жыл бұрын
Hello! If i may ask i want to know if postgresql is compatible with power bi. What sql has more advantages in order to work with power bi? Thanks in advace. Nice videos. New subscriptor
@isteaq993 Жыл бұрын
From where I will get the data set
@tayeaina87443 жыл бұрын
Hi thanks for the nice tutorial very informative. Please where can I find the raw data to donload as on your github it too big and it won't download? Thank you in advance