Transitioning to Microsoft Power Platform: An Excel User Guide to Building Integrated Cloud Applications in Power BI, Power Apps, and Power Automate

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023

D. DingTransitioning to Microsoft Power Platformhttps://doi.org/10.1007/978-1-4842-9239-6_6

6. SQL for Power BI

David Ding¹  

(1)

Sydney, NSW, Australia

 

SQL Server was launched in 1988. A few decades later, it is still the most common enterprise data storage for structured data. There are many variants of SQL Server, including Microsoft SQL (T-SQL), MySQL, MongoDB, Teradata, PostgreSQL, and AWS Redshift. From an analyst’s perspective, they are mostly the same. If you understand one, you understand the rest. In this chapter, Microsoft Azure SQL Server is used for demonstration.

For the following reasons, knowing SQL (Structured Query Language) is important for ...