https://community.fabric.microsoft.com/t5/Power-Query/Updating-Queries/m-p/2117444#M62425 <P>Hello, I have an old pbix file that pulled data from two sources that no longer exsist but the data pulled is still in my report. I need to keep the data and file as is but need to add a new source that can update the exsisting report visuals with the new data while keeping the old pulled data from the sources that no longer exsist. Is there a way to do this?</P> Tue, 05 Oct 2021 22:40:23 GMT Anonymous 2021-10-05T22:40:23Z https://community.fabric.microsoft.com/t5/Power-Query/Updating-Queries/m-p/2117444#M62425 <P>Hello, I have an old pbix file that pulled data from two sources that no longer exsist but the data pulled is still in my report. I need to keep the data and file as is but need to add a new source that can update the exsisting report visuals with the new data while keeping the old pulled data from the sources that no longer exsist. Is there a way to do this?</P> Tue, 05 Oct 2021 22:40:23 GMT https://community.fabric.microsoft.com/t5/Power-Query/Updating-Queries/m-p/2117444#M62425 Anonymous 2021-10-05T22:40:23Z https://community.fabric.microsoft.com/t5/Power-Query/Updating-Queries/m-p/2117599#M62428 <P>You can "Copy Table" by right clicking in the Data View and paste it in Excel or (if many rows) you can use DAX Studio to export your data as csv or excel.&nbsp; You can then build a new model with the old data from csv/Excel and connect to your new data source too.</P> <P>&nbsp;</P> <P>Pat</P> Wed, 06 Oct 2021 01:20:03 GMT https://community.fabric.microsoft.com/t5/Power-Query/Updating-Queries/m-p/2117599#M62428 mahoneypat 2021-10-06T01:20:03Z https://community.fabric.microsoft.com/t5/Power-Query/Updating-Queries/m-p/2117674#M62432 <P>Perfect thanks Pat!</P><P>&nbsp;</P><P>-Rich</P> Wed, 06 Oct 2021 01:56:03 GMT https://community.fabric.microsoft.com/t5/Power-Query/Updating-Queries/m-p/2117674#M62432 Anonymous 2021-10-06T01:56:03Z