cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
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

Is there anything else after the edit?

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.

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.

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors