Forum Discussion
Refresh
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
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!!
1 Reply
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!!