SQL Data did not truly refresh

[Adam1125]

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!

[RMDNA]

@Adam1125,

If you go into "Edit Queries," are any of your tables unchekced for "Include in report refresh?"

This would cause the behavior you're seeing - it removes them from the global refresh process, only updating when you trigger them manually.

[Adam1125]

Nope, all the tables that I had to manually refresh had that box checked - it wasn't that.