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
Microsoft 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

  • edhans's avatar
    edhans
    Community Champion
    7 years ago

    FWIW mr-budd you now need a gateway for web sources. I believe it was to ensure that only authorized data was being brought into your Power BI Service. I had to add a simple web page into my gateway just to get a DST table.

  • 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?