Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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.
Hi @rack201
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 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.
This didn't help - I'm told I have access to these modules already.
hi - did you get an resolution to this?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |