How to use SQL with Power BI 💡 ~ End-to-end Demo with Sample Files

Do you want to use SQL with Power BI to take your data analysis to next level? Join me on this free & live masterclass to learn how to set up SQL queries as data source, how to parameterize them in your Power BI report.
We will be using the FREE Awesome Chocolates Dataset for this live stream. Download the dataset .SQL file from below link.
chandoo.org/wp/learn-sql-for-...
⏱ In this video:
=============
0:00 - Introduction and hellos
5:04 - Agenda slides
8:37 - Where to download the sample data (SQL files)
16:10 - Introduction to SQL
30:15 - How to get SQL data into Power BI?
44:37 - Creating a simple Power BI report
1:04:00 - How to parameterize the query?
1:22:56 - How to show the parameter values on the Power BI report? (product codes etc.)
1:30:30 - How to parametrize dates?
1:39:47 - How to show "last updated date" on the Power BI report?
1:44:30 - Other questions & Closing remarks
💡💻 LEARN MORE:
================
SQL - Full course - • Learn SQL for Data Ana...
Power Pivot - • Learn Power Pivot & DA...
Power Query - • Power Query Tutorial -...
Power BI - • Beginner to PRO Data A...
+ Full course - chandoo.org/wp/power-bi-course/
#SQL #PowerBI #realtimeproject

[@alfredoluwatomi6899]

Many thanks Chandoo you are always an awesome guy upskilling people for free.Kudos to you.

[@Sayan_Biswas.]

people charges 1000 for this , but you did it for free with such quality. thanks a lot

[@pieterlinden8292]

Oh I'm sooo bummed I missed this!!! A really cool thing to do might be to use Parameters to switch databases/stored procedures/tables etc. (Can you pass values via PowerBI parameters to stored procedure calls? I would think you could basically frankenstein a string together and pass that back to SQL Server.)

[@naturalhealth6033]

Hi Chandoo, I am from Pakistan. Love your work and wish you health, wealth, and happiness. This is the best video, not only on KZbin but also on the internet that I have ever seen. You deserve a gold medal.

[@saidarao1750]

Truly you are lifting my career chandoo ji

[@harishbharadwaj4772]

thankyou so much sir!!! very engaging and fascinating narration

[@rajeswarynadarajan8347]

Thank you chandoo baiya...I'm from Malaysia.. this video was very helpful for me.. god bless you

[@Khan-mc3gi]

thank you chandoo u are great we are learning alot from your video

[@swastiktripathy8412]

Thanks for the amazing session.

[@TataNaresh]

Hey chandoo you are an awesome trainer the way you teach concepts is amazing 👍🤩

[@peterdavey8348]

I'm a long-time user of T-SQL and am just getting into PBI. I've been desperately looking for something like this.

[@AliAli-xt6ow]

Hi Chandoo, I made my first Power BI dashboard courtesy of your video..Thanks.

[@chandoo_]

Great Ali. More power to you ⚡

[@dannyboysharma7953]

Supercool Chandoo ... You made my day by sharing ❣️ this awesome chocolate ❣️ 🍫 videos

[@sowjanyakake5720]

At 36:31, to change the table name instead of clicking the 'Edit query' we can use 'Rename' option in the same options popup.

[@muralikrishnan4210]

Sir Great job. People like me cannot afford lot of money to learn this.

[@tejasthete7007]

Thanks sir your vedio help me a lot.

[@Aeavcccccgv]

Thank youuuu you are the best

[@mohamedqadarabdi1273]

Many thank our beloved teacher u increased my knowledge about data analyst thanks alot I would to ask to make a video how to analyse quickbook desktop and power pi

[@nicoleleung5105]

Hi Chandoo, thanks for your help! Could you please revise the video title or hashtag sth for searching this project easily? I almost missed this good project training! I think this video is good for making the first data analyst project. =))

[@jmr39]

Great video and exactly what I was trying to find! I am curious why in the join you have the '.' after the alias(s). I see it only pulls the sales columns, but I can't find any information about the '.*' technique. Thanks again

[@user-sp1es2lh3z]

Very nice.. thanks brother

[@harikagotluri9084]

love this class

[@sunnygawande5283]

Awesome vdo, loved it 😍😍😍😍

[@ShahnawazKhan-xl6ij]

Thanks for sharing

[@SupriyaGhosh-qu1nt]

Hello SIr, You are making really awesome videos. Please try to make a video on tableau full course along with projects where sql is implemented. It will be very helpful video for many of us

[@wizanoful]

Q: could we not have added a slicer for Products so the report is filtered based on the selection instead ?

[@niharika5765]

Thank you!!

[@mohammadaffan5001]

I'm getting error on powerBI while connecting to mysql workbench-"Microsoft sql-a networks related or instance specific error occurred while establishing a connection to SQL server .the server was not found or not accessible and verify that SQL server is configured to allow Remote connections"...this is displayed always...i've watched tons and tons of videos..and still isn't resolved... please help me out..😢

[@LaloinLondon]

Question What is faster to extract some records from an large Access table into Excel: 1. Power query with filters? 2. Power pivot with filters? 3. Power pivot with SQL commands? 4. VBA module where an ADO connection? Regards, George

