is it possible to use python to save a formula table that is not shown in query editor

[Pandadev]

I have built a summary table using this code

union(
summarize('QC Check 1', "Table","QC Check 1", "Rows",countrows('QC Check 1')),
summarize('QC Check 2', "Table","QC Check 2", "Rows",countrows('QC Check 2')),
summarize('QC Check 3', "Table","QC Check 3", "Rows",countrows('QC Check 3')) // so on
)

and I have added an additional Column called Date , with Today() as the formula

What i wanted to do was save the data to a csv file using python , but because the table was created with a formula , it is not showing in the power query editor , so I am unable to link python to it. 

[v-alq-msft]

Hi, @Pandadev 

Based on your description, I'd like to suggest you use 'Query Editor' to achieve your requirement. I created data to reproduce your scenario.

Query1:

Query2:

You may right-click 'Query1' and click 'Duplicate' to copy a 'Query1', go to 'Home ribbon', click 'Append Queries'.

If you want to add a new column with today's date, you may go to 'Add Column' ribbon, click 'Custom Column', set as below.

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Pandadev]

How can I do this when each table has different column names and different numbers of columns. All I need is the count of rows for each table and the table name.

[amitchandak]

@Pandadev , for that You might have to create table in edit query using M.

refer if this can help

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

[Pandadev]

I had a look at the link , but it only mentions append and merge. I could not see how I could create a summarized table from my 6o tables , which only have one identifier column called QC Check. The tables also have different amounts of columns. Is there any other solution. Could I copy that Dax table to a table created in editor ???