Refresh Errors!

[TomBarnard1993]

I keep getting the following error when trying to refresh Power BI - 

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

I am querying Sage 200 with their own custom connector. 

The refresh will work but I will have to try about 10 times for it to do so. 

Full error - 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: Customers.

I have tried so much here and cannot get to the bottom of the issue. Please help thanks 

[TomBarnard1993]

Thanks but why could that be? It seems to work mostly fine in the query editor but as soon as I want to load it into a report it gives me this error? Thanks 

[lbendlin]

The query editor is usually limited to a subset of rows, 1000 or less. Maybe the full load is overwhelming the source.

[TomBarnard1993]

Thanks but I dont think so as I have trailed this with smaller queries of no more than 10 rows 

[lbendlin]

The error means that the call to Sage 200 returned no data.

Read about try ... otherwise ...