Issue when applying transformations

[Anonymous]

Dear All,

I can transform data but when I apply the transformations to all data I have an Error message (as below).

Do you have any idea how to solve this problem please?

Exception is: AdomdConnectionException - A connection cannot be made. Ensure that the server is running.

Feedback Type:
Frown (Error)

Error Message:
Resolution of the dependency failed, type = "Microsoft.PowerBI.Client.Windows.AnalysisServices.Relationships.IRelationshipManager", name = "(none)".
Exception occurred while: Calling constructor Microsoft.PowerBI.Client.Windows.AnalysisServices.Relationships.RelationshipManager(Microsoft.PowerBI.Client.Shared.IPowerBISettings powerBISettings, Microsoft.PowerBI.Client.Windows.Services.IReportManager reportManager).
Exception is: AdomdConnectionException - A connection cannot be made. Ensure that the server is running.
-----------------------------------------------
At the time of the exception, the container was:

Resolving Microsoft.PowerBI.Client.Windows.AnalysisServices.Relationships.RelationshipManager,(none) (mapped from Microsoft.PowerBI.Client.Windows.AnalysisServices.Relationships.IRelationshipManager, (none))
Calling constructor Microsoft.PowerBI.Client.Windows.AnalysisServices.Relationships.RelationshipManager(Microsoft.PowerBI.Client.Shared.IPowerBISettings powerBISettings, Microsoft.PowerBI.Client.Windows.Services.IReportManager reportManager)

[v-xuding-msft]

Hi @Anonymous ,

Could you tell me if your problem has been solved? If you have solved the issue, please accept the helpful answer. If you solved by yourself, welcome to share the solution. More people who encounter the same problem will benefit here.

Best Regards,

Xue Ding

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

[v-xuding-msft]

Hi @Anonymous ,

After researching, I think it might be caused by the fact that the Browser Service account was changed to the domain account. Please try to change the service account to Local System and check if this issue persists or not.

Reference
https://blog.sqlauthority.com/2015/03/10/sql-server-fix-a-connection-cannot-be-made-to-redirector-en...
http://surendrathotamsbiproffesional.blogspot.sg/2014/10/ssas-connection-cannot-be-made-to.html

https://www.sqltechnet.com/2013/09/analysis-service-connectivity-error-due.html

https://stackoverflow.com/questions/46894744/a-connection-cannot-be-made-ensure-that-the-server-is-running 

Best Regards,

Xue Ding

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