"Object reference not set to an instance of an object" - Error while connecting to Oracle DB

[pallavi-sharma]

Hi Team,

I have installed Power BI desktop with Oracle 12.1.0.2 (64 bit) client version.

When I try to connect the Oracle database by giving the name and other credentials, it gives me the following error :

"Error while reading data from the provider: Object reference not set to an instance of an object".

Can anyone pls help ? I am struggling with this error since long.

[Syndicate_Admin]

Hello @pallavi-sharma

Try the following solution:

Download Power BI Desktop from the Download Center instead of the microsoft store.

Connect to an Oracle database with Power BI Desktop - Power BI | Microsoft Documents

In addition, you can try using the ODBC connector as an option.

Does anyone have an Oracle connection to work on a Microsoft Store installation? : PowerBI (reddit.c...

Other reference:

Power BI: How to Connect to Oracle Database (Part 1) - YouTube

I hope this helps.

Best regards

Community Support Team _ Jing
If this post helps, please accept it as the solution to help other members find it.

[Syndicate_Admin]

Hello @pallavi-sharma

Try the following solution:

Download Power BI Desktop from the Download Center instead of the microsoft store.

Connect to an Oracle database with Power BI Desktop - Power BI | Microsoft Documents

In addition, you can try using the ODBC connector as an option.

Does anyone have an Oracle connection to work on a Microsoft Store installation? : PowerBI (reddit.c...

Other reference:

Power BI: How to Connect to Oracle Database (Part 1) - YouTube

I hope this helps.

Best regards

Community Support Team _ Jing
If this post helps, please accept it as the solution to help other members find it.

[Syndicate_Admin]

Hello @pallavi-sharma

Try the following solution:

Download Power BI Desktop from the Download Center instead of the microsoft store.

Connect to an Oracle database with Power BI Desktop - Power BI | Microsoft Documents

In addition, you can try using the ODBC connector as an option.

Does anyone have an Oracle connection to work on a Microsoft Store installation? : PowerBI (reddit.c...

Other reference:

Power BI: How to Connect to Oracle Database (Part 1) - YouTube

I hope this helps.

Best regards

Community Support Team _ Jing
If this post helps, please accept it as the solution to help other members find it.

[Syndicate_Admin]

Hello @pallavi-sharma

Try the following solution:

Download Power BI Desktop from the Download Center instead of the microsoft store.

Connect to an Oracle database with Power BI Desktop - Power BI | Microsoft Documents

In addition, you can try using the ODBC connector as an option.

Does anyone have an Oracle connection to work on a Microsoft Store installation? : PowerBI (reddit.c...

Other reference:

Power BI: How to Connect to Oracle Database (Part 1) - YouTube

I hope this helps.

Best regards

Community Support Team _ Jing
If this post helps, please accept it as the solution to help other members find it.

[Syndicate_Admin]

Hello @pallavi-sharma

Try the following solution:

Download Power BI Desktop from the Download Center instead of the microsoft store.

Connect to an Oracle database with Power BI Desktop - Power BI | Microsoft Documents

In addition, you can try using the ODBC connector as an option.

Does anyone have an Oracle connection to work on a Microsoft Store installation? : PowerBI (reddit.c...

Other reference:

Power BI: How to Connect to Oracle Database (Part 1) - YouTube

I hope this helps.

Best regards

Community Support Team _ Jing
If this post helps, please accept it as the solution to help other members find it.

[Syndicate_Admin]

Hello @pallavi-sharma

Try the following solution:

Download Power BI Desktop from the Download Center instead of the microsoft store.

Connect to an Oracle database with Power BI Desktop - Power BI | Microsoft Documents

In addition, you can try using the ODBC connector as an option.

Does anyone have an Oracle connection to work on a Microsoft Store installation? : PowerBI (reddit.c...

Other reference:

Power BI: How to Connect to Oracle Database (Part 1) - YouTube

I hope this helps.

Best regards

Community Support Team _ Jing
If this post helps, please accept it as the solution to help other members find it.

[Syndicate_Admin]

Hello @pallavi-sharma

Try the following solution:

Download Power BI Desktop from the Download Center instead of the microsoft store.

Connect to an Oracle database with Power BI Desktop - Power BI | Microsoft Documents

In addition, you can try using the ODBC connector as an option.

Does anyone have an Oracle connection to work on a Microsoft Store installation? : PowerBI (reddit.c...

Other reference:

Power BI: How to Connect to Oracle Database (Part 1) - YouTube

I hope this helps.

Best regards

Community Support Team _ Jing
If this post helps, please accept it as the solution to help other members find it.

[Syndicate_Admin]

Hello @pallavi-sharma

Try the following solution:

Download Power BI Desktop from the Download Center instead of the microsoft store.

Connect to an Oracle database with Power BI Desktop - Power BI | Microsoft Documents

In addition, you can try using the ODBC connector as an option.

Does anyone have an Oracle connection to work on a Microsoft Store installation? : PowerBI (reddit.c...

Other reference:

Power BI: How to Connect to Oracle Database (Part 1) - YouTube

I hope this helps.

Best regards

Community Support Team _ Jing
If this post helps, please accept it as the solution to help other members find it.

[Syndicate_Admin]

Hello @pallavi-sharma

Try the following solution:

Download Power BI Desktop from the Download Center instead of the microsoft store.

Connect to an Oracle database with Power BI Desktop - Power BI | Microsoft Documents

In addition, you can try using the ODBC connector as an option.

Does anyone have an Oracle connection to work on a Microsoft Store installation? : PowerBI (reddit.c...

Other reference:

Power BI: How to Connect to Oracle Database (Part 1) - YouTube

I hope this helps.

Best regards

Community Support Team _ Jing
If this post helps, please accept it as the solution to help other members find it.

[Syndicate_Admin]

Hello @pallavi-sharma

Try the following solution:

Download Power BI Desktop from the Download Center instead of the microsoft store.

Connect to an Oracle database with Power BI Desktop - Power BI | Microsoft Documents

In addition, you can try using the ODBC connector as an option.

Does anyone have an Oracle connection to work on a Microsoft Store installation? : PowerBI (reddit.c...

Other reference:

Power BI: How to Connect to Oracle Database (Part 1) - YouTube

I hope this helps.

Best regards

Community Support Team _ Jing
If this post helps, please accept it as the solution to help other members find it.

[Syndicate_Admin]

Hello @pallavi-sharma

Try the following solution:

Download Power BI Desktop from the Download Center instead of the microsoft store.

Connect to an Oracle database with Power BI Desktop - Power BI | Microsoft Documents

In addition, you can try using the ODBC connector as an option.

Does anyone have an Oracle connection to work on a Microsoft Store installation? : PowerBI (reddit.c...

Other reference:

Power BI: How to Connect to Oracle Database (Part 1) - YouTube

I hope this helps.

Best regards

Community Support Team _ Jing
If this post helps, please accept it as the solution to help other members find it.

[Syndicate_Admin]

Hello @pallavi-sharma

Try the following solution:

Download Power BI Desktop from the Download Center instead of the microsoft store.

Connect to an Oracle database with Power BI Desktop - Power BI | Microsoft Documents

In addition, you can try using the ODBC connector as an option.

Does anyone have an Oracle connection to work on a Microsoft Store installation? : PowerBI (reddit.c...

Other reference:

Power BI: How to Connect to Oracle Database (Part 1) - YouTube

I hope this helps.

Best regards

Community Support Team _ Jing
If this post helps, please accept it as the solution to help other members find it.

[Syndicate_Admin]

Hello @pallavi-sharma

Try the following solution:

Download Power BI Desktop from the Download Center instead of the microsoft store.

Connect to an Oracle database with Power BI Desktop - Power BI | Microsoft Documents

In addition, you can try using the ODBC connector as an option.

Does anyone have an Oracle connection to work on a Microsoft Store installation? : PowerBI (reddit.c...

Other reference:

Power BI: How to Connect to Oracle Database (Part 1) - YouTube

I hope this helps.

Best regards

Community Support Team _ Jing
If this post helps, please accept it as the solution to help other members find it.

[Syndicate_Admin]

Hello @pallavi-sharma

Try the following solution:

Download Power BI Desktop from the Download Center instead of the Microsoft Store.

Connect to an Oracle database with Power BI Desktop - Power BI | Microsoft Documents

In addition, you can try using the ODBC connector as an option.

Does anyone have an Oracle connection to work on a Microsoft Store installation? : PowerBI (reddit.c...

Other reference:

Power BI: How to Connect to Oracle Database (Part 1) - YouTube

I hope this helps.

Best regards

Community Support Team _ Jing
If this post helps, please accept it as the solution to help other members find it.

[v-jingzhang]

Hi @pallavi-sharma 

Please try the following solution:

Download Power BI Desktop from the Download Center instead of Microsoft Store.

Connect to an Oracle database with Power BI Desktop - Power BI | Microsoft Docs

Additionally, you can try using ODBC connector as an option. 

Has anyone got an Oracle connection to work on a Microsoft Store install? : PowerBI (reddit.com)

Other reference:

Power BI: How to Connect to Oracle Database (Part 1) - YouTube

Hope this helps.

Regards,

Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.

[amitchandak]

@pallavi-sharma , Make sure you have installed a suitable oracle driver : https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-connect-oracle-database

Post that make the entry of the folder path where oracle driver is installed into Windows Environment path and check. If you do not do entery it will not work