Connecting an Analysis Services cube from an external server to the PowerBI desktop client
PowerBI is a fairly intuitive tool to perform data visualization, one of the advantages is that it can connect to many data sources so an Analysis Services cube that is from Microsoft itself should not be the exception.
You probably want to make a very useful dashboard with the cube data, you have also the connection data, but when trying to access the Analysis Services cube from PowerBI the following error is displayed.
Seeing this, there is reason to believe that maybe the server is not active (because sometimes it is), so first we will see with another tool if the server responds and it is possible to connect.
For example Excel, if the connection is possible, then the server is active and we have a problem with the PowerBI client.
Solution
Since we have the network user with which we can access the server, we can use it as the user when starting PowerBI, so the windows user with which the PowerBI desktop client is running will be the one that can access the server.
runas /netonly /user:user:company "RUTA "RUTA "PBIDesktop.exe".
With this command we can then re-add the connection or refresh the data for our PowerBI dashboard.
I hope this small contribution will be of help and do not hesitate to contact us if other doubts arise because we are here to solve them.
See you next time!