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.
SAP users need access to specific BAPI function modules to get metadata and retrieve data from SAP BW's InfoProviders. These include:
To solve this issue, verify that the user has access to the variousMDPROVIDERmodules as well asBAPI_IOBJ_GETDETAIL. To further troubleshoot this or similar issues, selectEnable tracingon theDiagnosticswindow within Power BI Desktop'sOptions. Attempt to retrieve data from SAP BW while tracing is active, and examine the trace file for more detail.