Scheduled Refresh Failed

[reid]

I have two reports that have both failed a scheduled refresh. The error message I received for both is the same.

Failure details: The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support.

The Date value must contain the Date component. Table: Calendar.

What does this mean and how can I fix it? I am able to manually refresh both reports.

[v-diye-msft]

Hi @reid ,

In your scenairo, did the error occur suddenly or often? You can use Fiddler to monitor backend process during refresh. Please take a look at this article: Tools for troubleshooting refresh issues.

[reid]

@v-diye-msft the reports were just re-created and started happening from the initial refresh. We moved from a hosted version of Sharepoint to Sharepoint Online (O365). I had a ticket opened with Microsoft support yesterday.

Thank you for your reply. I read that link you posted prior to putting up the message here in the community. My scenario is not listed there and as is usually the case, the error messages are cryptic and not really useful in determining the root cause of the failure.

[GilbertQ]

Hi there

Could you check to make sure that your Gateway is up and running?

Also what version of the power BI Gateway is installed?

[reid]

@GilbertQ Power BI desktop is version 2.64.5285.741. There is no gateway as all the data is in the cloud (OneDrive, Sharepoint Online and Salesforce.com Objects).

[GilbertQ]

Hi there

Has the refresh worked before?

[reid]

@GilbertQ A previous version of the report was using a scheduled refresh. I had to recreate the reports due to the Sharepoint site being migrated, but otherwise, the other data sources are the same. Any idea what the error message means?

[GilbertQ]

Did you change versions of SharePoint?

I can only think that something is expecting a date column and it is not being returned into the dataset in a date format?

[reid]

@GilbertQ We migrated from on-site  to  cloud-based (O365), so that was definitely a change, but i checked and all the dates are formatted correctly. Does anyone from support visit these forums?