Connecting to Analysis Services Tabular problems and questions

[Anonymous]

Background:

Cloud-based stand alone server (not a VM) with Windows Server 2019 and SQL Server Standard 2019.

On-premise Data GateWay is installed and working.

This server is not part of a domain.

In powerBi :

They are using O365  licences, including a PRO-Trial licence. The service is configured, and connections to SQLserver and Analysis services are OK.

The problem using PowerBi desktop:

Direct: We could not connect to the Analysis Services server because the connection timed out or the server name is incorrect

Import: We Couldn’t authenticate with the credentials provided.

Excel.  Works perfectly.

Questions:

1. It seems the only way to make this work is for the server to be part of a  domain.   IS THAT TRUE?
2. PowerBI  DataGateWay cannot be installed on a domain controller server. Is that true?   Note, if this is true I need 2 servers.
3. Are there any workarounds?

[V-lianl-msft · Accepted solution]

Hi @Anonymous ,

Please refer to the same theread:

https://community.powerbi.com/t5/Desktop/Connecting-to-SSAS-for-a-non-domain-user/m-p/92512 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Syndicate_Admin]

Watsky,

We are sorry when you enter the database results in the same message.

Thank you

Entering the Database makes no difference.

[Watsky]

Hey @Anonymous  when you try to load the server are you loading it with the db cube (optional) Database listed? If not give that a try. 

also see this thread for similar issue:

https://community.powerbi.com/t5/Desktop/Connecting-to-Analysis-Services-Tabular-problems-and-questions/m-p/1594942#M646519

Did my answer(s) help you? Give it a kudos by clicking the Thumbs Up! ?
Did my post answer your question(s)? Mark my post as a solution. This will help others find the solution.