Getting near real time dashboard with google analytics data

jimmymitra,

If you need to refresh the visuals every 5 mins in Power BI, you can create a real-time dashboard, for more details, please review this similar thread. Then you can share the dashboard  to your users, however, in this case, users will see all the data in the dashboard.

If you need to dispaly different data in visuals for different users, use Google analytics connector in Power BI Desktop to connect to your data source, then define Row Level Security. After you create report in Power BI Desktop, you can publish the report to Power BI Service and set schedule refresh for your dataset. You can purchase Power BI Premium license to have more frequent refresh schedule. With this license, you can refresh your dataset every 30 mins.

In addition, if you choose  the second method that described above, you don't need to store Google analytics in other source, just use Google analytics connector in Power BI Desktop.

Regards,
Lydia