Solved: Updating Queries

Anonymous · ‎10-05-2021

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 · ‎10-05-2021

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

Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.

@mahoneypa HoosierBI on YouTube

View solution in original post

mahoneypat · ‎10-05-2021

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

Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.

@mahoneypa HoosierBI on YouTube