Forum Discussion

frcampos5150's avatar
frcampos5150
Regular Visitor
6 years ago

Error at Atlas API Azure in PowerBI Service

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.0\\u0026query=-22.406436%2C-41.865854\"}]"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.Reason","detail":{"type":1,"value":"PrivacyError"}}],"exceptionCulprit":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

 

 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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