Post #2699

18. What is data blending in Power BI? Data blending (sometimes confused with “merge”) usually refers to combining fields from multiple tables at the visualization level, often via relationships or calculated columns/measures rather than ETL-level joins. 19. How do you optimize large datasets? • Use a star-schema model, avoid unnested structures. • Use appropriate data types, remove unnecessary columns. • Prefer measures over large calculated columns, enable incremental refresh, and push heavy filters to the source when possible. 20. What is Get Data? “Get Data” (in Power BI Desktop) is the Power Query interface that lets you connect to various sources (SQL, Excel, Web, etc.), load, and transform data into the model. Double Tap ❤️ For More