Forum Discussion

pratk30's avatar
pratk30
Icon for Advocate I rankAdvocate I
7 years ago

Scheduled Refresh is disabled

Hi Folks,   I am facing an issue after successfully publishing Power BI Report in Workspace. I am unable to scheduled a refresh.   I am using SharePoint list as a DataSource, so it should be prit...
GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
7 years ago

Hi pratk30

 

Are you using the Personal or Enterprise On-Premise Data Gateway.


From the error it would appear that you need to edit the credentials in the Gateway so that it can authenticate to the SharePoint Online list?

  • pratk30's avatar
    pratk30
    Icon for Advocate I rankAdvocate I
    7 years ago

    For SPO it should be like this. Below one is from another tenant, but i am getting these settings disabled in tenant where this error is coming.

     

     

    Problem

     

    • GilbertQ's avatar
      GilbertQ
      Icon for Super User rankSuper User
      7 years ago

      Hi pratk30

       

      Can you have a look in the Advanced Editor in the Power Query Editor.


      If the source is Web.Page or Web.BrowserContents it will require a gateway, if it is Web.Contents it will not require the Gateway.