Forum Discussion
Invalid Credentials Web API but works in Desktop
I am trying to create a Dataflow using a weather API from Visual Crossing Weather Data Services. I am using their weather query builder to generate the API link (with my proper API Key), and copy/pasting that into the URL section in the Web API tool in Dataflows. No gateway should be necessary with the API tool.
I get the following error:
Invalid credentials. (Session ID: a8755ade-66e8-4a87-8478-a47dcf6ef012, Region: us)
I can copy my link into my browser and i get the desired output. I have also used it in the Desktop Web tool and it works just fine there also. I have used other Weather API services without issue.
Any thoughts?
Edit, here is the expanded details when i go to my Data Source Settings
Unable to update this data source's credentials. Invalid connection credentials.
Error code: InvalidCredentials
Data source error: Invalid credentials
Cluster URI: https://api.powerbi.com
Activity Id: 0da38432-9ec8-4024-b54a-78fa549413f9
Request ID: e077072f-7cd8-4dc5-b045-2622fe5ff22c
Time: Wed Mar 08 2023 16:53:33 GMT-0600 (Central Standard Time)
:
undefined: Missing or invalid credentials for data source. Reason = 'AccessUnauthorized', DataSource = '<ccon>Web/https://weather.visualcrossing.com/VisualCrossingWebServices/rest/services/timeline/owensboro,%20ky/yesterday</ccon>', DataSourceReference = '', DataSourceOrigin = '', DataSourceReferenceOrigin = '', InnerExceptionMessage = 'inner exception message 0: The credentials provided for the Web source are invalid. (Source at https://weather.visualcrossing.com/VisualCrossingWebServices/rest/services/timeline/owensboro,%20ky/yesterday.), inner exception stacktrace 0: at Microsoft.Data.Mashup.ProviderCommon.MashupResource.<>c__DisplayClass47_2`1.<StartEvaluationAndGetResultSource>b__0()
at Microsoft.Mashup.Security.Impersonation.RunAsProcessUser[T](Func`1 func)
at Microsoft.Data.Mashup.MashupCommand.EvaluateAndGetSource[T](String commandText, CommandType commandType, Int32 commandTimeout, MashupParameterCollection parameters, String resultTransform, Boolean forColumnInfo, Boolean executeAction)
at Microsoft.Data.Mashup.MashupCommand.ExecuteReader(CommandBehavior commandBehavior, MashupCommandBehavior mashupCommandBehavior)
at Microsoft.Data.Mashup.MashupCommand.ExecuteReader()
at Microsoft.Data.Mashup.DataSourceReference.TestConnection(String connectionString)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayDataAccess.GatewayDataAccessMashupUtils.DSRTestConnectionAsync(String dsrJson, MashupCredential credential, Nullable`1 activityId, Int32 testConnectionTimeout, String[] exemptions, String containerPool)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayDataAccess.MashupOleDbConnectionProvider.<>c__DisplayClass7_0.<<TestConnectionAsyncImpl>b__0>d.MoveNext()
--- 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.DataMovement.Pipeline.GatewayDataAccess.MashupOleDbConnectionProvider.<TestConnectionAsyncImpl>d__7.MoveNext().
'.
No RepliesBe the first to reply