Partial Load or Limit Load

Hi AvPowerBI ,

For queries for which the source data is not updated often or at all, it makes sense to not have the queries included in the refresh of the report. In this scenario, you can exclude queries from being refreshed when the report is refreshed by un-checking 'Include in report refresh' in the context menu of the query in Desktop or in the Properties screen:

Any queries excluded from refresh are also excluded in automatic refresh in the Power BI service.

Another you can try to select the multiple tables by holding down the CTRL button and selecting the tables->then right clicked and selected Refresh data.

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