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 know the code "Source = Excel.CurrentWorbook()" is used for this but, can someone give me an example of how to use this.
Lets say my table is called "table1" and I want to add is as a query.
Also, if its a sheet, "sheet1"
- 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]
5 Replies
- 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]
- The option is in the Data menu in Excel in newer Office versions, or the Power Query menu in older ones. If adding directly from PQ just make a custom query. And it looks like you're missing the "" around the table name: = Excel.CurrentWorkbook(){[Name="Table1"]}[Content]
