Sahil Hira

June 22, 2017 18:31

Trying to Sync Wrike with Excel

Follow

Hi 
I am trying to sync Excel with one of my reports in Wrike. I am using PowerQuery code (in advance query option). The code that I used is

let
    Source = Web.Contents("https://www.wrike.com/workspace.htm#path=reports-new&reportId=18709213", 
[Headers=[#"Authorization"="bearer <My_Wrike_Permanent_API_Access_Token>"]]),
convertToJson = Json.Document(Source)
in
    convertToJson

The error that I am getting is: -

Expression.Error: The 'Authorization' header is only supported when connecting anonymously. These headers can be used with all authentication types: Accept, Accept-Charset, Accept-Encoding, Accept-Language, Cache-Control, If-Modified-Since, Prefer, Referer.

Kindly suggest, what to do.

Regards,
Sahil 

• Spot On! 👍 Innovative Approach 💡 Stellar Advice 💪

  

  Pavel M

  June 26, 2017 11:46

  Hi Sahil! Sorry to hear you've run into this trouble! The code looks good to me, so it seems like an issue with software itself. First of all, could you please let me know whether you are using online Power BI version of the desktop one?

  I have found some evidence on Power BI community that Authorization header may not be accepted if you are using Power BI Web.

  In desktop software asks you to set up the level of access upon first connection and it should be 'Anonymous', everything is supposed to work fine at that point. 

  Pavel M Community Team at Wrike 🌎Discover... Wrike Discover and become a Wrike expert. Click here to get started

  Is this helpful? 0

  Comment actions Permalink

Please sign in to leave a comment.