[@testprime4248]

Thank you

[@akashpatil9865]

Thanks for the KT. Please make a video o Power Query ( full functionality introduction)

[@nadaalattag3555]

Hello Chandoo, I am from Sudan I really like your way in explanation , simple and clear and thank you so much for this LIVE 😃

[@amrit9037]

sqlbolt and w3resource have good beginner friendly practice questions.

[@chandoo_]

Thanks for sharing!

[@YemiAdeyemiDelateur]

Greetings from Nigeria

[@soumyendupaul9556]

Great. Could you use Direct Query in near future to create PowerBI dashboard

[@user-lx8ni4tq6b]

superthanks

[@kpkp349]

if you like, you can just double click on the actual chart title to change it rather than doing it in the format visual pane

[@nandokha.w.collins6571]

nice , which book can you recommend for data analysis and data science

[@alphabarry3448]

Hello chandoo, I have a table that contains two movements type incoming and outgoing represented by the sign + and - but some cancel each other out is there any way in excel or power query that could spot those who cancel each other out without going row by row? Thank you

[@chandoo_]

See this video please - kzbin.info/www/bejne/r2SkeGSDlspgpac

[@stefanyloren]

What is the case if using MySQL if I can upload the data to power BI and use DAX to make the analysis. Please answer me. Thanks

[@burakdogan5734]

Greeting from turkey

[@nileshtailor9036]

Thanks

[@chandoo_]

Thanks for the love and super Nilesh 😍

[@rajkishan6286]

Hi sir I have a question regarding the percentage criteria in btech as i have less than 60 percent can I get a job in data analytics. Please reply i also have 1.5 experience in etl

[@opejoseph6814]

Thanks for your videos. But I want to ask if you’ll be having a detailed video on “Limitations of using Direct Query Connection in PowerBI” and how to overcome those limitation. I’m currently facing such issue where I can’t visual any column I created using datediff() on the date column I imported from my live data warehouse, I get an error that says PowerBI cannot food the expression…use a simpler expression… thanks

[@chandoo_]

I haven't worked much with Direct Query option, so can't comment. I suggest reading up on this a bit more to figure out what is going on.

[@opejoseph6814]

@@chandoo_ okay thanks I have but I guess I still have a lot reading to do then. Thanks

[@user-kg8vf1nn9q]

how can i put parameter into slicer to get the detailes quickly

[@yonaszewdu149]

please give us sample projects for exercising

[@akshaypatil8155]

when i write 'P05' or anything in the parameter , after close and apply, the changes are not happening on the report/dashboard. in your case it is happening 1:19:07 plz reply

[@yaswanthpidugu2310]

I'm getting this suggetion to connect with the MySQL database the suggetion is " the connector requires one or more additional components to be installed before it can be use " help with this .

[@mohsinrizvi6988]

Hello chandoo you r doing well. I have a q for you. I have db of sql TB I Wana show in website or web page how I do this??

[@bankaprashanth5022]

can we use MS SQL for this

[@soodvarun20]

Hi Chandoo. I have been trying to download the dataset file in my SQL SSMS but it is not happening. Can you please reply back as to what steps one has to do in order to get the data on my SSMS . I am new to the SQL so probably I may be missing on a few steps of how to get the data/ restore or extract the data. Thanks in Advance and hope you can help me out on this ...

[@uravshukla]

Hey! What if my query has a relative date clause? I tried parameterizing the "7" and it is throwing me an error where date>= dateadd(days, -7, current_date)

[@Rittiik]

Sir tell me the important questions which will be asked in the interview

[@RaviKumar-rp4hn]

@Chandoo. How you have connected the data to my sql workbench. Suggestion: Please don't skip imp points.

[@chandoo_]

The process is explained in the video description. Please read completely.

[@Rohit-tt5xe]

What are the benefits of using this Query1 parameter we could have used a simple Slicer and selected a single product from their as well ??

[@nishanthprabhuk4704]

Exactly the same question.

[@eltoski01]

Okay let me rephrase my question better... lets say for example i perform an sql query to get total number of orders from a table and the result is returned in the result tab. how do I access this result in power BI so that I can visualize it ?

[@ashwanikumarkaushik2531]

I am getting an error while uploading the awesome chocolate database into postgre sql. Please help!

[@user-pj8zg2yr2d]

hello sir i am facing this error while trying to connect MY SQL with power bi "Details: "An error happened while reading data from the provider: 'A call to SSPI failed, see inner exception.'" can you help me fix it.

[@chiji1757]

This could easily be a 20 minutes video, please try to keep it short and straight to the point. Good content by the way!

[@chandoo_]

Thanks. It is a live stream and usually long with many Qs, side tracks and other tips.

[@naturelover7998]

hi chandoo, we can't change "reportdate" value as a parameter, it's a fixed value

[@Rakshita_Goutam]

Please help me , I am getting error in Power BI tool connect with MySQL how to solve this. This connector required one or more additional components to be installed before it can be used

[@sapnasaini851]

same problem with me too......I clicked 'learn more' and download the extension but it is showing the same problem again.

[@user-qo2eb4wm1e]

yes

[@PK-iu9nc]

Hi Chandoo, I have an excel file tried to import it into SQL workbench, I got an error. I tried converting excel file into an SQL file, Iam failed in doing so. Could you please tell me, Is it possible to import excel files to workbench ? If yes, How ? If not, Tell me the another approach. Kindly revert back.

[@akshaypatil8155]

what language is this to become pro at writing such queries??????? 1:34:01

[@akshayam9539]

Q: i tried connecting mysql data base but it's showing that additional components to be installed before it can be used. How to connect now?

[@sapnasaini851]

same problem with me too......I clicked 'learn more' and download the extension but it is showing the same problem again.

[@ravisunkara6664]

Hello Sir, i have small query on connection part. usually it asks Direct or import mode whenever connect sql server, but here i don't see it. could u pls help me onthis

[@chandoo_]

Not all database servers support "direct query" option.

[@YemiAdeyemiDelateur]

, yes

[@shrawan2042]

Currently how much of demand for bi dev jobs

[@eltoski01]

The queries you carried out in mysql did it affect the tables... like for example if you query GEO table will the result of the query affect the GEO table....Im not sure I'm asking the question correctly cause I'm quite confused....what does the queries do? Like what are they affecting, are they producing a new table ? I'm confused

[@chandoo_]

All these are "read" or "select" queries. So no updates are made, just reading the data. See this video to learn more about SELECT queries for Data Analysis work - kzbin.info/www/bejne/ommndIOXfchoirM

[@eltoski01]

​@@chandoo_okay thank you

[@sureshmallipeddi5570]

❤❤❤

[@krishnasrinivas3583]

Hi Have a T-SQL Query to check space of the database or Databases in a MS SQL Instance. I need to create a report, Initially The report will be empty. I will use one Drop down for SQL Instance Name .. Once it is selected, in next drop down it will list all the databases .will pick one Database in it. after select both will Click on a button or any other link( Not Sure what to use and how it works ) The button/Link should fire my query and display the result in the same page below. How to create a report this way. I am a SQL DBA and need to create more such reports for different use cases. provide me link if you have covered such topic. Hoping for your reply. Thanks in advance.

[@mohanreddy007]

Sir With Power BI and Sql can i get job as entry level fresher Please reply

[@earlymorningcodes6100]

Hi cahndoo while connecting the mysql database I am facing the issue - -Details: "An error happened while reading data from the provider: 'Character set 'utf8mb3' is not supported by .Net Framework.'" Please help me

[@rajeev7957]

I am also getting same,what you did

[@earlymorningcodes6100]

@@rajeev7957 uninstall and then download again

[@rajeshgunjal09]

"awesome chocolates" in date base Name Space between two word beacause of which unable select sales Table can anyone Help me how i can get rid off that space

[@sapnasaini851]

use back ticks like `awesome chocolates` you will not face any error then.

[@kaleongyung117]

build MS SQL capacity planning report using power BI desktop

[@VinayKumar-dz7tw]

Q: how to auto refresh data

[@kishorek4879]

Hi Anyone there to help to get a job in powerbi developer

[@foodieplus1552]

Sir i. am unable to connect mysql with power bi

[@sapnasaini851]

same problem. could you resolve this ?

[@Manisha-bu5zb]

It ia veey Difficult to learn on mobile as veiw is very small

[@chandoo_]

Try on a proper computer.

[@UthirasTales]

how to use Power Bi in Mac.

[@akshaypatil8155]

You know the best but are u recording on 720p?. Now-a-days people have full HD screens so 720p does not give very clear video quality. During livestreaming or recording we don't understand the quality but while viewing it does make a difference. You can double check by just playing this video on normal laptop screen, in video quality gear, maximum resolution given is 720p. It should have been 1080p atleast. and Thank you for everything....i would gift u a wine if our road crosses someday....

[@chandoo_]

Unfortunately, the live stream software I have can only go up to 720p.

[@1yyymmmddd]

Didn't Microsoft make Power BI so that folks don't have to learn SQL ?

[@user-of9lw7pd2r]

No, u need basic knowledge of sql

[@1yyymmmddd]

@@user-of9lw7pd2r Why? Working with Power BI since its inception - never used any SQL. Power BI builds SQL for you.

[@yonaszewdu149]

milk

[@emregazi4615]

God i wish someone could fix the indians people accent😂 they always talk about what i need. But it is very hard to understand

[@chandoo_]

Hmm.. It is pretty selfish to want 1.4 bn people change their way of speaking so you can understand. Why not learn how it works? Won't take long and you get to enjoy more content, songs, movies and company of people.

[@rohanverma8929]

Your video is informative but too slow. No body have 2 hrs to spend. You can be a little quick to be more effective.

[@chandoo_]

Did you hear about the amazing "forward" feature of KZbin? This is a recording of live session. There is no editing in live.

[@Dominknows]

entitled people think they are too good to fast forward or speed up the video like everyone else i guess lol @@chandoo_

[@user-hl7jb8nk9c]

select geo.*,sales.* from geo, sales where geo = 'Canada'and Amount >5000 order by Boxes;