jensphilip's avatar
jensphilip
Regular Visitor
2 years ago
Status:
Investigating

access-token is required Power bi desktop files

Hi all,

 

Keep getting this error when I try to open my power bi desktop files. "When interactive authentication is not supported, an external access-token is required; either provide it in the connection-string or by setting the AccessToken property."

 

My IT department cannot help 😞

 

Feedback Type:
Frown (Error)

Timestamp:
2023-12-21T07:06:07.7841396Z

Local Time:
2023-12-21T08:06:07.7841396+01:00

Session ID:
097ad7d0-b3c6-4a8f-906a-eac81e0ec3a1

Release:
November 2023

Product Version:
2.123.742.0 (23.11) (x64)

Stack Trace:
System.InvalidOperationException
at Microsoft.AnalysisServices.AdomdClient.ConnectionInfo.AcquireAADTokenAndResolveHTTPConnectionPropertiesForPaaSInfrastructure(IConnectivityOwner owner, Uri& dataSourceUri)
at Microsoft.AnalysisServices.AdomdClient.HttpStream.Create(IConnectivityOwner owner, ConnectionInfo info, XmlaDataType desiredRequestType, XmlaDataType desiredResponseType, Int32 readTimeout, Boolean& isSessionTokenNeeded)
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.OpenHttpConnection(ConnectionInfo connectionInfo, Boolean& isSessionTokenNeeded)
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.OpenConnectionAndCheckIfSessionTokenNeeded(ConnectionInfo connectionInfo)
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.OpenConnection(ConnectionInfo connectionInfo, Boolean& isSessionTokenNeeded)
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Connect()
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()
at Microsoft.PowerBI.Client.Windows.LiveConnectHelpers.AnalysisServices.AdomdQueryExecutor.OpenConnectionAndExecute[T](IAdomdConnectionPool connectionPool, IAdomdConnectionFactory connectionFactory, String connectionString, QueryExecutionOptions executionOptions, IPowerBITelemetryService telemetry, Func`2 execute)
at Microsoft.PowerBI.Client.Windows.LiveConnectHelpers.AnalysisServices.ASLiveConnectionProperties.ASLiveConnectionPropertiesValidatorInternal.<>c__DisplayClass4_1.<Validate>b__1()
at System.Threading.Tasks.Task`1.InnerInvoke()
at System.Threading.Tasks.Task.Execute()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.Client.Windows.LiveConnectHelpers.AnalysisServices.ASLiveConnectionProperties.ASLiveConnectionPropertiesValidatorInternal.<Validate>d__4.MoveNext()

PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.123.742.0","ModuleName":"Microsoft.PowerBI.AdomdClient.dll","Component":"Microsoft.AnalysisServices.AdomdClient.ConnectionInfo","Error":"System.InvalidOperationException","MethodDef":"AcquireAADTokenAndResolveHTTPConnectionPropertiesForPaaSInfrastructure","ErrorOffset":"19","ErrorCode":""}

OS Version:
Microsoft Windows NT 10.0.22631.0 (x64 en-US)

CLR Version:
4.8 or later [Release Number = 533320]

Peak Virtual Memory:
70.1 GB

Private Memory:
353 MB

Peak Working Set:
686 MB

IE Version:
11.1.22621.0

User ID:
e6e9119a-5615-4be6-9da4-eb9eab940459

Workbook Package Info:
None

Telemetry Enabled:
True

DPI Scale:
125%

Supported Services:
Power BI

5 Comments

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi jensphilip ,

     

    Based on error messages,You need to acquire AAD Token And Resolve HTTP Connection Properties For PaaS Infrastructure.

     

    Best regards.
    Community Support Team_Scott Chang

  • DebbieE's avatar
    DebbieE
    Icon for Community Champion rankCommunity Champion

    I am also having this issue and the above solution is not helpful. How do you "acquire AAD Token And Resolve HTTP Connection Properties For PaaS Infrastructure.?"

  • Similar issue over here. I'm trying to connect PBI to Tabular Editor from a company owned device. I'm receiving the following message. Any suggestions for a solution? 

    tabular editor when interactive authentication is not supported, an external access-token is required; either provide it in the connection-string or by setting the AccesToken property

  • jensphilip's avatar
    jensphilip
    Regular Visitor

    I disovered that you can get access if rebooting or keep trying open the file  - 3rd or 4th time it will open and microsoft account popup appears.

  • Thanks for the laugh. How helpful. NOT. Hilarious. Oh, that clears it right up. I keep looking for the cameras, this must be a joke. So just get the AAD and resolve the HTTP for the PaaS, right, of course, silly me.