Power BI Dataset Refresh Error with Google Sheet

Hi, Luchiuda 

To avoid having to constantly reload the credentials, you can configure the On-premises data gateway. This gateway is free and allows you to refresh your data sources automatically without having to manually reload the credentials.

Solved: refresh data automatically google sheets - Microsoft Fabric Community

If your report dataset only contains cloud data sources like Google Sheets, you can manually refresh the dataset by using the Refresh now option. Power BI automatically connects to the workbook on OneDrive, or SharePoint Online, about every hour to check for updates. If the workbook has changed, Power BI will refresh the dataset and reports in the Power BI service.

Data refresh in Power BI - Power BI | Microsoft Learn

If your dataset contains both cloud and on-premise data sources, then it needs to use the gateway, and then you can configure schedule refresh. Note that you also need to select Allow user’s cloud data sources to refresh through this gateway cluster option under Gateway Cluster Settings.

Best Regards,

Community Support Team _Charlotte

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