How did you find this process? Are you using a different process to automate your work? Please let me know in the comments below!

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

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.

If all youtube instructional videos were like this I would be a Rocket Scientists by now. Thank you!

i liked this video without unuseless information and the realy important information!

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.

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!!!!!!!!!!!!!

Thank you for taking the time to create this video. Ive used it many times now for projects Ive created!

You r teaching skills and the method is really a attractive and understandable. Keep it up

Extremely good video for Power BI with SQL server Agent , Execute Procedure , Thank you very much

Thank You man! No idle talk, just practice!

wonderful video for beginner to Power BI -- was able to produce my first report :-) Thank you !!

Thanks a lot for this wonderful tutorial. You are such an amazing teacher.

Short but really detailed and I understood perfectly what I was looking for. Thank you

Fantastic Power BI tutorial! Your explanation is excellent and much needed. Thank you for sharing your expertise!

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

Topics for beginners, but you explain very cool. I watched to the end. Thanks!!!

You're the best hands down!!!!! I need help how to create HTML/CSS dashboard from SQL data

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.

my favourite video so far thank you for the process

This is a terrific video!! Great work!!

Gracias por el tutorial! es un éxito! Lo estoy implementado en mi tesis. Saludos desde Perú

Super informative and crisp video. Thanks a lot for your efforts!

Finished Watching

excellent demonstration!

Excellent. Understood each and every word.

Really good, looking to implement this with my new data role. Thanks for the video! Hope mines works :P

Thank you for this high quality free content.

Excellent and very informative video Yiannis. Keep it up!

very informative video and i like your English accent

I wish my IT teacher was like you ;)

You’re amazing! God bless you and thank You so much!

@ Yiannis Pitsillides.. Super video. I was searching for this and found it.. Thank you for all your efforts.

Wow great 👍👍👍👍👍 i learn more from ur video and power BI topic 👌👌👌👌👌 U r amazing

Bro, You are amazing, thanks for the unique, wonderful automated tutorial.

Thank you! Excellent video

¨Ελα ρε κυπραίο! Καλή η δουλειά σου !

This was really insightful! Thanks!

discovered your channel. very pedagogic. thanks

Great, well explained, sounds easy with you teaching Many thanks

Thanks mate, this is very helpful. In addition, I didn't know that Henrikh Mkhitaryan was good at Databases. Greetings!

Gracias, pude postular a un trabajo gracias a esto, un genio!

Thank you! This video helped a lot...after I slowed it down to 3/4 speed lol

good job , the tutoriel was so clear

Great Tutorial, many thanks 👏👏👏👏

Thank you so much for this great video!

Great video and thank you.

thanks for creting this video please make one video on python with sql also

Great tutorial - Like the SQL view details!!!

Very well-explained! Thank you:)

Thx bro for your video, it was very interesting =)

so grateful, thank you

Clear and helpful for me -Thanks

thank you so much

Excellent content. Thanks

Thanks a lot. This was so useful for me. Can we have the kaggle page where you get the data, please?

Wonderful explanation

GOAT 🐐🐐🐐🐐🐐VIDEO

Thanks, great work

This is awesome 👌🏿

Amazing video, thank you for such brilliant content

Thank u so much for that explanation

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

Thank you for amazing work. Why do we have to create a stored procedure in SQL?

excellent! thanks

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?

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?

Is 'Indicator' a table you have setup in your database? That is confusing me. Thank you for this video.

Amazing

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..

Thanks

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?

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..

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

Really helpful video. Is there a way to do the same with postgres? how can we create a postgres agent job that runs automatically?

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.

Good one

Could you provide a link to the Kaggle data you used?

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!!!

Great Thanks

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

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

This excellent video, can you also create some detailed videos on ssis and sql

interesting video

can we connect power bi with multiple views from sql and create multiple charts in same dashboard?

Can we have the kaggle page where you get the data, please?

Using this method, if my excel file is populated with more data, will it update in my database?

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.

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?

thank you, this video is very helpful for me, can you share a CSV file for my practice

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...?

Thank you for the great job, is possible to show how to insert data from web api in to sql :) ?

Great video! Will this only work on MSSQL, or other flavours such as MySQL?

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

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)

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?

I am unable to download the CSV file, kindly suggest.

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

From where I will get the data set

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