Hello,
If I create a power query and name that power query in the query editor "Sales.Data", when I close and load the query into Excel, is the name of the table that is placed into the Excel worksheet Sales.Data, or is it another name with the fragment Sales.Data in it?
Also, when I create power queries in the query editor, can I use the period separator? For example, instead of Sales_Data, can I use Sales.Data?
Sincerely,
Bruce 
Hi Bruce,
PQ will name the queries after the source. If it's a folder, the query will have the folder name as the query name.
If it's a table, query name will be table name, but when loading results to sheet, the result will have Table1_{number} appended to initial source table name, because there already is a table with the same name - Table1.
Periods and quotation marks cannot be used in a query name.
