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.

RitaPT's avatar
RitaPT
Frequent Visitor
9 years ago

Someone change the name in table that I import from a database. I tried the option that you mentioned but this only function from Browser. Do you know if it is possible to change the source inside a document - similar to function "Edit Links" from excel?

Thank you.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi,

There is a solution actually. if you go to ‘Transform data’ and ‘Advanced Editor’ so you can change the sql statement of the data source, you can replace the file name with a new one, which means you can change the data source.

Regards 

Charlotte