I don’t have the answer to your question, but here is an alternative.
I attended a session at the last Insights about the difference between the different reporting and analytics tools for Epicor, about why and when to use them. Here is what I learned.
Tools like PowerBI (and future Epicor Grow) are not meant to be used with real-time data. They are to be used with relatively small to medium datasets (< 18 months) and help you understand what has happened.
To look at what is happening now (real time), Epicor EDD (Data Discovery) is best suited for the task.
The roadmap is not crystal clear for those data analytics tools however, some say that Grow will eventually replace EDD, god knows.