Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to 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
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
Can we do this when our source is excel file?
Hi rabiafarooq,
Of course you can, all of the data source supported like below can be refreshed in power bi desktop.
Regards,
Jimmy Tao
Thank you so much ! cheers 🙂