Interested to Buy Any Domain ? << Click Here >> for more details...
Why do we need power query when power pivot can import data from mostly used sources?
- 1 Answers
- 2 Views
- I also Faced
- E-Mail Answers
Answer Posted / Km Kanchan Rani
Power Query (Get & Transform in Excel) and Power Pivot are both tools for data preparation in Power BI, but they serve different purposes. Power Query is primarily designed for data integration and transformation, allowing users to clean, shape, and combine data from multiple sources. Power Pivot focuses on modeling and analysis of large datasets, providing features like calculated columns, relationships, and aggregations. Although Power Query can import data from many sources, it may still be necessary to use Power Query for more complex data preparation tasks before loading the data into a Power Pivot model.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
No New Questions to Answer in this Category !! You can
Post New Questions
Answer Questions in Different Category
