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 2...
Need Help
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