powerquery

What are the differences between Power Query, Power Pivot, Power BI?

I want to make a contribution to the community by presenting these free tools for data analysis using Microsoft and unfortuna ... estions for using the languages M and DAX. Note: I am learning to speak Portuguese, feel free to edit this post if you need.

Read data from an Excel cell for SQL search

I need to run a SQL that brings me a result of only one cell, but, I need to capture information from two. I will enter with ... or could not use. How can I make this query from that cell and load in the script so that the query get simpler for the user?