asked on January 25, 2021
My config is the following:
CONNECTION_STRING=Data Source='powerbi://api.powerbi.com/v1.0/myorg/<company workspace>';user id=<user@company.com>;password=<password>
The error I get is this:
Unable to obtain authentication token using the credentials provided. If your Active Directory tenant administrator has configured Multi-Factor Authentication or if your account is a Microsoft Account, please remove the user name and password from the connection string, and then retry. You should then be prompted to enter your credentials.
at Microsoft.AnalysisServices.AdomdClient.AadAuthenticator.AcquireToken(String resource, String dataSource, String identityProvider, String tenantId, String userId, String password, Boolean useAdalCache, Boolean useAdTranslation)
at Microsoft.AnalysisServices.AdomdClient.AadAuthenticator.AcquireTokenForPbiPremium(String workspaceName, String resource, String dataSource, String identityProvider, String tenantId, String userId, String password, Boolean useAdalCache, Boolean useAdTranslation)
at Microsoft.AnalysisServices.AdomdClient.ConnectionInfo.ResolveHTTPConnectionPropertiesForPaaSInfrastructure(Uri& dataSourceUri, Boolean acquireAADToken, Boolean returnCloudConnectionAuthenticationProperties, String& paasCoreServerName, CloudConnectionAuthenticationProperties& cloudConnectionAuthenticationProperties)
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.OpenHttpConnection(ConnectionInfo connectionInfo, Boolean& isSessionTokenNeeded)
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(Boolean toIXMLA)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.ConnectXmla()
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()
at Flexmonster.Accelerator.Controllers.FlexmonsterProxyController.TestConnection() in C:\Work\git\PIVOT\projects\Datasource Proxies\Microsoft SSAS\Flexmonster.Accelerator\Flexmonster.Accelerator.Core\Controllers\FlexmonsterProxyController.cs:line 1117
A couple of months ago, in the exact same conditions, things were working. Nothing really changed on our side, and multi-factor auth is indeed disabled for the specified user.
Do you have any idea on this?
Best,
Miguel
⋅ January 27, 2021
Hello, Miguel,
Thank you for reaching out to us.
Our team would like to kindly explain that no major changes have been made to the Accelerator in the latest release versions of Flexmonster.
It seems the connection failure could be caused by the credentials that you are passing.
Could you please try connecting to the same XMLA endpoint with Excel or Microsoft SQL Management Studio (MSMS) and share the result with us?
This would help our team to understand the source of the issue better.
Looking forward to your reply.
Kind regards,
Vera
⋅ January 29, 2021
With SSMS I can easily connect to the Power BI workspaces, with exactly the same credentials.
⋅ February 1, 2021
Hello, Miguel,
Thank you for your response.
It does seem like an issue; still, the cause is not entirely clear to us.
Do you think you could please provide us with the XMLA endpoint and user credentials with which the issue is reproducible, so our team could connect to the endpoint on our end and investigate the issue? This would allow our team to run all the necessary tests and provide the solution faster.
Any sensitive information can be sent to us via email.
Looking forward to your reply.
Kind regards,
Vera
⋅ February 3, 2021
Hey Vera,
In the meantime I managed to overcome the issues by using service principal authentication and reinstalling the component.
Thanks for the support.
