Refresh

[MSAYED26]

Hi, I have an excel sheet in google drive it updated continuously by app sheet ,If I take link for this sheet and connect with power bi, how can I make embed link refresh continuously 

[rajendraongole1 · Accepted solution]

Hi @MSAYED26 -you can try below steps to get the refresh updates from drive as below: you can use the direct link from web and follow:

Get Data>>Select Web>>Choose Web as the data source>>Enter the URL:

Paste the modified URL (https://docs.google.com/spreadsheets/d/{sheet_id}/gviz/tq?tqx=out:csv) into the URL box and click OK >>Load Data>>Power BI will connect to the Google Sheet and load the data as a CSV file.
Transform Data>>Use Power Query Editor to clean and transform the data as needed. Click Transform Data to adjust your dataset.

Reference:

Solved: refresh data automatically google sheets - Microsoft Fabric Community

Solved: Google Sheets Refreshing Issue - Microsoft Fabric Community

Solved: Google Sheet connection won't update - Microsoft Fabric Community

Hope it helps

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!