Copying query data to a new table witout connection to the database

[acbisogni]

I wanto to create a copy of a existing query to a new table, but I nee to copy only the data and not the source connection to the database. The new table will only copy the existing data in the source table. The new table has to be created in POwer query since I will perform some columns changes, like changing name, creating new columns base on combining queries, etc.

Is it possible?

Thanks, Adriano

[shafiz_p · Accepted solution]

Hi @acbisogni  Yes, it is possible. First convert entire table to text using Binary.ToText and Json.FromValue. Then create a json file from the output text and convert that to fresh new table. See the images below:

This is the original table:

Converted to Text (Red Highlighted Formula):

This is output text. Select and copied to clipboard using Crtl+C:

Created a new blank query and opened advance editor and write the formula. You can now delete steps from original table:

Right click on the bytes file and click Json.

Right click on the list header and select to table.

Now click on the arrow head icon and expand column, and you are done with a fresh new copy of table without the source. Change data types manually and do you desired operation.

Hope this helps.
If this solved your problem, please accept it as a solution!!

Best Regards,
Shahariar Hafiz

[p45cal · Accepted solution]

You could perhaps try right-clicking the table, choose Table, then Unlink from Data Source.

Then click OK on the next dialogue box:

The table will be disconnected from the query that created it, and that query will show as Connection only. You can right-click that query and load to… a fresh table whenever you want:

[shafiz_p · Accepted solution]

Hi @acbisogni  Yes, it is possible. First convert entire table to text using Binary.ToText and Json.FromValue. Then create a json file from the output text and convert that to fresh new table. See the images below:

This is the original table:

Converted to Text (Red Highlighted Formula):

This is output text. Select and copied to clipboard using Crtl+C:

Created a new blank query and opened advance editor and write the formula. You can now delete steps from original table:

Right click on the bytes file and click Json.

Right click on the list header and select to table.

Now click on the arrow head icon and expand column, and you are done with a fresh new copy of table without the source. Change data types manually and do you desired operation.

Hope this helps.
If this solved your problem, please accept it as a solution!!

Best Regards,
Shahariar Hafiz

[dharmendars007]

Hello @acbisogni , 

You can select the existing query or table and click on "Reference" so that this will now be affected by the changes done in database.

If you find this helpful , please mark it as solution and remember to give kudos
 

Thank You

Dharmendar S

LinkedIN