Error Power Query

[Anonymous]

Good Morning!

I made a query in several spreadsheets through OneDrive, it was working perfectly, but today it has the following error

Erro inesperado: [DataFormat.Error] Não foi possível reconhecer a entrada como um documento do Excel válido.

Detalhes:

Microsoft.Mashup.Engine1.Runtime.ValueException: [DataFormat.Error] Não foi possível reconhecer a entrada como um documento do Excel válido. ---> System.ArgumentException: O valor especificado possui caracteres CRLF inválidos.

Nome do parâmetro: value

em System.Net.WebHeaderCollection.CheckBadChars(String name, Boolean isHeaderValue)

em System.Net.WebHeaderCollection.Set(String name, String value)

em System.Net.WebHeaderCollection.set_Item(HttpRequestHeader header, String value)

em Microsoft.Mashup.Engine1.Library.Http.HttpResourceCredentialDispatcher.WebRequestCredentialDispatcher.Apply(OAuthCredential credential)

em Microsoft.Mashup.Engine1.Library.Http.HttpServices.ApplyCredentials(MashupHttpWebRequest httpRequest, String resourceKind, Uri requestUri, ResourceCredentialCollection credentials, IEngineHost hostEnvironment, String oAuthResource)

em Microsoft.Mashup.Engine1.Library.Http.HttpRequest.ApplyCredentialsToRequest(WebRequest webRequest, ResourceCredentialCollection credentials)

em Microsoft.Mashup.Engine1.Library.Http.Request.CreateWebRequest(Uri uri, ResourceCredentialCollection credentials)

em Microsoft.Mashup.Engine1.Library.Http.Request.CreateResponse(ResourceCredentialCollection credentials)

em Microsoft.Mashup.Engine1.Library.Http.Request.GetResponseCore(ResourceCredentialCollection credentials)

em Microsoft.Mashup.Engine1.Library.Http.RetryPolicy.Execute[TResult](IEngineHost host, Func`1 func)

em Microsoft.Mashup.Engine1.Library.Http.Request.GetResponse(ResourceCredentialCollection credentials, RetryPolicy retryPolicy, SecurityExceptionCreator securityExceptionCreator, Boolean tokenRefreshed)

em Microsoft.Mashup.Engine1.Library.Web.WebContentsBinaryValue.GetResponse(Request request)

em Microsoft.Mashup.Engine1.Library.Web.WebContentsBinaryValue.OpenStream()

em Microsoft.Mashup.Engine1.Library.Web.WebContentsBinaryValue.Open()

em Microsoft.Mashup.Engine1.Library.Common.SeekableBinaryValue.Open()

em Microsoft.Mashup.Engine1.Library.Excel.ExcelFile.<>c__DisplayClass22_0.<Open>b__0()

em Microsoft.Mashup.Engine1.Library.Excel.ExcelFile.EnsureNotHtmlResponse(Func`1 streamCtor)

em Microsoft.Mashup.Engine1.Library.Excel.ExcelFile.Open(String& contentKey)

em Microsoft.Mashup.Engine1.Library.Excel.ExcelReaderOpenXml.ReadTablesUnguarded()

em Microsoft.Mashup.Engine1.Library.Excel.ExcelReaderOpenXml.ReadTables()

--- Fim do rastreamento de pilha de exceções internas ---

em Microsoft.Mashup.Evaluator.EvaluationHost.OnException(IEngineHost engineHost, IMessageChannel channel, ExceptionMessage message)

em Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)

em Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)

em Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)

em Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)

em Microsoft.Mashup.Evaluator.Interface.IMessageChannelExtensions.WaitFor[T](IMessageChannel channel)

em Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.WaitFor(Func`1 condition, Boolean disposing)

em Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.get_TableSource()

em Microsoft.Mashup.Evaluator.Interface.TracingPreviewValueSource.get_TableSource()

em Microsoft.Mashup.Host.Document.Analysis.PackageDocumentAnalysisInfo.PackagePartitionAnalysisInfo.SetPreviewValue(EvaluationResult2`1 result, Func`1 getStaleSince, Func`1 getSampled)

[amitchandak · Accepted solution]

@Anonymous , Under home Tab -> Transform data -> Data source setting  -> Clear connection permissions and refresh and try again

[emsiv]

Thanks so much for this solution. I spent the last week searching for the root cause of the exact same error, bothered IT several times and lost so much time...

Thank you sir !