Showing results for 
Search instead for 
Did you mean: 
New Member

On Premesis Data Gateway Error Oracle

I have been working remotely with a client for deployment of some Power BI reports. I am trying to help with setting up their data gatway, to connect with their Oracle database. After some initial problems with getting a 64 bit oracle client set up on the server (where Power BI desktop 32 bit has been successfully connecting to the same data source), their database administrator informed me that "instead of installing the 64-bit client I now only installed the 64-bit ODAC components". Now on attempting to set up the data source on the gateway, we are receiving the following error

Power BI error.png

As this side of oracle isn't really my area of expertise, and I'm pretty new to Power BI, I wondered if anyone could help - is it likely to be because the 64-bit client still isn't installed that they are receiving this error? Or is it now a different problem that needs to be fixed?

Thanks in advance.

Moderator v-yuezhe-msft

Re: On Premesis Data Gateway Error Oracle


Do you install the  64-bit Oracle client on the machine that have Power BI gateway installed?

As per this official article, please install oracle client using 64-bit ODAC 12.2c Release 1 ( for Windows x64 package.



Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors