Forum Discussion
Connecting to Oracle database concept question
Hi I am trying to understand and conceptualize oracle connections in power bi. I have connected to excel files and data from dynamics, but my first time with Oracle. When I connect using the get data functionality to an oracle db, then it loads about 10 million records of each table, is it actually copying each record into power bi or does the data remain in oracle? I'm assuming the data stays in oracle and power bi is just getting access to the oracle DB to run visualizations. Please correct me if i am mistaken.
So if i have two laptops one at home and one in the office in addition to my other team members accessing the same report, all we're doing is just making connections to oracle everytime we access the data is that correct?
And when I publish the report and viewers view the report, are they connecting to the oracle db as well or are they accessing cache data?
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
2 Replies
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
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.
