Scheduled Refresh is disabled

[pratk30]

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 pritty simple as i have done this before in other tenant.

I am getting below error after clicking on Schedule button.

Can't refresh your data
The credentials you provided for the data source are invalid. Please check the credentials for all the data sources.
Please try again later or contact support. If you contact support, please provide these details.
Activity ID: 10db4d23-0682-4bb8-9c90-0b3e2977ccad
Request ID: 7829dce5-afa4-e3d4-58fc-cade973a2a07
Correlation ID: 37884ead-991f-ecb8-2ff2-05c8e9b6e39e
Status code: 400
Time: Sat Nov 17 2018 19:04:48 GMT+0530 (India Standard Time)
Version: 13.0.7382.186
Cluster URI: https://wabi-east-asia-a-primary-redirect.analysis.windows.net

When i am going to schedule refresh for sharepoint online data, i see button is disabled. 

Any idea on this ? i'll be thankfull guys. 🙂

Regards,

Prateek 

[GilbertQ]

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]

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]

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.