QEM REST API Login using Power BI

[gmarchezi]

Hello guys,

I'm trying to use the QEM REST API to get replication info from Enterprise Manager into a Power BI dashboard.
When I try to authenticate (https://{host}/attunityenterprisemanager/api/v1/login), I can't retrieve the EnterpriseManager.APISessionID header, because Power BI has some limitations regarding access to certain response headers using its Web.Contents function.

My question is: Is there a way to get the EnterpriseManager.APISessionID in the response body? Or is there any workaround that doesn't require an external solution and keeps everything inside Power BI?

Qlik Enterprise Manager 

Qlik Replicate 

[narendersarva]

Hi @gmarchezi 

I don't think so we can get the EnterpriseManager.APISessionID in the response body. Try to check any script such as python or any other script which can access QEM and retrieves the session token and exposes the data in a way Power BI can consume. 

Thanks
Naren

[DesmondWOO]

Hi @gmarchezi ,

Could you check if "Power BI Customer Connector" helps in your scenario?

Regards,
Desmond

[marina_marshak]

What authentication method are you using (api key/JWT) ? Please see below the link to documentation on how you can access it.

Setting the login authentication method #Setting the login authentication method | Qlik Enterprise M...