Cannot run query in PowerBI

[Anonymous]

Hi, anyone can help me to expain below question:

I am using Kusto to  do a cross cluster query, it works well.

But when I export it as a PowerBI query and excute in PowerBI.

It gives me below error:

[v-jingzhang]

Hi @Anonymous 

Can you please show the complete error message (remove sensitive info)? Is there something NOT FOUND?

My guess is that Power Query perhaps cannot do a cross cluster kusto query in a single query. To deal with that, you may try the following tips: Power Query Azure Data Explorer (Kusto) connector - Power Query | Microsoft Learn

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it. Highly appreciate your Kudos!

[Anonymous]

But, if PowerBI can support the cross cluster query, that would be great.

[Anonymous · Accepted solution]

Thanks for your support, we've already had a workaround  to solve this problem that is to migrate all other data to one cluster, then the query worked.