I am currently trying to integrate our Oracle 19c database with Power BI for some high-level data visualization, but I keep hitting "Provider not found" errors. I’ve installed the 64-bit ODAC, but it's still not syncing correctly. Does anyone have a definitive, step-by-step guide on configuring the TNSNames.ora file or using the Oracle Data Provider for .NET to ensure a stable connection?
3 answers
Sometimes using the 'Easy Connect' syntax (ServerName:Port/ServiceName) in the server field helps bypass TNSNames issues entirely if you don't want to mess with the .ora configuration files.
To establish a successful connection, you must first ensure that the Oracle Client software matches your Power BI architecture—usually 64-bit. After installing the Oracle Data Access Components (ODAC), you need to define your connection string in the TNSNames.ora file located in your network admin folder. In Power BI, select 'Get Data', choose Oracle, and enter the Server name exactly as it appears in your TNS file. If you are using an On-premises Data Gateway for the Power BI Service, the same drivers and TNS configurations must be mirrored on the gateway machine to allow for scheduled refreshes.
Have you checked if your environment variables are correctly pointing to the Oracle Home directory where the driver is installed? Often, Power BI fails to find the provider simply because the PATH variable hasn't been updated to include the bin folder of your client installation.
Michael, that's a great point. I checked the PATH variables and realized I had an old 32-bit client path taking precedence over the new 64-bit one. After rearranging the order in the System Environment Variables and restarting Power BI, the 'Oracle' option finally appeared in the data source list without the provider error. It seems Power BI is very sensitive to the driver's bitness.
I agree with Robert. Using the DirectQuery mode with Easy Connect is often much faster for real-time reporting, as it avoids the headache of maintaining TNS files across multiple developer machines.