Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

How to replace Data Source for existing report?

how can i replace data source for existing report?
Need Help
  • ankitpatira's avatar
    ankitpatira
    10 years ago

    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.

     

  • MattAllington's avatar
    MattAllington
    10 years ago

    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.

jwang88's avatar
jwang88
Frequent Visitor
4 years ago

Hi Matt,

 

I have one static Excel as my source file at the momement but it will need a monthly update soon. I have DAX and new measures/caculated columns in it already.

 

Can you please advise whether it is possible to only update the original worksheet with no impact on the modified part?

 

Thanks,

Jing

MattAllington's avatar
MattAllington
Community Champion
4 years ago

I don't really understand what you are asking.  Are you saying the source data is in the same Excel file as a Power Pivot report?  If so, you should separate these out into a source file and a report file.  That is best practice