Trying to connect to Oracle Data base on prem. Installed the gateway and entered the database connection which went fine. Made sure the names are same.
I am able to query and publish a simple extract to powerBI. But when trying to open on the site. It errors with the below error.
Couldn't load the model schema associated with this report. Make sure you have a connection to the server, and try again.
Please try again later or contact support. If you contact support, please provide these details.
Please check if Oracle client has been installed.
For 32-bit versions of Power BI Desktop, use the following link to download and install the 32-bit Oracle client:
For 64-bit versions of Power BI Desktop, use the following link to download and install the 64-bit Oracle client:
If the Oracle client has been installed but the issue still occurs, please check if the data gateway is wrong on the server, if the data source configurations in "Manage Gateway" is correct.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for the response.
I am able to connect to Oracle database fine on the machine where the gateway is installed.
How ? - The report is built using PowerBI Desktop in the same machine and it runs the queries fine.
Also in the gateway online - I am able to connect to the same database. It does a live check and verifies the connection is successful.
I see some other forum notes where folks are saying User Prinicpal Name. I don't see the button to reference User Principal name on the connection that was built ?
Any thoughts ?
Let me know if I can share some screenshots of our setup here.