Forum Discussion
Solved
Adding query from the same worksheet
I want to add a query in the powerquery option from Tables inside the worksheet, so far only way I have found to do it is by opening the excel file itself as a query which is very inefficient. I ...
- You can use From Table/Range in the PQ menu area, or this code if you want to code instead: = Excel.CurrentWorkbook(){[Name="MyTableName"]}[Content]
