connect power bi analysis services

[jcamilo1985]

Good night

I have a scenario that has me out of place.

I have a connection that is made through excel to analysis services, from excel we have no problems establishing the connection. However, the idea is to pass this connection to power bi, to a data flow, or to a datamart.

However, when it is done from power bi, it cannot connect, considering that power bi is a more up-to-date tool than excel, I do not understand why I cannot establish the connection.

Any guidance will be appreciated

I annex screenshots of the connection path

[Syndicate_Admin]

Hola buen día, Lograron conectarse a SISPRO desde power bi???

[v-jingzhang]

Hi @jcamilo1985 

Do you try to connect to the SSAS server with Power BI Desktop on the same computer as when connecting with Excel? From your screenshots, the only difference is that the second connection has provided the port number of the instance. How about removing the port number and connecting again? And ensure that the SSAS instance is running when you connect. 

In addition, you can use PowerShell on your computer to test the connection to the server where the SSAS instance is running. Test-NetConnection (NetTCPIP) | Microsoft Learn

Test-NetConnection -ComputerName "cubos.sispro.gov.co" -Port 2383

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[jcamilo1985]

Good morning.
first thank you very much for the answer @v-jingzhang.
Yes, it is the same equipment, for excel the connection is successful, but instead in power bi it fails. I did the test without including the port in the power bi dialog and the result is the same, I can't connect.
when I run the power shell it tells me:

ComputarName: cubos.sispro.gov.co
Remote Address: 181.79.3.29
Remote Port: 2383
InterfaceAlias: Ethernet
SourceAddress: 'my ip'
TcpTestSucceeded: True

[v-jingzhang]

Hi @jcamilo1985 

Sorry for the late reply. Maybe you have solved this problem. I just noticed that you were using the Basic authentication type to connect to the SSAS server. This could be a cause of the connection failure. Please use Windows authentication type. This is because SSAS server access is verified by Active Directory so you need to use a windows account to connect to it.  

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.