I have linked our Sage 200extra account which runs on a remote server with Power BI. It works sometimes at refreshing data but 90% of the time is returns the below errors. The refresh tends to work on in query editor but basically never in the data view. Have tried a variety of solutions and nothing has worked. All nulls have been removed and it makes no difference. Any ideas would be apprichited. Thanks 

ERRORS; 

Expression.Error: We cannot apply field access to the type Null.
Details:
Value=
Key=company_name

OR more details in this version::; 

Data source error: {"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 cannot convert the value null to type Table."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"Expression.Error"}}],"exceptionCulprit":1}}} Table: Delivery Charges.