Power BI desktop / ssas live connection failure / Azure VM / shows anonymous login

[kaarel]

Hi!

I'm trying to connect from PowerBI Desktop to Azure VM (default Azure image) running SQL 2014 Enteprise. Local computer is on a corporate domain, Azure VM is not joined to a domain and has only local server user accounts.

I've added server's local user with necessary permission for SSAS to a new Windows Credential on the local client machine. Now it should use that user name every time when I'm trying to connect to Azure VM instead of coroporate account.

With some machines only, connection to SSAS fails. SSAS trace shows anonymous login.

How should I troubleshoot such an issue?

Best Wishes,

Kaarel.

[Greg_Deckler]

Are you just using a local PBIX file or an Enterprise Gateway for the connection?

[kaarel]

Hi. Local PBIX file.

[kaarel]

So the same issue still exists. When using Excel 2016 and I type in credentials manually, connection works. With Windows Credentials both Excel 2016 and PowerBI Desktop connection fails. Profiler shows "anonymous login".

When starting PowerBI using RUNAS command, then it connects. Somehow PowerBI Desktop won't recognize Windows Credentials.

[kaarel · Accepted solution]

The solution is to use DNS name instead of IP address in Credential Manager. Then it works.