DataFormat.Error in Power Query

JanakiRam · Feb 22, 2016

Hi All,
I am getting below error in Power Query while pulling data from web.

DataFormat.Error: Specified value has invalid CRLF characters.
Parameter name: value
Details:
OAuth oauth_consumer_key="@@@",oauth_nonce="@@@",
oauth_signature="@@@", oauth_signature_method="HMAC-SHA1?
Note : if i removed quotes for the above parameters from the blow code i am getting Invalid Identifier error : (

let

Source = Web.Page(Web.Contents("https://api.twitter.com/1.1/search/tweets.json?q=spotfire"),[Headers=[#"Authorization"="OAuth oauth_consumer_key=""@@@"",
oauth_signature=""@@@"", oauth_signature_method=""HMAC-SHA1?", oauth_timestamp="@@@",
oauth_token="@@@", oauth_version="""1.0?"""]])
in
Source

Ken Puls · Mar 31, 2016

Hi Janaki,

I just realized that this thread got caught in moderation. Are you still having this issue?

DataFormat.Error in Power Query

JanakiRam

New member

Ken Puls

Administrator