Forum Discussion

TomBarnard1993's avatar
TomBarnard1993
Frequent Visitor
2 years ago

Refresh Errors!

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 

Need Help

4 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

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

     

    Read about try ... otherwise ...

  • TomBarnard1993's avatar
    TomBarnard1993
    Frequent Visitor
    2 years ago

    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's avatar
      lbendlin
      Super User
      2 years ago

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

      • TomBarnard1993's avatar
        TomBarnard1993
        Frequent Visitor
        2 years ago

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