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]
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]
I got this error when I try
"Formula.Firewall: Query 'Query1' (step 'Source') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination."
Formula was
=Excel.CurrentWorkbook(){[Name=Table1]}[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]