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.
Thanks Shelley Your solution saved me a lot of time. However, I do want to point out that "Edit Queries" is the old name for today's "Transform Data" to open Power Query. Microsoft changed that a while ago, but beginners like me may not be aware of this.
https://community.fabric.microsoft.com/t5/Desktop/Cannot-find-the-Edit-Queries-icon/td-p/971317
Thanks for the clarification! Was looking for this solution in 2024 and got a bit confused.