SQL Data did not truly refresh

Hi all,

Recently, I opened a template and waited a few minutes for Power BI to make connections, load data into my tables, all the normal things Power BI does when it opens a template. This is a routine task and it was pulling data from a SQL Server.

However, once the data was fully loaded, approximately half the graphs did not display. They did not show an error, but they didn't display any values. X and Y axes could be seen as well as row headers, but charts and tables did not contain values.

I was able to remedy the sitution by manually refreshing all the Dim tables in my template (Right-click each individual table name in the fields bar, "Refresh Data"). Hitting the global "refresh" button in the Home bar did not work.

I was hoping someone else had experienced this issue before and/or was able to determine a root cause or find a better solution than refreshing each individual table. Thanks!