Data explorer should work to get the data. In this topic is the query which returns the post count per date like the dashboard report
I think it won’t be affected by Private Topics, so it could work for you without changing anything.