Connect To Excel Table Or Range Power. Create a new query -- From TableRange. To do this just click somewhere inside the data and press Ctrl T to convert it to an Excel Table.
To search for data in a Power BI featured table select a cell or a range in your Excel sheet containing a value that matches the value in a featured table. The new column will be appended to the right. Right-click the table then in the shortcut menu click Table Convert to Range.
The new column will be appended to the right.
Place the data table on the slide. Step 3 Click on the Connections option in Connections group. If you see the table youre looking for. Add a key column to an Excel table.