I'm trying to connect Power BI with Analysis Services, but I can not. Being that through Excel I can connect. At the time of putting the IP of the server, I tried two ways: XXX.XXX.XXX.XXX or, as in connection to SQL Server, XXX.XXX.XXX.XXX:1433 (1433 being a port number). And then I choose the Import option.
And as credentials, I'm putting it as Basic and using a simple username and password. In the case of IP with port 1433, I'm getting this error:
AnalysisServices: A connection cannot be made. Ensure that the server is running
Already in the case without the port, it says: Unable to authenticate with the credentials provided. Please try again.
What else can I do to try to connect to Analysis Services with Power BI?