topic Re: Powerbi Intergration with SAP in Report Server

Powerbi Intergration with SAP

riaankotze10 — Mon, 24 Nov 2025 11:27:46 GMT

Good day,

I've installed the SAP . NET Connector 3.1 NCo. Up until the stage where i have to load the data or transform the data, i receive this error on most of my data sources. Please assist.

Feedback Type:
Frown (Error)

Timestamp:
2025-11-24T11:16:38.0623120Z

Local Time:
2025-11-24T13:16:38.0623120+02:00

Session ID:
e3c9d62d-6408-4ebf-9cc0-70dae0091665

Release:
November 2025

Product Version:
2.149.911.0 (25.11)+a5b156d105cd1dad3d9d2157897b7c59587775fe (x64)

Stack Trace:
System.NullReferenceException
at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetSkipTelemetryLogging(Exception exception)
at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception e)
at Microsoft.Mashup.Host.WorkspaceWeb.Views.Navigator.Cube.ParameterizedCubeQueryTreeNode.ExtractParameterDetails(PreviewReference previewReference)
at Microsoft.Mashup.Host.WorkspaceWeb.Views.Navigator.Cube.ParameterizedCubeQueryTreeNode.<>c__DisplayClass23_0.<DiscoverParameterEntries>b__0(PreviewReference previewReference)
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)

PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.149.911.0","ModuleName":"Microsoft.Mashup.Document.dll","Component":"Microsoft.Mashup.Host.Document.ExceptionExtensions","Error":"System.NullReferenceException","MethodDef":"GetSkipTelemetryLogging","ErrorOffset":"0","ErrorCode":""}

OS Version:
Microsoft Windows NT 10.0.26100.0 (x64 en-US)

CLR Version:
4.8 or later [Release Number = 533320]

Peak Virtual Memory:
70.6 GB

Private Memory:
586 MB

Peak Working Set:
766 MB

IE Version:
11.1882.26100.0

User ID:
7271d13c-792d-41c7-b643-34759760ad33

Workbook Package Info:
1* - en-US, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: False.

Telemetry Enabled:
True

Model Default Mode:
Empty

Model Version:
PowerBI_V3

Enabled Preview Features:
PBI_googleBigQueryAdbcVersionEnabled
PBI_scorecardVisual
PBI_setLabelOnExportPdf
PBI_oneDriveSave
PBI_oneDriveShare
PBI_odspSaveBackgroundUpload
PBI_modernOfficeFilePicker
PBI_useModernPublishDialogs
PBI_gitIntegration
PBI_tmdlInDataset
PBI_enhancedReportFormat
PBI_directLakeOnOneLake
PBI_advancedSlicerTypeList
PBI_textSlicer
PBI_aiNarrativesVisual
PBI_visualCalculationsAuthoring
PBI_copilotUnifiedTooling
PBI_UserInstalledVerticaODBCDriver
PBI_sqlDbNativeArtifactsOnDesktop
PBI_dataFunctionActions
PBI_enableExportQueries

Disabled Preview Features:
PBI_DatabricksAdbcVersionEnabled
PBI_snowflakeLegacyOdbcVersionEnabled
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_metricsArtifactsOnDesktop
PBI_b2bExternalDatasetSharing
PBI_enhancedTooltips
PBI_onObject
PBI_publishDialogsSupportSubfolders
PBI_enhancedReportFormatPBIX
PBI_qnaImproveLsdlCopilot
PBI_customCalendars
PBI_UserInstalledNetezzaODBCDriver
MashupFlight_EnableOracleBundledOdacProvider
PBI_supportUDFs

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
125%

Supported Services:
Power BI

WebView2 Runtime Version:
142.0.3595.94

WebView2 SDK Version:
1.0.2365.46

Re: Powerbi Intergration with SAP

Zanqueta — Mon, 24 Nov 2025 12:23:11 GMT

Hello riaankotze10,

This error occurs when integrating Power BI with SAP using the SAP .NET Connector (NCo) and typically indicates an issue with the connector or the way the query is being executed. The System.NullReferenceException in the stack trace suggests that Power BI is expecting metadata or parameter details that are not being returned correctly by the SAP source.

Why does this happen?

The SAP connector in Power BI relies on RFC/BAPI calls. If the SAP function module does not return expected metadata or if parameters are not properly defined, Power BI fails during the preview or load stage.
It can also occur when:
- The SAP .NET Connector is not correctly registered or mismatched with the Power BI version.
- The query uses cubes or hierarchies that require parameter discovery, but the connector cannot resolve them.
- There is a missing configuration for RFC destinations or SAP gateway permissions.

Recommended Fixes

Verify SAP .NET Connector Installation

