Forum Discussion

mr-budd's avatar
mr-budd
Frequent Visitor
7 years ago
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...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    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. 

    refresh-greyed-out

     

    Best Regards,
    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

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. 

refresh-greyed-out

 

Best Regards,
Dale

isThatAFrog's avatar
isThatAFrog
Frequent Visitor
4 years ago


 Hi v-jiascu-msft
I have the same issue but for a sharepoint site, should I also change it to an excel and how would I go about that?