Hi,
I have Oracle Database. I need to understand what are the steps needed to connect my Powerquery in MS Excel to Oracle Database. The query will obtain the most recent data from Oracle Tables through the query.
That Excel also contains some Power pivots. I want the pivotable information to be updated based on the new data.
Is this possible?
Thanks
Charan
Hi Charan,
Connecting to Oracle is much the same as connecting to any of the other databases. You'll find it under the From Database menu > From Oracle Database.
You'll need the correct Oracle Client Software, which you can find links to here:
There are also instructions for connecting to an Oracle database at the above link.
You can then load the query into Power Pivot as shown in session 5.02 of the Power Query course.
I recommend you finish the Power Query course first if possible.
Mynda
