Forum Discussion
How to replace Data Source for existing report?
Anonymous In power bi desktop go to query editor, select your table and on the right hand side under Applied Steps click settings icon. You can also without going to query editor - go to File -> Options and settings -> Data source settings >Right click data sources and chnage source.
go into Edit Queries. Find the table/query you want to change. Go to the first step in the Query (always called Source) and change it there.
Hi, Are the field names the same? If so, what I've done to make this easier and it seemed to work, is:
1. In Edit Queries, I added the new source table.
2. Then I clicked on the new source table, and then clicked Advanced Editor.
3. In the new source's Advanced Editor pane, I copied the commands with CTRL-C. Clicked Done.
4. Then I clicked on the old table, and clicked on Advanced Editor, selecting all the commands here, and then pasted the new source information using CTRL-V.
5. When you apply the changes, this should point your old query to the new source, and you should actually be able to delete the new table you added as it will now appear twice.
Please NOTE: you have to take care here if you performed any transformations. You may have to repeat them or edit the commands accordingly.
I hope this helps. Everyone's situtation and environment is different, so perhaps this may or may not work for you.
Dear Shelley,
Your suggstion worked like a charm. I wanted to change the source file of a table, saved in Excel.
Thanks.
danishhussain Thanks for the feedback. I'm glad this helped you!