Updating Queries

[Anonymous]

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?

[mahoneypat · Accepted solution]

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.  You can then build a new model with the old data from csv/Excel and connect to your new data source too.

Pat

[Anonymous]

Perfect thanks Pat!

-Rich