PowerBI 无法连接SQL server analysis services 数据库

Question

本地搭建的安装的PowerBI报表服务器，本地安装的SQL server 2017，现在PowerBI无法连接到analysis services，报错如下，服务器名称是正确的

Answer 1

你的服务器名称是不是填写错了和下面服务名不一致啊,建议你使用ssms用这个servername连接测试一下，如果是本地服务，直接使用localhost试试

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail]

Answer 2

您好，服务器名称是正确的，ssms也是可以连接到的，我也使用了localhost的去尝试，依旧无法连接上

Answer 3

请你试一下完整的servername ：powerbi-01\powerbi01 

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail]

Answer 4

非常感谢，但是我有一个疑问，PowerBI-01是我服务器的名称，PowerBI01 是我SQL server数据库实例的名称，我之前在连接SQL server的时候，服务器名称填写PowerBI-01就成功连接，为什么analysis services要填写完整的servername？

Answer 5

PowerBI-01连接的是默认实例，命名实例一定要使用完整的servername

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail]

Answer 6

好的，非常感谢您的解答