How to connect to SQL database in Power BI Desktop
Go Analytics is a data analysis and visualization consulting firm specializing in Microsoft Power BI. For any Power BI inquiries, please visit our website at https://goanalyticsbi.com.
In this video, we take a look at how to connect to data that is stored in a SQL Server database. Using the AdventureWorks sample database, we learn:
** where to find the SQL Server data connector
** the difference between Import vs Direct Query
** how to write our own SQL script
** how to organize our code in the Advanced Editor in Power Query Editor
For more how-to and tips & tricks videos on Power BI make sure to subscribe to our channel.
About Go Analytics Inc.
We are data analysis and visualization consultants specializing in Power BI. We help organizations create and nurture a data culture.
Need help getting started with Power BI? Let's connect!
Visit our website at https://goanalyticsbi.com
Follow us on Twitter at / goanalyticsinc
Connect with us on LinkedIn at / go-analytics-inc
***
Note: Go Analytics Inc. is not affiliated with Microsoft. Thoughts are our own.