Hi Nimisha, yes, I have.
I use Coefficient to get data from HubSpot into Google Sheets, then use Power BI to connect the sheets and build my data model for reporting.
Coefficient updates hourly, and power BI is set to update multiple times a day. It's not exactly real-time, but pretty close.