Working API Load Model Wont authenticate in online

[Anonymous]

Hi All,

I have a working model that fetches data from an API using an API key embedded in the model.

The models works fine & pulls the data through. My issue is that the web part of my datasource wont authenticate online (under 'data source credentials'.

It seems to be that because it wont pass the key in the basic auth check online, it will not allow me to refresh (and if I ask it to ignore the auth check, it fails anyway)

I've tried the 'RelativePath' hack, but because my URL (https://api-reputation.com/v3/reviews) doesn't seem to have any valid non-encrypted parts, i can't get that to work either.

Please help me find another way around it!

Thanks all

[Anonymous · Accepted solution]

Hi @Anonymous ,

Ensure that the API you're trying to connect to supports the authentication method you're attempting to use. 

Set up your Web connection - Microsoft Fabric | Microsoft Learn

If your API requires a specific type of authentication (e.g., API Key), using Basic Auth might not be the appropriate method.

If your API requires an API key for authentication and does not support Basic Auth, you might need to pass the API key through custom headers. 

If it does not help, pleasee provide more details.

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi Rongtie, thanks for tracking back. The model was working file & refreshing overnight every night. However, the previous admin is leaving, so I 'took over' the model online - which wiped all the credentials. I've been told it's simply 'basic' and 'none' for privacy, but it's no longer allowing me to refresh. The model itself has the custom headers built in, but I cannot pass customer headers through the online authentication can I?

[Anonymous]

Update - it was the privacy level... it needed to be set to 'Organisational'

[Anonymous]

Can anyone help?