How to do several data refresh simultanealy

Anonymous · ‎12-09-2020

I have a server with around of hundred .pbix published.
Some of them are schedule to be refreshed once a day, but several refresh each hour.

The problem is that in some moments the logs file shows that it has, for exemple, 20 .pbix are beeing refreshed, but when I do a query in the source database (DW) to look for the PBI querys I see that just a few queries are running in the same moment.

I supose that the AnalysisSever wait to finished the firsts refreshs to run the others
Is there any way, any configuration that turn possible to refresh serveral .pbi in the same time?

thanks

josef78 · ‎12-11-2020

Data Refresh loads is by default running simultaneously. I'm not sure if it is configurable, or is dependent on some connection pool (dependent e.g. on number of cores). I my case I see aprox. up to 20 refresh jobs which is connected to source at same time (more is in some queue)