Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Power BI Service API authentication (Freshservice)

Hi all,   I'm pulling data from an API in an application called Freshservice (maybe there's someone out there using a similar source). In Desktop, it works perfectly, but I cannot get Service to au...
Dataflow
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Apologies if this was in the wrong place. Since fixed though, so I haven't logged it as an issue. In summary:

    Through Power BI Desktop you can either set an authorisation header or specify Web API credentials to connect and pull data from Freshservice's API. Neither of these methods can be mirrored in Power BI Service; Web API cannot be set and it doesn't like the authorisation header being used.

     

    Instead, you can connect to the API URL and authorise using 'Basic'. Enter your normal credentials for Freshservice, not your API key. And by 'normal' I mean not your SSO credentials if you typically login with an organisational domain account.

    Power BI Service will pick up the API URL as a source and your normal credentials can be entered here too. So far, so good, automatic refreshing is working fine.