Error at Atlas API Azure in PowerBI Service

[frcampos5150]

Hi, 

I'm using the azure Maps api which, based on a pair of coordinates from my MySql database, returns the satisfactory result via PowerBI Desktop. However, when I publish to PowerBI Service it returns this error (I removed the Key).

Can someone help me?

Algo não deu certo
Erro durante o processamento de dados no conjunto de dados.
Tente novamente mais tarde ou entre em contato com o suporte. Se você entrar em contato com o suporte, forneça esses detalhes.
Erro de fonte de dados: {"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":"[Unable to combine data] Section1/03-ContentorDispositivo/Changed Type4 references other queries or steps, so it may not directly access a data source. Please rebuild this data combination."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.DataSources","detail":{"type":1,"value":"[{\"kind\":\"Web\",\"path\":\"https://atlas.microsoft.com/search/address/reverse/json?subscription-key=XXXXXXX\\u0026api-version=1...}}}
Cluster URI: WABI-BRAZIL-SOUTH-redirect.analysis.windows.net
ID da atividade: 5dbb3ec5-1aae-4bba-a2e4-2bcfa97b6fe5
Solicitar ID: 117ecad7-7a75-f24e-dbe1-223d4a98de98
Hora: 2020-03-30 18:48:17Z

[Anonymous]

HI @frcampos5150,

According to your error message, it seems like you do some advanced operations(merge, combine, reference, custom function) in your query table. (combination and reference one query table in other query table steps)
Current power bi service not fully support datasets that mixed with multiple type data sources and you may face the issue when you configure/refresh mixed data sources.

Maybe you can try to create a variable step to store the referenced query data source in the current query table instead of reference and calculate across multiple query tables.

let
	Source1=xxxxx,//query table1
	Source2=xxxxx,//query table2
	Custom=xxxx
in
	Custom

Regards,

Xiaoxin Sheng

[Greg_Deckler]

You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".