Forum Discussion
Post ProdigyConnecting to Oracle database concept question
wpf_ , In case of import mode data remains in power bi. In case of direct query it will be there in Oracle.
Refer this
https://radacad.com/directquery-live-connection-or-import-data-tough-decision
and supported source for direct query
https://docs.microsoft.com/en-us/power-bi/connect-data/power-bi-data-sources
Super Userwpf_ , In case of import mode data remains in power bi. In case of direct query it will be there in Oracle.
Refer this
https://radacad.com/directquery-live-connection-or-import-data-tough-decision
and supported source for direct query
https://docs.microsoft.com/en-us/power-bi/connect-data/power-bi-data-sources
Post Prodigy
Thanks for that article very imformative. I connected via Import before so I guess I was importing the data into my laptop. So if that was not what I intended to do, and if i wanted to get rid of that data on my laptop, I'd just needed to delete the the pbix file?
In the case with DirectQuery, since I am connected to the actual data source in Oracle, in the report module in BI desktop, If i happened to delete any of the tables or fields by mistake, would that delete the tables and fields in the actual data source as well? Or if i wanted to rename one of the fields in BI, would that rename in the oracle data source? Thanks.