Changing a data source

[Hoofit]

I am creating a query in Excel based on a standard datasheet, and I am finding that I cannot add additional columns to the query once I have created the query, so I am having to recreate all my base data in a brand new spreadsheet.  Once created, is there a way of adding additional coluns to the query??

Thanks.

[Anonymous · Accepted solution]

Hi @Hoofit ,

This is the article about changing your existing data source.

The article lists the methods in two cases. Depending on the type of data source you want to replace – you can use one of the below approaches.
1.Replace data source using the same connector
2.Use different data source connector – as data sources are completely different.

Best Regards,

Stephen Tao

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

[Hoofit]

Thank for the reply.  What I do is...

Have an excel sheet

Do Data -> New Query -> From table (Creates a PowerQuery Dataset), when I save this as a new sheet in Excel.  If I wabt to add additional columns from the original datasheet, I cant, or rather I cant see how.

Thanks again

Paul

Hi, is this what you were after, if I want to select additional columns from the target, it does not allow me to add a new selection, or even create a new query.  If I try to create a new query including the ones previously selected by the old query, it tells me that tables cannot overlap.

Thanks again for looking.

Paul

[Hoofit]

If I could just delete the old query, that would help!!

[Hoofit]

Thank for the reply.  What I do is...

Have an excel sheet

Do Data -> New Query -> From table (Creates a PowerQuery Dataset), when I save this as a new sheet in Excel.  If I wabt to add additional columns from the original datasheet, I cant, or rather I cant see how.

Thanks again

Paul

[mahoneypat]

You should be able to just refresh the query to pick up the new columns.  Can you share the M code from the Advanced Editor of your query to help troubleshoot?

Pat

[Anonymous]

When you refer to a "standard data sheet, is that one csv or text file? If so, the Source step probably has a Columns = some number. Just delete that, and ant and all columns will be imported. 

--Nate