How to get Realtime data from google sheets

[ajai1109]

How to get Realtime data from google sheets to power bi. Please help me.

[amitchandak]

@ajai1109 , Not sure on realtime. Maybe use a small refresh cycle.

In this blog, you will get staps to connect to google sheet

https://community.powerbi.com/t5/Power-Platform-Integrations/Power-Apps-Power-BI-Better-together-Wri...

[ajai1109]

Thanks for you reply. Actually the requirement is to get and update live google sheets data to power bi report

[v-lionel-msft]

Hi @ajai1109 ,

Try to refer to the link.

Microsoft Power BI: Real-time dashboard with Google Analytics Realtime API - BRK3065 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.