Summary
From this chapter, you have learned about the numerous ways in which you can connect data to Power BI and Excel. One of the greatest advantages of this is the different types of connections that Power BI can connect to, including from a single file, folder, SQL database, Azure to Online services, and so on. One of the more powerful features is that you can connect to other data sources that are not listed and that you can create custom connections. Power BI creates datasets that are both the data source and the data itself. Every time you connect to your data, Power BI creates a dataset. This is then used for creating your reports and visualizations.
In the next chapter, you will learn how to transform the data that you now have in Power BI and Power Query.