Connecting to Oracle Wallet folder

I figured it out and am going to write a step by step explanation to anyone who might find it useful in the future.

Step 1: Download the latest Oracle instant client from https://www.oracle.com/database/technologies/instant-client/winx64-64-downloads.html

Step 2: Install/Extract the downloaded folder to C:\instantclient

Step 3: Add this location to Windows path (usually C:\instantclient\instantclient_19_5)

Step 4: Download and extract the wallet contents to /network/admin in the instant client folder

Step 5: Open the wallet file named tnsnames.ora in a text editor and note down the variable name such as db_high

Step 6: In Power BI navigate to Get Data --> Database --> Oracle

Step 7: In the field named server enter the variable name from step 5

Step 8: It will prompt for a username and password, enter each one as provided by owner of the wallet

Step 9: This should give you the database schema, select the desired table names and click transform/load