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 mr-budd,

 

Yes, the public data sources don't need any credentials. But we still need to verify it. Please refer to the snapshot below.

Scheduled_refresh_greyed_out

 

Best Regards,
Dale

  • mr-budd's avatar
    mr-budd
    Frequent Visitor
    7 years ago

    Thanks for the reply Dale, v-jiascu-msft. It must be a credentials problem of sorts. Our corporate email has two domains (@pipint.com and @pip.global).  It says the dataset was created by my @pip.global account, however the PowerBi account I always use is the @piptin.com. They can't even find my @pip.global address if I try to log in (see second screenshot).

     

    I can only log in with @pipint.com email, and it won't let me edit the "Data source credentials" section, which is probably why the "Scheduled refresh is greyed out"? Is it this separate email that is preventing me from editing?

     

    • v-jiascu-msft's avatar
      v-jiascu-msft
      Microsoft Employee
      7 years ago

      Hi mr-budd,

       

      You need to choose a gateway first. Then "Data source credentials" option will be highlighting.

       

       

      Best Regards,
      Dale

      • mr-budd's avatar
        mr-budd
        Frequent Visitor
        7 years ago

        Thanks again Dale.

         

        I was hoping there was a way to do it without running a personal gateway on my computer, since the data sources are public (Google, Zoho). But I guess that's not an option?