Refresh queries one by one.

[Vallirajap]

Hii All,

I have 10 different tables in a PBI report, and I want to refresh the report. It refreshes all queries at the same time, and sometimes it crashes for memory issues or whatever reason.

Is there any other way to run the queries one by one or one after one is completed?

Anyone who knows this, tell me the solution.

Thanks in advance!

[Fowmy · Accepted solution]

@Vallirajap 

If you encouter this issue in Power BI Desktop then you can right click and refresh each table or ctrl click, select a group of tables and choose refresh.

As far as the Power BI service is concerned there are mutiple scenarios, please refer these articles:
Troubleshoot refresh scenarios - Power BI | Microsoft Learn
Evaluation configuration settings for Desktop - Power BI | Microsoft Learn

[Nithinr]

file --> options & settings --> options --> dataload (global and current) . try chaning these settings  to one