topic QEM REST API Login using Power BI in Qlik Replicate

QEM REST API Login using Power BI

gmarchezi — Tue, 30 Sep 2025 14:09:02 GMT

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?

Re: QEM REST API Login using Power BI

narendersarva — Wed, 01 Oct 2025 20:59:54 GMT

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

Re: QEM REST API Login using Power BI

DesmondWOO — Thu, 02 Oct 2025 08:13:12 GMT

Hi @gmarchezi ,

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

Regards,
Desmond

Re: QEM REST API Login using Power BI

marina_marshak — Wed, 08 Oct 2025 13:14:25 GMT

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 Manager Help