Forum Discussion

samw5's avatar
samw5
Icon for Helper II rankHelper II
5 years ago

Visualazation not loading after appending queries

I have a total of 126 queries in a PowerBI report that get appended into 2 single queries (63+63). 

Queries are getting aggregated from Azure Log Workspaces. 

 

From there I use slicers to filter out on my visualizations. 

My issue is that while it worked OK with a few of the queries appended, I can't seem to be able to show the data with all 63 queries appended in the main one.

I am able to refresh the data just fine (it's taking a little bit of time, like 10-20min to refresh all) but even once completed and I hit Close&Apply all the data doesn't seem to be accessible.


Any ideas what I may be doing incorrectly? Also any ways that I could possibly speed up the various queries?

Need Help

2 Replies

  • v-deddai1-msft's avatar
    v-deddai1-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi samw5 ，

     

    Did you get any error message when you click  Close&Apply? Why not append these tables in your datasource when you need append so many queries?

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    Best Regards,

    Dedmon Dai

    • samw5's avatar
      samw5
      Icon for Helper II rankHelper II
      5 years ago
      Can't apply all the queries in the datasource (at least I don't think I can) as they are from different Azure environments (different creds). Also I'm able to fetch the data from the queries however when trying to append it to my main queries it eventually crashes PowerBi. Any suggestions on how this could be achieved?