Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Cannot run query in PowerBI

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:

 

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.

3 Replies

  • v-jingzhang's avatar
    v-jingzhang
    Icon for Community Support rankCommunity Support
    3 years ago

    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's avatar
      Anonymous
      Not applicable
      3 years ago

      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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

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