Dear Gassim,
Many thanks for your response earlier. I went back to troubleshoot, and the problem was actually minor. I had selected some analytic restrictions - in my user profile, see here;
When these dimensions were not present in my data selections for both the data visualizer and the pivot table, in returned no data. Hope this helps another implementer the troubleshooting in future🙈.
Best Wishes