One table in pbix is not refreshing

[timhopson]

I have a pbix with lots of tables.

When I deploy to the TEST stage of my pipeline, the report refreshes ok. When I deploy to the PROD stage, there is one table (possibly others?) that doesn't refresh. 

I copied the affected table into a report on it's own and deployed that directly to PROD and it refreshed ok. 

I've checked:

- the 'Enable Load" and "Include in Report refresh" are checked.

This particular table has no dependencies on other tables.

Very strange, I've never encountered this problem.

[timhopson · Accepted solution]

I'm just updating this as I found a work-around. I re-deployed the pbix from TEST to PROD and the problem went away. 

Problem solved, hopefully never to return.