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
- AnonymousNot 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
Community 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.?"
- TerrenceBosNew Member
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 - jensphilipRegular 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.
- Bella42
Advocate IV
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.