cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rack201
Frequent Visitor

SAP Business Warehouse connector - Object reference not set to an instance of an object

Hi - I'm trying to use the SAP Business Warehouse connector (the SAP .Net Connector implementation).  I can browse cubes and reports on the server, but when trying to Load the data receive an Object reference not set to an instance of an object error.

 

The preview then loads ok in the Transform window, and I can filter and manipulate the query, but when I try to apply I get the same error.

 

rack201_0-1631655821906.png

 

3 REPLIES 3
rack201
Frequent Visitor

Reading this doc: Use the SAP Business Warehouse (BW) Connector in Power BI Desktop - Power BI | Microsoft Docs

 

Seems like I may need access to some modules in BW.. will try that.

RicoZhou
Community Support
Community Support

Hi @rack201 

SAP users need access to specific BAPI function modules to get metadata and retrieve data from SAP BW's InfoProviders. These 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 as well as BAPI_IOBJ_GETDETAIL. To further troubleshoot this or similar issues, select Enable tracing on the Diagnostics window within Power BI Desktop's Options. Attempt to retrieve data from SAP BW while tracing is active, and examine the trace file for more detail.

Here is the document for your reference : Troubleshooting

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

rack201
Frequent Visitor

This didn't help - I'm told I have access to these modules already.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!