Forum Discussion
Power BI Desktop and SSAS Connection Error
While I am connecting SSAS Cube to the Power BI Desktop its giving error
Unable to Connect
Details: "AnalysisServices: A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running."
But with the same User Id it is opening in SSMS .
Have tried Opening ports and Putting SQL Browser in Exception on Server but nothing is working. Knidly help need urgent suggestions.
Hi spranav,
For the error
"AnalysisServices: A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running."Its's realted to SSAS database server. Based on my research, the issue was caused by 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-ensure-that-sql-browser-service-is-running-microsoft-analysisservices-adomdclient/
http://surendrathotamsbiproffesional.blogspot.sg/2014/10/ssas-connection-cannot-be-made-to.htmlRegards,
Charlie Liao
1 Reply
Hi spranav,
For the error
"AnalysisServices: A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running."Its's realted to SSAS database server. Based on my research, the issue was caused by 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-ensure-that-sql-browser-service-is-running-microsoft-analysisservices-adomdclient/
http://surendrathotamsbiproffesional.blogspot.sg/2014/10/ssas-connection-cannot-be-made-to.htmlRegards,
Charlie Liao