Message error with SAP BW query datasource: Object reference not set to an instance of an object.

[Samuel_Ambrosio]

We trying to solver a problem that occour when are using a SAP BW query as a datasource in Power BI Desktop, but the same problem not occour in Microsofit Power BI Server and we created a dataflow with de same SAP BW query. I need a help to solver this problem.

Error message: "Object reference not set to an instance of an object."

Moments when occoured this error message: To expand tree to select fields from selected SAP BW query or after press button Apply/Close in the transformation.

Informations:
SAP BW (data source) : SAP BW 7.5 On Hana
SAP .NET Connector 3.0 and SAP .NET Connector 3.1
Power BI Desktop Version: 2.112.603.0 64-bit (December 2022)

[miTutorials]

Try using SAP Connector 3.0 version 3.0.25 and not 3.1. This had solved the issue for me. 

[amitchandak]

@Samuel_Ambrosio , Try to clear permission and try again (Data source connection has an option)

Also refer suggestion from support here

https://community.powerbi.com/t5/Issues/quot-SAP-Business-Warehouse-Object-reference-not-set-to-an/i...