Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Next up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now

Azure cube connection issue

Submitted by Anonymous on ‎12-17-2020 02:19 AM

I have a number of PBI dashboards each using Azure analysis server cubes and up until today they all ran fine.

Today, I try to open them and I get the following error message "Windows authentication isn't supported in DirectQuery mode for this data source".

I don't use a DirectQuery for my dashboards, and a colleague has been able to open one of them without problem.

 

My PBI Desktop version seems to have been updated to Dec 2020, whereas my colleague is still using Nov 2020 so I suspect there is some problem with Dec 2020.

 

It's very frustrating and I don't seem to be able to find a way to revert back to the Nov 2020 version.

Status: New
See more ideas labeled with:
20 Comments (20 New)
Comments
Anonymous
Not applicable
‎12-17-2020 11:55 AM

Worked for me as well! Thanks!

Anonymous
Not applicable
‎12-17-2020 02:58 PM

Many thanks arttuvuorin

 

This worked for me - I selected my organisation's Microsoft Account and bingo!

 

Cheers & thanks!

C-Jac
Helper I
Helper I
‎12-18-2020 01:07 AM

@Anonymous this worked for me as well. But we've just started rolling out this out to our report builders, do I have to explain everyone how to do this or do we think Microsoft might fix this? 

v-chuncz-msft
Community Support
Community Support
‎12-18-2020 01:27 AM

@Anonymous 

 

That works fine for me. You may also leave feedback at this Power BI Community forum post.

Anonymous
Not applicable
‎12-18-2020 02:03 AM

I have a similar problem with Amazon Redshift. Writes that the source does not support DQ. Can someone comment?

CaptainRik
New Member
‎12-18-2020 03:08 AM

Solution for me was - My datasouce had been reset to Windows by the upgrade. I reset it to Microsoft Account (as it should be) in "Edit Permissions" and all is well now.

CaptainRik_0-1608289591009.png

 

Anonymous
Not applicable
‎12-18-2020 01:21 PM

Same issue

v-chuncz-msft
Community Support
Community Support
‎12-21-2020 12:56 AM

@Anonymous 

 

See information on the support page.

 

Power BI customers using Azure Analysis Services as a data source and connecting with a Live Connection in the December 2020 version of the Desktop client may see the additional authentication options of "Windows" and "Basic" types which are not supported. Selecting these types will lead to connection failure errors. Users should update to the latest December 2020 version (2.88.702.0) released 12/18/2020 and choose "Microsoft account" authentication type when connecting to Azure Analysis Services data sources.

Anonymous
Not applicable
‎12-21-2020 03:01 PM

hi @v-chuncz-msft

 

That's a bit odd - my version is saying Version: 2.88.721.0

 

I reconnected via the Microsoft Account (like @CaptainRik ) and all was OK.

Anonymous
Not applicable
‎12-23-2020 04:28 AM

@Anonymous has the correct answer.

Idea Statuses