the direct query of Power BI and its alternative in the on prem space

You may either directly query your databases with Power BI or have an in-memory snapshot of the data to make the reports load snappier. The in-memory thing is going to have the "eventually consistent" problem.