topic Re: Changing a data source in Power Query

Changing a data source

Hoofit — Wed, 14 Jul 2021 08:24:27 GMT

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.

Re: Changing a data source

Anonymous — Wed, 14 Jul 2021 16:21:40 GMT

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

Re: Changing a data source

Hoofit — Thu, 15 Jul 2021 06:06:28 GMT

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

Re: Changing a data source

mahoneypat — Thu, 15 Jul 2021 11:53:37 GMT

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

Re: Changing a data source

Hoofit — Thu, 15 Jul 2021 12:36:08 GMT

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

Have an excel sheet

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

Re: Changing a data source

Hoofit — Thu, 15 Jul 2021 12:37:27 GMT

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

Re: Changing a data source

Anonymous — Mon, 19 Jul 2021 09:42:56 GMT

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.