SAC error "status:500 body:Internal Server Error" on import

Hello,

I have set up an OData connection from SAC to Business ByDesign. I have a Cloud Datasource with thousands of records. I have created a Report in ByD and assigned it to a Work Center.

I first tried to Generate OData Queries directly from the Report in ByD but SAC gave an error when I tried to create the connection with this link.

I then just set up the Odata connection in SAC using the Work Center. I was then able in SAC to select the Report, however, during importing I just get this error "status:500 body:Internal Server Error".

How can I get this data into SAC?

Thanks