Date Error while Refreshing

Ramnath — Thu, 27 Aug 2020 11:50:30 GMT

I am getting the below error while scheduling the Power BI report in server. But I am able to refresh the same report remotely from my PC. Any help is much appreciated.

Refresh failed:

NI Card Report has failed to refresh.
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.

{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"We couldn't parse the input provided as a Date value."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Detail","detail":{"type":1,"value":"1/13/2019"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataFormat.Error"}}],"exceptionCulprit":1}}} Table: Commercial_dlk_Card_Accounts.

Re: Date Error while Refreshing

Greg_Deckler — Thu, 27 Aug 2020 11:53:56 GMT

Ramnath - It's could just be a temporary issue. However, it looks like you have an improperly formatted date in your data and maybe you need to look at doing some data cleanup.

You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

topic Re: Date Error while Refreshing in Report Server

Date Error while Refreshing

Re: Date Error while Refreshing