refresh when changes in datasource

[Maria_Maria]

Hi!

I have a report built with google sheets source. How can I make the report refresh every time when new data is entered into the sheet?

Thanks!

[mhossain]

@Maria_Maria 

See this community thread for simiilar solutions -- https://community.powerbi.com/t5/Power-Query/Auto-refresh-Google-Sheets-data/m-p/151755#M9239

[Greg_Deckler]

@Maria_Maria Try looking at Power Automate although I am not sure there is a trigger for Google Sheets but you can use Power Automate to initiate a Power BI dataset refresh.