Pb to publish report with Oracle direct query connection

[amiri]

Hello to all,

I have created a report using Power BI Desktop and a direct query to an on premise oracle database.
When I tried to publish it, I saw that I needed to install a gateway.
So I installed "On-premises data gateway (personal mode)".
The gateway is installed and seems to be configured correctly (see attached screenshot) :

When I try to access my report via the web, I get the following error message:

Unable to load the template

Unable to load the template schema associated with this report. Check the connection to the server, then try again.
Try again later or contact support. If you contact support, provide this information.

Activity ID: 8128f457-35e4-45ef-a4b1-f453c0261f97
Request ID: 45f2a5b3-7f10-5ac7-5ac9-5d00345c06d5
Correlation ID: 7c83b6cd-37e1-5ab2-1d5a-d55a75ac09ff
Time: Tue Nov 30 2021 12:10:57 GMT+0100 (Central European Time)
Service version: 13.0.17186.43
Client version: 2111.3.08807-train
Cluster URI: https://wabi-north-europe-l-primary-redirect.analysis.windows.net/

Does anyone have an idea?

Thanks in advance for your help.

Raphaël

[ibarrau · Accepted solution]

Hi. Power Bi Onpremise Data Gateway in personal mode is not compatible with direct query. You need to install the standard one. You can check the differences in this doc:
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-personal-mode#on-premises-dat...

I hope that helps,

[amiri · Accepted solution]

Hello,

Thank you all for your feedback.
Finally, I learned that there was a gateway already installed on a server in the company. My problem was solved by using this gateway.

Have a nice day

Raphaël

[ibarrau · Accepted solution]

Hi. Power Bi Onpremise Data Gateway in personal mode is not compatible with direct query. You need to install the standard one. You can check the differences in this doc:
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-personal-mode#on-premises-dat...

I hope that helps,