Question: what is the difference between power query and power bi?
Answer: Power BI is a completely separate tool that has both of these tools included. It has more connection options than Power Query in Excel. It also has better visualizations and can publish to the Power BI Service for better sharing of reports.