Summary
In this chapter, we learned to work with the most common data sources supported in Power BI, such as folders, CSV, Excel, Power BI datasets, Power BI dataflows, SQL Server SSAS, and OData feed, with some challenging real-world scenarios. We also went through data source certifications and discussed why it is essential to know which data source certification level we are dealing with. We then looked at connection modes, storage modes, and dataset modes, and at how different they are. It is worthwhile emphasizing the importance of understanding different connection modes, storage modes, and dataset modes as they will directly affect our data modeling and overall Power BI architecture.
In the next chapter, we look at common data preparation steps in the Power Query Editor, along with real-world scenarios.
