Replace datasource in power bi January 2020 version

[Giada_Togliatti]

Hi, is there a button that allow to replace a datasource with another in power bi desktop January 2020?

Thank you

Giada

[amitchandak]

@Giada_Togliatti , Under the home tab, Click on Data Transformation -> Edit Data Source

[Giada_Togliatti]

I can't find the button, could ypu help me please?

Thank you

[amitchandak]

@Giada_Togliatti , click on data source setting, it should show you the data source and you should able change details ??

Also refer,

https://windowsreport.com/change-data-source-power-bi/

[Giada_Togliatti]

ok thanks,

I wanto to change an excel file with a database from oracle or sql server, but I  can't see the option, I see only option for files

[v-juanli-msft · Accepted solution]

Hi @Giada_Togliatti 

Is your data structure for excel and the database same?

If so, you could create a connection query for the database and replace the excel connection with this database connection in Advanced editor as below:

https://www.youtube.com/watch?v=jnfJDsO2fEs

Best Regards

Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.