Forum Discussion
how do I connect to SQL Server from Power BI desktop?
Hi there,
When you are using Power BI Desktop on a machine that is not on the same domain as the server, this does not seem to work.,
Is there a work around for this?
Thanks,
Ric
I would try one to the following:
1) Try a runas command like this: RUNAS /user:domain\userid /netonly "C:\Program Files\...[POWERBI EXECUTEBLE]
Use the domain and user you want to connect with and enter the password when prompted
2) Create a saved windows credential for the SSAS server you want to connect to
3) Go to the security of your SSAS severver and give read access to the other domain user you use with your desktop domain. I've don't that with our test domain here and it works fine as long as your sysadmin is fine with it.
Let me know if those ideas work.
Chad