cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
isly
Frequent Visitor

SQL Reporting Serivce / Gateway Error code: 1056899072

Hi 

 

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: 

 

GatewayPipelineErrorCode=DM_GWPipeline_Gateway_DataSourceAccessError
GatewayVersion=
ErrorCode=-1056899072 --->
[1]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.GatewayPipelineWrapperException: Substituted:
AdomdErrorResponseException:<pi>Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException:
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. 

 

Thx.  

1 ACCEPTED SOLUTION
amitchandak
Super User IV
Super User IV
3 REPLIES 3
dax
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.

 

parry2k
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 https://perytus.com, 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.





amitchandak
Super User IV
Super User IV

Helpful resources

Announcements
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

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.