Forum Discussion

snoring's avatar
snoring
New Member
3 months ago
Solved

Issue with Data Refresh against ShipStation API

I am successfully connecting to The ShipStation API with a Web Data Source.  I have goten confirmation that my query is exactly right and I am successfully pulling data initially.  The Auth method is...
dataflow
  • snoring's avatar
    snoring
    3 months ago

    This is issue is resolved.  I had to check "Skip Test" for the Service Datasource anonymouse setting for it to take.

GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
3 months ago

Hi snoring 

 

This can sometimes happen when your data source has got variable API coming back. And what that happens then is when you're actually running the query it is using a different call so the credentials will not get passed through successfully. An option to get this working is to store the credentials in the header if possible. Here is an example. https://blog.crossjoin.co.uk/2014/03/26/working-with-web-services-in-power-query/amp/ 

  • snoring's avatar
    snoring
    New Member
    3 months ago

    Thanks.  I do have the creds in the Header node. Im using the production key since its V2.  The query has been scanned and its using best practice. 

    • GilbertQ's avatar
      GilbertQ
      Icon for Super User rankSuper User
      3 months ago

      Can you change it to be Anonymous?

      • snoring's avatar
        snoring
        New Member
        3 months ago

        Yes teh Power Bi Desktop report is set to Anonymous.  However the Power Service will not connect as anonymous which os part of this issue.