Power BI & BW Connection - Object Reference Error

Hi kivancc94 ,

If I understand correctly, it seems that you got the error message when you connect to SAP BW in Power BI. The following links are the ones which have the similar problem as yours, hope their soution can help you solve the problem.

SAP Business Warehouse connector troubleshooting - Power Query | Microsoft Learn

In some cases, the Navigator dialog box doesn't display a data preview and instead provides an object reference not set to an instance of an object error message.

SAP users need access to specific BAPI function modules to get metadata and retrieve data from SAP BW's InfoProviders. These modules include:

• BAPI_MDPROVIDER_GET_CATALOGS
• BAPI_MDPROVIDER_GET_CUBES
• BAPI_MDPROVIDER_GET_DIMENSIONS
• BAPI_MDPROVIDER_GET_HIERARCHYS
• BAPI_MDPROVIDER_GET_LEVELS
• BAPI_MDPROVIDER_GET_MEASURES
• BAPI_MDPROVIDER_GET_MEMBERS
• BAPI_MDPROVIDER_GET_VARIABLES
• BAPI_IOBJ_GETDETAIL

To solve this issue, verify that the user has access to the various MDPROVIDER modules and BAPI_IOBJ_GETDETAIL. To further troubleshoot this or similar issues, you can enable tracing. Select File > Options and settings > Options. In Options, select Diagnostics, then select Enable tracing. Attempt to retrieve data from SAP BW while tracing is active, and examine the trace file for more detail.

---

powerbi - how to solve Object reference not set to an instance of an object in Power BI and the source file is an Excel Macro file - Stack Overflow

The error "Object reference not set to an instance of an object" is not for anything specific. Issues can be related to different problematic area. You can try this below to search your luck-

1. Download the latest version of Power BI desktop
2. Try to match the version (32/64 bit) between your OS and Power BI desktop software
3. reconnect the data source and then check everything works for you or not after publishing the report

---

Best Regards