I'm currently encountering the same issue. Submitted bug reports to Google. It's happening with a couple of different files for our company.

One workaround that's worked temporarily is to make a copy of the file (and do no more BigQuery refreshes). That's at least allowed some users to temporarily access the data who were just getting the blank PivotTable, but it's not a real solution.