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: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

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 04:49 AM

We have the same issue.  We thought it might be because of an issue with Analysis Services:
This was posted yeaterday by Microsoft:

"We are excited to announce that DirectQuery for Power BI datasets and Azure Analysis Services is now in preview! This long-awaited addition allows report authors to use DirectQuery to connect to Azure Analysis Services or Power BI Datasets and, if they want to, combine it other DirectQuery and imported data.

Note that at the moment, we are waiting for some final Azure Analysis Services updates which are rolling out this week. You will be able to try this feature against Power BI Datasets, and support for connections to Azure Analysis Services will come by the end of this week."
So we thought that might be the issue with this error message. But would love confirmation by Microsoft.

It would be nice to have the last released version also availble to download so you can fall-back when you experience issues. We fortunetely had a previous version in our download folder.

 

C-Jac
Helper I
Helper I
‎12-17-2020 05:19 AM

I have the same issue, just discovered today. I can't even make a regular import when trying to connect to Analysis Services. 

 

I cannot open previous created reports which are connected to Analysis Services. 

myraaw
New Member
‎12-17-2020 07:14 AM

A colleague of mine is having the same issue.  He's getting the error "Windows authentication isn't supported in DirectQuery mode for this data source" trying to open a Power BI report connected to Azure Analysis services tabular model.  This just happened recently, since he's able to open the report a few days prior.  He has Power BI Desktop version 2.88.621.0 64-bit (December 2020).

 

I have a lower version and am able to connect fine.  Can somebody please help get this resolved ASAP.

 

Thanks!

 

 

bbriggs
Frequent Visitor
‎12-17-2020 09:46 AM

I have the same issue with the December release.  Please help!

FelipeDBA
Frequent Visitor
‎12-17-2020 10:21 AM

Same issue here.

Anonymous
Not applicable
‎12-17-2020 10:24 AM

I'm getting the same issue. I have the December 2020 version. Help!

Anonymous
Not applicable
‎12-17-2020 10:25 AM

Same issue here, just when we started to rollout Power BI Desktop for our report builders.

FelipeDBA
Frequent Visitor
‎12-17-2020 10:27 AM

FelipeDBA_0-1608229574109.png

 

Seems like de the December version is forcing Direct Query for Azure Analysis Services.

Anonymous
Not applicable
‎12-17-2020 11:23 AM

You need to clear permissions from data source settings for that AAS connection. Open a blank Power BI report, go to Data Source Settings and select correct global permission and Delete it.

arttuvuorin_0-1608232937283.png

 

After that open Power BI report with live connection to AAS model and it should prompt for login. Select Microsoft/Organizational login and you should be able to connect again.

bbriggs
Frequent Visitor
‎12-17-2020 11:54 AM

This worked for me.  Thanks for your help arttuvuorin!

Idea Statuses