Это видео недоступно.
Сожалеем об этом.
How to connect POWER BI with SQL and build an AUTOMATED Dashboard [SQL to Power BI]
HTML-код
- Опубликовано: 7 авг 2024
- 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]
![How to Automate Excel Reports Using SQL [CSV to SQL to Excel Automation]](http://i.ytimg.com/vi/2cZ-Z_j11EE/mqdefault.jpg)
How did you find this process? Are you using a different process to automate your work? Please let me know in the comments below!
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?
@@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
Yes you can set refresh option from power bi for sql server data to automatically refresh from page option pane in power bi.
@@AzizRehman0111 please suggest laptop configuration for data analyst role
@Data360YP please suggest laptop configuration for data analyst role
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.
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.
Thank you for taking the time to create this video. Ive used it many times now for projects Ive created!
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
Short but really detailed and I understood perfectly what I was looking for. Thank you
Thank You man! No idle talk, just practice!
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!!!!!!!!!!!!!
Glad it was helpful!
Gracias por el tutorial! es un éxito! Lo estoy implementado en mi tesis. Saludos desde Perú
Fantastic Power BI tutorial! Your explanation is excellent and much needed. Thank you for sharing your expertise!
wonderful video for beginner to Power BI -- was able to produce my first report :-) Thank you !!
If all youtube instructional videos were like this I would be a Rocket Scientists by now. Thank you!
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.
I needed this for work but all the tutorials were showing from excel sheet. He did a great job!
Super informative and crisp video. Thanks a lot for your efforts!
Great, well explained, sounds easy with you teaching Many thanks
i liked this video without unuseless information and the realy important information!
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
Glad it was helpful!
Thanks a lot for this wonderful tutorial. You are such an amazing teacher.
Glad it was helpful!
This was really insightful! Thanks!
This is a terrific video!! Great work!!
Bro, You are amazing, thanks for the unique, wonderful automated tutorial.
Glad you liked it!
Thank you for this high quality free content.
Glad you enjoy it!
Topics for beginners, but you explain very cool.
I watched to the end. Thanks!!!
Glad you liked it!
Extremely good video for Power BI with SQL server Agent , Execute Procedure , Thank you very much
Very well-explained! Thank you:)
Gracias, pude postular a un trabajo gracias a esto, un genio!
Great tutorial - Like the SQL view details!!!
Glad it helped!
@ Yiannis Pitsillides.. Super video. I was searching for this and found it.. Thank you for all your efforts.
Glad it was helpful!
Amazing video, thank you for such brilliant content
Glad you like it!
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!!!
Excellent. Understood each and every word.
Glad you liked it!
my favourite video so far thank you for the process
You r teaching skills and the method is really a attractive and understandable. Keep it up
discovered your channel. very pedagogic. thanks
Clear and helpful for me -Thanks
Glad it helped
Great Tutorial, many thanks 👏👏👏👏
You’re amazing! God bless you and thank You so much!
Happy to help!
Excellent content. Thanks
Thank you so much for this great video!
You are so welcome!
You're the best hands down!!!!! I need help how to create HTML/CSS dashboard from SQL data
did you found that??
excellent demonstration!
Thank you! Cheers!
Thank you! Excellent video
Glad it was helpful!
Wow great 👍👍👍👍👍 i learn more from ur video and power BI topic 👌👌👌👌👌
U r amazing
Glad you find my videos useful!!
Great Video, Thank you Bro
Thanks, great work
This is awesome 👌🏿
good job , the tutoriel was so clear
Glad to hear that!
so grateful, thank you
You are so welcome
Thanks mate, this is very helpful. In addition, I didn't know that Henrikh Mkhitaryan was good at Databases. Greetings!
Glad it was helpful!
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.
This excellent video, can you also create some detailed videos on ssis and sql
I wish my IT teacher was like you ;)
excellent! thanks
Thanks a lot. This was so useful for me. Can we have the kaggle page where you get the data, please?
Wonderful explanation
Glad you think so!
Thx bro for your video, it was very interesting =)
Really good, looking to implement this with my new data role. Thanks for the video! Hope mines works :P
Thank u so much for that explanation
Glad it was helpful!
Good one
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
Thank you for amazing work. Why do we have to create a stored procedure in SQL?
Thank you! This video helped a lot...after I slowed it down to 3/4 speed lol
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
thank you so much
Great video! Will this only work on MSSQL, or other flavours such as MySQL?
Amazing
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
Really helpful video. Is there a way to do the same with postgres? how can we create a postgres agent job that runs automatically?
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?
Excellent and very informative video Yiannis. Keep it up!
Good tutorial, which website did you download your raw data?
thank you, this video is very helpful for me, can you share a CSV file for my practice
First of all, great video! One question, is it possible to do the same with MySQL?
very informative video and i like your English accent
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?
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 Thanks
You are welcome
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?
Thank you for the great job, is possible to show how to insert data from web api in to sql :) ?
Yes ofc, usually, websites provide documentation on how to connect with their API
interesting video
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
thanks for creting this video please make one video on python with sql also
Thanks
What about the job opportunity in power bi how much salary can be expected can any one pls assist me
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
Could you provide a link to the Kaggle data you used?
Is 'Indicator' a table you have setup in your database? That is confusing me. Thank you for this video.
Finished Watching
ευχαριστώ!
Parakalw :)
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..
Can we have the kaggle page where you get the data, please?
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...?
can we connect power bi with multiple views from sql and create multiple charts in same dashboard?
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..
GOAT 🐐🐐🐐🐐🐐VIDEO
where can i find the sql query for this. ? its not there in ur github
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)
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
Thanks for a great tutorial! Few questions - when creating the table, why are some of the column names in brackets, and some letters capitalized?
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.
@@C1ookieCookie Thank you for your response, it is helpful 😊
Using this method, if my excel file is populated with more data, will it update in my database?
Does it support xlsx files cos mine is coming with an error: bulk load conversion error(truncates) for row 1,column 1 (company)
Try and save the file as CSV from Excel, then try the code in the video
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