Ensure SAP NCo 3.1 is installed and registered correctly:
- Check that the DLLs (sapnco.dll, sapnco_utils.dll) are in the correct directory.
- Confirm that the architecture (x64) matches your Power BI Desktop installation.

Use OData or BW Connector as Alternative

For SAP BW or HANA, consider using:
- SAP BW Connector (supports MDX queries).
- OData feed from SAP Gateway for more stable integration.

Check the others posts also:

Solved: SAP Datasphere to PBI via ODCB - Microsoft Fabric Community

If this answer was helpful in any way, I would be pleased to receive a 👍, as well as the satisfaction of seeing a DAX measure work for the first time without needing yet another FILTER.
Please mark it as the accepted solution. This helps other community members find the quickest path and saves them from another endless loop 🌀.

Re: Powerbi Intergration with SAP

riaankotze10 — Mon, 24 Nov 2025 12:50:07 GMT

Hi Zanqueta, thanks for the repsonse and the suggestions - I've located (sapnco.dll, sapnco_utils.dll) - They are under my OSDisk (C:) under Program Files ---> SAP BusinessObjects --->Office AddIn. Can you advise where they should be?

I will confirm with the team if i have authorization to access these sources and then take it from there.

Re: Powerbi Intergration with SAP

Zanqueta — Mon, 24 Nov 2025 12:58:57 GMT

Hi riaankotze10,

Firstly you need to ensure this dll camo from SAP NCo 3.1 package. They hav e a typical installation path:

C:\Program Files\SAP\SAP .NET Connector 3.1\ or C:\Program Files (x86)\SAP\SAP .NET Connector 3.1\

(depending on architecture).

Next Steps

Download and install SAP NCo 3.1 from SAP Marketplace (ensure you have authorisation).
Confirm that:
- sapnco.dll and sapnco_utils.dll are in the correct folder.
- The folder is added to the PATH environment variable.
Restart Power BI Desktop after installation.

Why this matters

Power BI uses these DLLs to establish RFC/BAPI communication with SAP. If they are in the wrong directory or not registered, the connector will fail during data load or transformation.

Re: Powerbi Intergration with SAP

riaankotze10 — Mon, 24 Nov 2025 13:08:10 GMT

How do i know if it is in the correct folder? When we installed it, the installer display did not provide me with to install it in GAC.

Re: Powerbi Intergration with SAP

riaankotze10 — Mon, 24 Nov 2025 13:08:54 GMT

I think i really need a teams session - to have you on a call as well as our IM services...

Re: Powerbi Intergration with SAP

v-kpoloju-msft — Thu, 27 Nov 2025 10:44:28 GMT

Hi riaankotze10,

Thanks for the additional details. The error you are seeing usually occurs when Power BI cannot load the correct SAP .NET Connector (NCo) 3.1 libraries. Even though you found the DLLs, the path you shared belongs to another SAP product, so Power BI cannot use those files for RFC/BAPI communication.

Install the official SAP NCo 3.1 package: Please make sure your team installs NCo 3.1 from the SAP Marketplace. Only the DLLs from this installer are supported by the Power BI SAP connector.

Match the installation with your Power BI bitness: If your Power BI Desktop is 64-bit, you must install SAP NCo 3.1 (64-bit). If it’s 32-bit, install the 32-bit version. A mismatch can trigger the exact error you’re seeing.

Ensure the DLLs are installed in the correct location: After installation, the assemblies should be in:

C:\Program Files\SAP\SAP .NET Connector 3.1\

and/or registered automatically in the .NET Global Assembly Cache (GAC).
If the DLLs are only inside the BusinessObjects folder, Power BI won’t detect them.

Once NCo is correctly installed and registered, Power BI will be able to read the SAP metadata and load the data without that error.

Hope this clears it up. Let us know if you have any doubts regarding this. We will be happy to help.

Thank you for using the Microsoft Fabric Community Forum.

Re: Powerbi Intergration with SAP

v-kpoloju-msft — Sun, 30 Nov 2025 15:57:01 GMT

Hi riaankotze10,

Just checking in to see if the issue has been resolved on your end. If the earlier suggestions helped, that’s great to hear! And if you’re still facing challenges, feel free to share more details happy to assist further.

Thank you.

Re: Powerbi Intergration with SAP

v-kpoloju-msft — Wed, 03 Dec 2025 12:52:07 GMT

Hi riaankotze10,

Just wanted to follow up. If the shared guidance worked for you, that’s wonderful hopefully it also helps others looking for similar answers. If there’s anything else you'd like to explore or clarify, don’t hesitate to reach out.

Thank you.

Re: Powerbi Intergration with SAP

riaankotze10 — Wed, 03 Dec 2025 13:05:44 GMT

Hi it is resolved thanks. It was an authorization issue from the security teams side.