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 ...
Need Help
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