Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Oracle: Object reference not set to an instance of an object. Power BI Gateway

I'm having this issue when connecting to Oracle Data Source from the Gateway.

An error happened while reading data from the provider: 'Object reference not set to an instance of an object.'

 

When I connect through the Power BI Desktop from both the server that has the gatway and personal PC it works fine, I tried connecting with different Server Names as follows:

(//HOST/SID, //HOST/SERVICE_NAME, HOST/SERVICE_NAME, HOST/SID, Server Alias)

TNSNAMES.ORA is correct which is why it works in the Power BI Desktop

 

I'm unable to schedule refresh because of this.

Appriciate the help.

1 ACCEPTED SOLUTION
4 REPLIES 4
v-easonf-msft
Community Support
Community Support

Hi, @Anonymous 

Could you please tell me whether your problem has been solved?
If it is,  please mark the helpful replies or add your reply as Answered to close this thread.
More people will learn new things here. If you haven't, please feel free to ask.

 

Best Regards,
Community Support Team _ Eason

Greg_Deckler
Community Champion
Community Champion

@Anonymous - I would make sure that youre gateway is up-to-date. Another thought, what bit version is your Oracle driver? I believe the gateway is only 64-bit so make sure that your bit versions match. You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

@Greg_Deckler - The gateway is up to date, and the oracle is 64-bit.

 

I'll open a support ticket and see what's the issue.

 

Thanks.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.