Forum Discussion
Solved
Scheduled refresh greyed out
My report has two data sources (a Google Sheet and a Zoho report). Both are "public" so no permissions are required, only the URL. Do I even need to schedule a refresh or will it automatically f...
Hi Dave,
I really found something. Your URLs are parsed as web contents. So Power BI uses Web.Page() function, which requires a data gateway. Please refer to power-bi/refresh-data#power-bi-desktop-file.
>>>If you are using the Web.Page function, you do need a gateway if you have republished the dataset or your report after November 18th, 2016.
I would suggest you save the Google docs as XLSX format.
Best Regards,
Dale
I have the same issue, my Data Source credentials also greyedout. Help!!!