Forum Discussion
How to replace Data Source for existing report?
how can i 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.
If you change your data source or update it, do you lose any Dax or measures you built? Will it over-ride any additional columns you built during transformations and or in the dataview of the tables?
- Hi, Actually if you dont delete any steps that were made before, all the changes made earlier will be the same. Just make sure that your new dataset have tha same structure that the old one had or you'll get some error saying the columns or anything else was not found.