This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hi everyone,
We are experiencing a critical issue with a Power BI Report (Premium Capacity) connected to an on-premises SSAS Tabular instance (v13.0.6300.2) via On-premises data gateway (v3000.314.5).
Everything has been working perfectly for years, but since the beginning of this week, the report fails with the following error: There was a data source access error. Please contact the gateway administrator.
Environment Details:
SSAS Version: 2016 (13.0.6300.2)
Gateway Version: 3000.314.5
Connection Type: Live Connection (ADOMD)
What we have verified:
Gateway Status: The connection in "Manage Connections and Gateways" is Online.
Isolation: A report on the same portal connected to a SQL Server database on the same physical server (using the same gateway) works correctly. The issue seems isolated to SSAS.
Local Test: If I download the PBIX and open it with Power BI Desktop directly on the server, it works perfectly.
Credentials: The connection uses a Domain User who is a Server Administrator on the SSAS instance.
EffectiveUserName: Map User Names is configured, but even with standard mapping, the error persists.
Log Analysis:
SQL Server Profiler (on SSAS): When opening the report, several error lines appear. The message is always a generic: Errore di sistema: (System Error) with no further details.
Gateway Logs: I found the following exception: Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.AdomdDataAccessErrorResponseException: AdomdException encountered while accessing the target data source. ErrorCode=-1056899072 InnerMessage=Errore di sistema:
Troubleshooting done:
Restarted Gateway services.
Restarted SSAS instance.
Updated the Gateway to the latest version.
Since SQL Server works, we suspect an issue with the ADOMD.NET client or an update on the Windows Server 2016 side that might have affected Kerberos/Impersonation or encrypted communications (TLS?).
Has anyone encountered this generic "System Error" recently? Any advice on how to get more detailed logs from ADOMD or SSAS?
Thanks in advance.Hi everyone,
We are experiencing a critical issue with a Power BI Report (Premium Capacity) connected to an on-premises SSAS Tabular instance (v13.0.6300.2) via On-premises data gateway (v3000.314.5).
Everything has been working perfectly for years, but since the beginning of this week, the report fails with the following error: There was a data source access error. Please contact the gateway administrator.
Environment Details:
OS: Windows Server 2016 Standard
SSAS Version: 2016 (13.0.6300.2)
Gateway Version: 3000.314.5
Connection Type: Live Connection (ADOMD)
What we have verified:
Gateway Status: The connection in "Manage Connections and Gateways" is Online.
Isolation: A report on the same portal connected to a SQL Server database on the same physical server (using the same gateway) works correctly. The issue seems isolated to SSAS.
Local Test: If I download the PBIX and open it with Power BI Desktop directly on the server, it works perfectly.
Credentials: The connection uses a Domain User who is a Server Administrator on the SSAS instance.
EffectiveUserName: Map User Names is configured, but even with standard mapping, the error persists.
Log Analysis:
SQL Server Profiler (on SSAS): When opening the report, several error lines appear. The message is always a generic: Errore di sistema: (System Error) with no further details.
Gateway Logs: I found the following exception: Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.AdomdDataAccessErrorResponseException: AdomdException encountered while accessing the target data source. ErrorCode=-1056899072 InnerMessage=Errore di sistema:
Troubleshooting done:
Restarted Gateway services.
Restarted SSAS instance.
Updated the Gateway to the latest version.
Since SQL Server works, we suspect an issue with the ADOMD.NET client or an update on the Windows Server 2016 side that might have affected Kerberos/Impersonation or encrypted communications (TLS?).
Has anyone encountered this generic "System Error" recently? Any advice on how to get more detailed logs from ADOMD or SSAS?
Thanks in advance.
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 49%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Hi @Davide Mari,
Thanks for the detailed troubleshooting that helps a lot.
Since
This points to an issue in the gateway ↔ SSAS (ADOMD) communication layer, not the report/model.
Given it started suddenly, please check the following (most common causes):
Also review gateway logs and enable verbose logging on SSAS to get more details beyond the generic “System Error”.
If you can share recent server changes or log snippets, it’ll help narrow it down further.
Thanks,
Akhil.
Hi @Davide Mari ,
Just following up to see whether you had a chance to review the suggestions shared earlier around TLS, ADOMD.NET, SPNs/delegation, and gateway logs.
Since SQL connectivity through the gateway is working and only SSAS connections are failing, the issue still appears isolated to the gateway-to-SSAS communication layer.
If possible, please share:
Any recent changes on the gateway or SSAS server
Relevant gateway log entries
SSAS verbose log snippets around the failure time
That information would help the community narrow this down further.
Thanks,
Akhil.