I have created an application in PowerBI Desktop which connects and pulls data from 8 Oracle 10g database servers. (about 32 tables, less than 200K rows, it works fine). I have published my application into cloud, then installed PowerBI personal Gateway. While trying to refresh I get the following error.
Failed to update data source credentials: We are unable to connect to the data source. Please ensure that data source is accessible.Hide details
Activity ID: | afd413a3-210b-41f6-8d33-aba7d0926ddd |
Request ID: | f6c0fb7c-a0a6-6c63-fa6a-2163ed9c6862 |
Status code: | 400 |
Time: | Thu Mar 24 2016 16:03:42 GMT+0400 (Arabian Standard Time) |
Version: | 13.0.1100.182 |
Cluster URI: | https://wabi-south-east-asia-redirect.analysis.windows.net |
Details: | Attempt to load Oracle client libraries threw BadImageFormatException. This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed. |
Note :
- Personal Gateway is running.
- Local XLS files gets refreshed from the cloud.
- Oracle databases are 32 bit.
- The oracle database driver in my PC is also 32 bit.
- PowerBI desktop is 32 bit.
Looking forward for quick help.
