Is there any way that if i manipulate data in the original source the exported data is also updated?

[rabiafarooq]

Is there any way that if i manipulate data in the original source , the exported data is also updated and hence the visuals as well?

[v-yuta-msft · Accepted solution]

Hi rabiafarooq,

In power bi desktop, you can just click “Refresh” button in home ribbon or “Refresh Preview” button in Query Editor when using import or direct query\live connection mode.

In addition, you can’t connect to multiple data sources with direct query\live connection mode. If the first data source is using direct query\live connection mode, the second data source will be switched to import mode.

Regards,

Jimmy Tao

[rabiafarooq]

Can we do this when our source is excel file?

[v-yuta-msft]

Hi rabiafarooq,

Of course you can, all of the data source supported like below can be refreshed in power bi desktop.

 

Regards,

Jimmy Tao

[rabiafarooq]

Thank you so much ! cheers 🙂