Forum Discussion

mekaelj's avatar
mekaelj
Icon for Helper II rankHelper II
9 years ago
Solved

All queries not refreshing

Hi,

 

I have a few queries that I've loaded from SQL servers. When I hit refresh in Power BI desktop, they all refresh except for one query. I can however refresh it manually by right-clicking the query and hitting refresh query. How come this specific query is not included in the refresh and what can I do to include it moving forward?

 

Regards,

 

Mikael

Need Help

5 Replies

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Icon for Community Support rankCommunity Support
    9 years ago

    mekaelj,

     

    In the Query Editor, right click the query and check "Include in report refresh".

    • mekaelj's avatar
      mekaelj
      Icon for Helper II rankHelper II
      9 years ago

      Cheers mate, was hoping it'd be something really easy!

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thank you so much! I've been fighting with this a report refresh issue off and on for weeks, but I think this is the solution!

  • rameshep's avatar
    rameshep
    New Member
    1 year ago

    I was struggling with this issue since one query out of may was not getting refreshed in report.  The query regarding the issue in copilot redirected me to this site.  The issue is resolved.  Thanks a lot....