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:
/ data360yp
Data Analytics Course Link:
ipidata.teachable.com/
GitHub Files:
github.com/Pitsillides91/Powe...
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:
• • How to build a Power B...
Power BI Dashboard creation:
• • COVID 19 Trends & Fore...
• • How to Deploy a Machin...
• • Building a Power BI Da...
SQL Tutorial Links:
a. • SQL Tutorial for Begin...
b. • SQL Tutorial for Data ...
c. • How to Join Tables in ...
SQL most common queries:
- • SQL Examples For Pract...
Yiannis Pitsillides on Social Media:
/ pitsillides91
ypexists?h...
www.pinterest.co.uk/pitsillid...
/ 1500092413449073
Tags:
How to connect POWER BI with SQL and build an AUTOMATED Dashboard [SQL to Power BI]

[@Data360YP]

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

[@norpriest521]

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?

[@Data360YP]

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

[@AzizRehman0111]

Yes you can set refresh option from power bi for sql server data to automatically refresh from page option pane in power bi.

[@ksp7582]

@@AzizRehman0111 please suggest laptop configuration for data analyst role

[@ksp7582]

@Data360YP please suggest laptop configuration for data analyst role

[@karendavis2380]

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.

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

[@garciaoscar7611]

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

[@alexanderpotapkin2074]

Thank You man! No idle talk, just practice!

[@ayencoscolfield3312]

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

[@Data360YP]

Glad it was helpful!

[@anthonyd4539]

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

[@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 helpful!!!!!!!!!!!!!

[@Data360YP]

Glad it was helpful!

[@user-ex5xp5mk1u]

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

[@SunshineDT2010]

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

[@AugustaEbere]

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

[@kwesi7410]

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

[@annajichanatu3]

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.

[@ann_s6692]

I needed this for work but all the tutorials were showing from excel sheet. He did a great job!

[@amit2888]

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

[@gabriellazaromoran1767]

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

[@ponchyponchy687]

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

[@shekharsrivastava5535]

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

[@Data360YP]

Glad it was helpful!

[@DianethLizarraga]

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

[@KalugampitiyaJayakody]

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

[@khayolnoranjov918]

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

[@Data360YP]

Glad you liked it!

[@theghostrisa2745]

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

[@CMKaplan]

Thank you for this high quality free content.

[@Data360YP]

Glad you enjoy it!

[@kennethstephani692]

This is a terrific video!! Great work!!

[@April417Baby]

my favourite video so far thank you for the process

[@marioestrada2233]

This was really insightful! Thanks!

[@manideepgupta2433]

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

[@Data360YP]

Glad you liked it!

[@bouseuxlatache4140]

discovered your channel. very pedagogic. thanks

[@sunilnallagonda1389]

Excellent. Understood each and every word.

[@Data360YP]

Glad you liked it!

[@yutianwanggg]

Very well-explained! Thank you:)

[@srinigompadai884]

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

[@Data360YP]

Glad it was helpful!

[@spicer7208]

Great tutorial - Like the SQL view details!!!

[@Data360YP]

Glad it helped!

[@alextagbo7504]

Great Tutorial, many thanks 👏👏👏👏

[@nickarrigo5540]

excellent demonstration!

[@Data360YP]

Thank you! Cheers!

[@tubeitz]

Amazing video, thank you for such brilliant content

[@Data360YP]

Glad you like it!

[@joshi1q2w3e]

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

[@Data360YP]

Happy to help!

[@matheusesteves4636]

Thank you! Excellent video

[@Data360YP]

Glad it was helpful!

[@UU-ry6gt]

I wish my IT teacher was like you ;)

[@andreasp.189]

Excellent and very informative video Yiannis. Keep it up!

[@claudiosilva7697]

Excellent content. Thanks

[@sepidehzamani7416]

Thank you so much for this great video!

[@Data360YP]

You are so welcome!

[@Yassou1985]

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

[@AMATAKEYCHANNEL]

Clear and helpful for me -Thanks

[@Data360YP]

Glad it helped

[@svrkraju654]

Wonderful explanation

[@Data360YP]

Glad you think so!

[@imsynyster1636]

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

[@rayy4444]

Great Video, Thank you Bro

[@LIV-FREE-VET]

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

[@ashishmohan4707]

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

[@Data360YP]

Glad you find my videos useful!!

[@musajallow5013]

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

[@ejazsiddiqui6820]

did you found that??

[@jaffeth4954]

Thanks, great work

[@easylifewithchaimae5687]

good job , the tutoriel was so clear

[@Data360YP]

Glad to hear that!

[@adewalem5474]

This is awesome 👌🏿

[@ruesaintdenis]

so grateful, thank you

[@Data360YP]

You are so welcome

[@zouhairarroud9315]

Thank u so much for that explanation

[@Data360YP]

Glad it was helpful!

[@nicolethornsbury4263]

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

[@chaudiep8274]

thank you so much

[@nicolascortes6631]

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

[@Data360YP]

Glad it was helpful!

[@saleemmalik84]

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

[@hugobohorquez7450]

excellent! thanks

[@user-lm5wb8vi1x]

Finished Watching

[@favoh96]

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

[@edge6192]

Amazing

[@sia_ibk]

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.

[@karthickkalaiarasu8736]

Good one

[@Griffindor21]

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

[@alexsamuel9502]

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

[@manasijoshi7145]

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

[@ahmedkharrat1783]

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

[@patansadathalikhan2350]

GOAT 🐐🐐🐐🐐🐐VIDEO

[@najah3244]

interesting video

[@trinnymimi1]

Good tutorial, which website did you download your raw data?

[@juanneira7161]

Great Thanks

[@Data360YP]

You are welcome

[@anuj1526]

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

[@PakFan786]

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

[@martinpedersen5344]

First of all, great video! One question, is it possible to do the same with MySQL?

[@thepassingpawn]

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

[@chenchang72]

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?

[@Malebuza]

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?

[@tayeaina8744]

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

[@annecage3199]

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?

[@ilikedigitallogic5059]

Thanks

[@aschaithra775]

What about the job opportunity in power bi how much salary can be expected can any one pls assist me

[@chandragiovanni8634]

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.

[@zaheerbasha8815]

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

[@santiagoalonso7257]

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

[@vishnu1139]

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

[@davidc2072]

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

[@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

[@MoonShine-bs6cl]

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

[@thanasisathanasi4965]

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

[@adelsafou9850]

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

[@abedaarabi3014]

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

[@Data360YP]

Yes ofc, usually, websites provide documentation on how to connect with their API

[@user-ry4jd3mb7q]

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

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

[@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

[@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

[@ellaazova336]

ευχαριστώ!

[@Data360YP]

Parakalw :)

[@Bringit2uSports]

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

[@jimmynov79]

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

[@calummascarenhas611]

Thanks for a great tutorial! Few questions - when creating the table, why are some of the column names in brackets, and some letters capitalized?

[@C1ookieCookie]

Don't know if you are still looking for a reply 4 months later but might be useful to someone else. The capitalisation is personal preference, it doesn't matter if it is upper or lowercase. The squared brackets are used when the name you are using for a column has either spaces OR the word you are using is a word that means something else in the SQL language, like 'time' for an example.

[@calummascarenhas611]

@@C1ookieCookie Thank you for your response, it is helpful 😊

[@soumyasanjeevkumar6060]

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?

[@vatsal715]

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

[@Mr.Cardoze]

where can i find the sql query for this. ? its not there in ur github