undefinedMicrosoft.Mashup.Engine1.Library.Resources.HttpResource: Request failed: OData Version: 3 a

[StephenNeild]

Hi,

We hae recently connected to Sharepoint and had no issues, now randonmly we are receiving the below error message.

The report has been sceduled to refresh and worked okay, now it is intermitant, has anyone seen this before and what is the 

resolution? 🙂

It happened last week then just started working again now its failed again - please help. 🙂

Microsoft.Mashup.Engine1.Library.Resources.HttpResource: Request failed: OData Version: 3 and 4, Error: The remote server returned an error: (500) Internal Server Error. (Internal Server Error) OData Version: 4, Error: The remote server returned an error: (500) Internal Server Error. (Internal Server Error) OData Version: 3, Error: The remote server returned an error: (500) Internal Server Error. (Internal Server Error)

Thanks,

Steve

[Anonymous]

Hi @StephenNeild ,

The error message you are seeing usually indicates a problem on the server side. We can try the following steps to explore the cause and resolve the issue:

1. If you are using Large semantic models, make sure it uses the Large semantic model format in Power BI. Otherwise it may cause timeout or server error during data refresh.
2. Ensure that the account used for data refresh has the correct permissions, permission changes or authentication issues may cause intermittent failures.

I also recommend that you review here, which describes common problems associated with OData sources, including authentication and denial of access errors.

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[StephenNeild]

Hi Ada,

Thanks for response much appreciated - its so intermittent and is now starting to show a pattern.

It only happens on a Wednesday which it happened again yesterday then suddenly starts to kick back in so it’s really strange.

Any ideas or views why it doesn’t like Wednesdays?

Thanks,
Steve