Forum Discussion

ihavequestionto's avatar
ihavequestionto
Frequent Visitor
1 year ago
Solved

Invalid Connection Credentials When Adding API to On‑premises Data Gateway

Hello, When adding the API https://api.mktzap.com.br/company/:company_id/historycontact  to my On‑premises Data Gateway, I received the following error: Cannot refresh connection credentials. Inval...
Need Help
  • ihavequestionto's avatar
    ihavequestionto
    1 year ago

    Power BI Gateway Data Refresh Issue Resolution
    Troubleshooting Steps
    During a support call with Microsoft, assistance was provided and various tests were conducted to diagnose the issue.
    The solution involved creating a Generation 1 (Gen1) dataflow in Power BI. In this dataflow, a table was created to store the token generation link.
    The M code used in Power Query in Power BI Desktop was copied and pasted into the dataflow to enable data retrieval via the alternate link (this alternate link had been preventing the on-premises data gateway from refreshing data in the Power BI Service).
    Once the dataflow connection was added in the on-premises data gateway, the Power BI Service scheduled refresh was able to update the data successfully.

lbendlin's avatar
lbendlin
Super User
1 year ago

what is the error message?

ihavequestionto's avatar
ihavequestionto
Frequent Visitor
1 year ago

Using RelativePath, now the connection I’m trying to create is for this link: https://api.mktzap.com.br/.

When connecting as Anonymous and setting Privacy level to None, the following error is returned:

Unable to update connection credentials. Unable to connect to the data source. Either the data source is inaccessible, a connection timeout occurred, or the data source credentials are invalid. Please verify the data source configuration and contact a data source administrator to troubleshoot this issue.

Details: TIFGVTN-FILE: Falha no Web.Contents ao obter conteúdo de 'https://api.mktzap.com.br/' (404): Not Found Please have this information handy if you choose to create a support ticket. Session Id: faaa0463-fab0-456d-b0a7-ae2a5ac9b74e RequestId: 68946402-739e-4a11-927e-a2e14b5a3068 Cluster URI: https://api.powerbi.com Status code: 400 Time: Thu Apr 24 2025 16:32:40 GMT-0300 (Hora padrão de Brasília)