cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Super User I
Super User I

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

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?

4 REPLIES 4
Highlighted
Community Support
Community Support

@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.

Highlighted
New Member

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

Highlighted

Is there anything else after the edit?

Highlighted

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.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors