Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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-en...
http://surendrathotamsbiproffesional.blogspot.sg/2014/10/ssas-connection-cannot-be-made-to.html
Regards,
Charlie Liao
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-en...
http://surendrathotamsbiproffesional.blogspot.sg/2014/10/ssas-connection-cannot-be-made-to.html
Regards,
Charlie Liao
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |