Fórum

I created a Power BI dashboard that gets some information from the jobs page using the Gupy API.

When using Power BI Desktop the data, apparently, is fetched correctly, but when the dashboard is published to the Power BI service, it returns the error below:

Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"[Não foi possível combinar dados] Section1/FatAplicacoes/Valor Substituído faz referência a outras consultas ou etapas, portanto, pode não ter acesso direto a uma fonte de dados. Recompile esta combinação de dados."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.DataSources","detail":{"type":1,"value":"[{"kind":"Web","path":"https://api.gupy.io/api/v1/jobs/4249454/applications?perPage=100\u0026page=1\u0026fields=all"}]

The API url that is being displayed in the error is automatically inserted to the dashboard because of the code in Power Query to retrieve the data using a token to the API. If I try to insert the data source manually using the token or anonymously, it returns the errors in the screenshots below:

"A Web API key can only be specified when a name to the Web API key is provided."

"It wasn't possible to authenticate with the provided credentials. Try again"

I already tried contacting Microsoft and after testing various different settings, they informed that the problem lays with the API.

Can somebody, please, help with this problem?