How to connect POWER BI with SQL and build an AUTOMATED Dashboard [SQL to Power BI]

Learn how to fully automate your Reports in Power BI using SQL in order to minimize any manual work. First, we go through how to automate your data import from CSV to SQL. Then, we explain how to create an SQL view selecting the data you need. Afterwards, we explain how to create an SQL store procedure with all the steps needed. Then we go through how to schedule SQL jobs in order to run themselves. Finally, we explain how to connect SQL with Power BI and build an automated Power BI Dashboard. Hope you enjoy this video!

Support the channel on Patreon:

Data Analytics Course Link:

GitHub Files:

Overview:
• How to fully automate Power BI reports using SQL
• How to automate SQL imports
• How to create a view in SQL
• How to create a store procedure in SQL
• How to schedule jobs in SQL
• How to connect Power BI with SQL – via a view
• How to create an automated Power BI Dashboard

Power BI Tutorial Links:

Power BI Dashboard creation:

SQL Tutorial Links:

SQL most common queries:

Yiannis Pitsillides on Social Media:

Tags:
How to connect POWER BI with SQL and build an AUTOMATED Dashboard [SQL to Power BI]

[DataYP]

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

[karendavis]

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.

[anthonyd]

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

[donjoncho]

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.

[garciaoscar]

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

[alexanderpotapkin]

Thank You man! No idle talk, just practice!

[AugustaPromise]

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

[ayencoscolfield]

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

[exxpmku]

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

[SunshineDT]

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

[kwesi]

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

[amit]

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

[tinypandas]

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

[DianethLizarraga]

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

[gabriellazaromoran]

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

[KalugampitiyaJayakody]

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

[ponchyponchy]

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

[kennethstephani]

This is a terrific video!! Great work!!

[annajichanatu]

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.

[AprilBaby]

my favourite video so far thank you for the process