Cant access my Azure Analysis Services Database - This server does not support Windows credentials.

[DebbieE]

Im trying to connect to my example Analysis Services Database. Ive added the Server name and the database and I want to do a direct import. I get to the message

Details: "This server does not support Windows credentials. Please try Microsoft account authentication."

Retry just keeps going back tothis message. If I click Edit it takes me back to Server and Database. No where Is there an option coming up where I can add my Microsoft Account Authentication. Its just going in circles without letting me in.

Is there anything I can do to save this one?

[dudziak]

I'm having the same issue. The server/users setup is fine. I just need to change the connection method from Windows to Microsoft, but it won't let me.

Retry doesn't work (obviously), and edit just takes you back to the server name entry field with no way to switch authentication methods.

I'll also add that creating a new PBIX file still doesn't fix the issue. That server name is saved somewhere as a Windows Authenticated connection.

SOLVED:  Go to File->Options and settings->Data source settings -> [Your Data Source] -> Edit Permissions -> Credentials -> Edit

[DebbieE]

Is there anything else after the edit?

[dudziak]

That's where I was able to change from Windows to Microsoft account authentication.

Your data source may also be in the global permissions tab, on the Data Source Settings Page.

[v-yuta-msft]

@DebbieE,

Please check if the server name you have input is valid. Here are some reference material below which may be helpful to you:

https://azure.microsoft.com/en-us/blog/connecting-power-bi-to-an-azure-analysis-services-server/

https://docs.microsoft.com/en-us/azure/analysis-services/analysis-services-manage-users

Community Support Team _ Jimmy Tao

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