Odata Feed with Archer App

[Bsim89]

Hello experts,

I have a problem when I try to connect to an API that points to an Archer application.

I access the application on the web without any problem.

Is there anyone who has ever tried to connect Power BI with Archer and had the same error ?

Thanks,

Marouane

[luismorais_]

Hi @Bsim89 !

I'm also using the content api to connect to a Archer Feed.

There's a few takeways and configurations that may bring different results from our application intead of yours, but the steps that worked for me were:

1. Connect trough a OData Feed Connection
2. Use a Basic authentication method
3. In the username you should use literally "session-id", nothing else
4. The password is the Session Token generated by the Archer application. Here I also suggest that you create a specific user to powerbi and configure to return a fixed Session Token, otherwise I'll have to generate another one every time.

Here are two links that may help you

https://community.rsa.com/yfcdo34327/attachments/yfcdo34327/archer-blog/2966/1/Report%20Like%20a%20B...

https://community.rsa.com/t5/archer-discussions/how-do-you-create-an-archer-api-session-token-using-...

Hope it helps.

[Anonymous]

 Can you please provide the url of API which we need to pass in Odatafeed?

[Anonymous]

Hi, Can you please provide the url of API which we need to pass in Odatafeed?

[Monaam]

I know it's an old question, but it's for other people who may have the same issue.

use your URL base and add to it /RSAarcher/contentapi

[v-lili6-msft]

hi,@Bsim89

       I have tested on my side, but not reproduce the issue.you may submit a support ticket.

       https://powerbi.microsoft.com/en-us/support/

Best Regards,

Lin