Can sql and power query/query editor be used together?
Answer Posted / Pawan Pandey
Yes, SQL and Power Query (also known as Get & Transform in Excel) can be used together to improve data preparation workflows. You can use SQL to extract raw data from databases, and then use Power Query to clean, transform, and shape the data for further analysis. This approach allows you to leverage the power of both SQL for complex queries and Power Query for user-friendly data manipulation.
| 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