Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

SQL Reporting Serivce / Gateway Error code: 1056899072



I hope someone can help. 


We are having issues which we really haven't had before, the issue is SQL reporting service seems running when this happens where PBI reports are not acceseble trough online, it says something about contact gateway administrator. 


When we restart the SQL reporting service in services everything works again, and we just can't figure out what the issue is. This has happened multiple times now and is annoying. 


We updated gateway to latest version, we changed the user on SQL reporting service to AD user didn't help. 


The error code is like this: 


ErrorCode=-1056899072 --->
[1]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.GatewayPipelineWrapperException: Substituted:
The following system error occurred: The user name or password is incorrect.
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Connect(Boolean toIXMLA)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayDataAccess.AdomdConnectionProvider.OpenConnectionAsync()</pi>

I hope anyone can help. 



Super User IV
Super User IV
Community Support
Community Support

Hi @isly ,

As @parry2k  mentioned, poewrbi  report server is on -premise, it doesn't need gateway, you need to configure credential in datasource settting. You could refer to compare-report-server-service  for details.

Did other powerbi report in report server work well? Did you configure datasource for powerbi report in report server? If you re-upload powerbi report in report server, will it work or not?

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.


Super User III
Super User III

@isly it is not very clear what is working and what is going on, can you layout the setup, seems like power bi service is using a gateway to refresh the dataset and it fails to refresh and in that case, you have a reporting service (on-prem) and you restart the reporting service and then cloud power bi service works? Is this a correct understanding?


I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

Visit us at, your one-stop-shop for Power BI-related projects/training/consultancy.

Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Super User IV
Super User IV

Helpful resources

PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!


Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors